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 Copilot for Word: How to Reference a Folder

Microsoft Copilot for Word: How to Reference a Folder

Discover how Microsoft Copilot for Word now lets you reference entire folders and handle documents up to 1.5 million words. Learn step-by-step how to boost productivity with these powerful updates.

Copilot in Word: Quickly Add Numbers with Ease

Copilot in Word: Quickly Add Numbers with Ease

Discover how Copilot in Microsoft Word can quickly and accurately add numbers within your documents, saving you time and reducing errors. Learn to streamline your workflow with this intelligent assistant.

Recent Excel Articles

Excel Training for the University of Georgia's Online and Professional MBA Students

Excel Training for the University of Georgia's Online and Professional MBA Students

Saturday, April 5, 2025: I'll train the University of Georgia's online and professional MBA students in Microsoft Excel. Topics include PivotTables, Filtering, and even Financial Statement analysis.

Copilot in Excel - Ask Copilot Questions about Keyboard Shortcuts, Functions, and Steps

Copilot in Excel - Ask Copilot Questions about Keyboard Shortcuts, Functions, and Steps

Copilot in Excel can be asked for intermediate keyboard shortcuts, how-to steps, and function explanations.

Chris Menard

Chris Menard is a Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Copilot, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events yearly, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.

Categories