Excel Import Data from the Web

Posted on:  01/18/2023
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

Other Excel Articles

  • Three tips for getting started with Excel Charts

    Charts in Microsoft Excel are easy. This short video shows three tips for creating charts. I'll cover two keyboard shortcuts for making charts, using Recommend Charts, and creating charts using Quick Analysis.

When you pull data from the web, you can pick the table on the webpage you want to use since many webpages have multiple tables on them.

You can also use PowerQuery to correct any web data that has the wrong data type or data you don't need. A connection to the webpage is made, and when the data changes on the webpage, the data can be automatically updated in Excel. That is AWESOME! 

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

Recent Word Articles

Microsoft Word to Adobe Acrobat with Bookmarks

Microsoft Word to Adobe Acrobat with Bookmarks

We don't usually want to email, or share are Word files. Frequently, we make our Word documents PDF files. If you lay out your Word document correctly, it is easy to make bookmarks in the PDF.

Dictate Feature Updates in Word, Outlook, PowerPoint, and OneNote

Dictate Feature Updates in Word, Outlook, PowerPoint, and OneNote

Dictate in Word, Outlook, OneNote, and PowerPoint allows users to use speech-to-text to author content in files.

Recent Excel Articles

Excel 3D Reference - easily reference data on another worksheet

Excel 3D Reference - easily reference data on another worksheet

A 3D reference in Excel is a simple method to pull data from another cell, another worksheet, or a range of worksheets. Changes in the source will reflect in the destination.

What is the Middle Class and Are You in the Middle Class?

What is the Middle Class and Are You in the Middle Class?

What is the middle class and are you in the middle class? To figure out if you are in the middle class, we need to know the median household income, how many people are in your household, and where you live.

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 900 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 16 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube

Categories