Pull website data in Excel

Pull website data in Excel

If you see data on a webpage and need to pull it into Microsoft Excel, don’t copy/paste. Excel 2016 has a feature called Get Data / From Other Sources / From Web.

In the example below I’m pulling population data for the 50 states from Wikipedia into Excel. If you were to select the data and copy and paste you frequently get images and bad data in Excel. The specific page I used is located here.

YouTube Video of pulling data from a webpage into Excel

Chris Menard

Chris trains corporate clients in Microsoft Office Excel, PowerPoint, Word, and Outlook. When he's not training, he blogs about technology and creates training videos on YouTube. Chris currently has over 240 technology videos available, most of which have been created following questions asked during Microsoft Office training sessions.

Categories