Microsoft Excel

Excel Import Data from the Web

Chris Menard

17 Jan 2023 — 1 min read

Excel allows you to pull data on a webpage into Excel. This is a great time-saving feature. Getting data from a webpage is done in Excel on the Data Tab using Get and Transform Data group, From Web command.

**Excel - Data From Web**

Get Started

- Find a webpage with Tables on it. **Copy** the URL. - Go to Excel and click the **Data** tab. - Click **From Web**. - **Paste** the webpage URL (screen shot below) - Click **OK**.

**Paste webpage URL**

- The tables on the webpage will appear. Click the table you want to pull into Excel. You get a preview of the data. - Click **Load** or you can use Power Query to clean the data.

**Tables found on the webpage**

YouTube Video

Excel Import Data from the Web - Great Time Saving Feature

Chris Menard to Present “Mastering Microsoft 365 Copilot” at EA Ignite Conference

Chris Menard will present “Mastering Microsoft 365 Copilot” at EA Ignite in Nashville on Nov 3, 2025. Learn how Copilot boosts productivity in Word, Excel, PowerPoint, Outlook, and Teams during this hands-on session.

Microsoft Teams: Save Chat and Channel Messages is Back!

How to use the newly returned feature that lets you save Chat and Channel Messages in Teams so you can keep important conversations at your fingertips.

OneDrive Request Files: How to Use OneDrive to Collect Files Securely

OneDrive Request Files feature allows you to collect files from people inside or outside your organization, without letting those people see anyone else’s uploads.

Master Microsoft Teams Follow Threads to Boost Your Productivity

As a Microsoft MVP and certified trainer, I’m always excited to share the latest productivity tools that help you work smarter. If you’re a frequent Microsoft Teams user, you’ll be thrilled to hear about the new Teams Follow Threads feature rolling out in public preview as of