Excel Import Data from the Web

Share
Excel Import Data from the Web

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

**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

**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

**Tables found on the webpage**

YouTube Video

Excel Import Data from the Web - Great Time Saving Feature

Read more

Copilot Skills in PowerPoint - Live Stream on October 20, 2026

Copilot Skills in PowerPoint - Live Stream on October 20, 2026

𝗠𝗼𝘀𝘁 𝗣𝗼𝘄𝗲𝗿𝗣𝗼𝗶𝗻𝘁 𝘂𝘀𝗲𝗿𝘀 𝗸𝗻𝗼𝘄 𝗖𝗼𝗽𝗶𝗹𝗼𝘁 𝗰𝗮𝗻 𝗰𝗿𝗲𝗮𝘁𝗲 𝘀𝗹𝗶𝗱𝗲𝘀. 𝗙𝗮𝗿 𝗳𝗲𝘄𝗲𝗿 𝗸𝗻𝗼𝘄 𝗮𝗯𝗼𝘂𝘁 𝘁𝗵𝗲 𝟴 𝗯𝘂𝗶𝗹𝘁-𝗶𝗻 𝗖𝗼𝗽𝗶𝗹𝗼𝘁 𝗦𝗸𝗶𝗹𝗹𝘀 𝘁𝗵𝗮𝘁 𝗰𝗮𝗻 𝗰𝗼𝗺𝗽𝗹𝗲𝘁𝗲𝗹𝘆 𝗰𝗵𝗮𝗻𝗴𝗲 𝗵𝗼𝘄 𝘆𝗼𝘂 𝗯𝘂𝗶𝗹𝗱, 𝗶𝗺𝗽𝗿𝗼𝘃𝗲, 𝗮𝗻𝗱 𝗽𝗿𝗲𝘀𝗲𝗻𝘁 𝗮 𝗱𝗲𝗰𝗸. Join me live on October 20, 2026, at Noon Eastern as I demonstrate each Copilot Skill and show practical ways to use them in your presentations. PDF of the 8 Copilot Skills in Pow

By Chris Menard