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

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

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

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

Word - Five Tips for Working with Heading Styles

Word - Five Tips for Working with Heading Styles

Recent Excel Articles

Excel Sorting Tips with Chris Menard on January 24, 2023

Excel Sorting Tips with Chris Menard on January 24, 2023

Excel - Convert Seconds to Minutes and Seconds - Watch Chris Work!

Excel - Convert Seconds to Minutes and Seconds - Watch Chris Work!

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