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

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.