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

Optimizing Excel Formulas with Copilot: A Comprehensive Guide

Optimizing Excel Formulas with Copilot: A Comprehensive Guide
Five Methods for Creating Running Totals in Excel

Five Methods for Creating Running Totals in Excel

Excel is a powerful tool that offers various features to manipulate and analyze data efficiently. One of the useful functionalities it provides is the ability to create running totals, which can be essential for tracking cumulative sums over a period.

Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff 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