Pull website data in Excel

by | Feb 9, 2018

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 on Linkedinchris menard on Youtube
chris menard
Microsoft Office Master Instructor
I train corporate clients in Microsoft Office Excel, PowerPoint, Word, and Outlook. When I'm not training, I blog about technology and create training videos on YouTube. I currently have over 240 technology videos available. Most of the videos I've created come from questions asked during MS Office training.

Pin It on Pinterest