For this tutorial, you will need to have Power Query installed. If you are running Office 2016, Power Query should already be available. For Excel 2010 and 2013, here is a link to the download: Power Query
Power Query makes pulling data from a website quick and easy. In this example we will be extracting data from the Wikipedia page “List of NCAA Men’s Division I Basketball champions“. Here is a link to the website: Link to Wikipedia Site
If you open up the Wikipedia page and scroll down a bit, you will see a table: Championship games, by year, showing winners and losers, final scores and venues. This the table we will be extracting into Excel.
- Open up a new Excel workbook. Locate the Power Query Tab on the Ribbon Bar
- Select Web Page
- In the pop up window, copy and paste the URL to the Wikipedia Page
- Click Ok
5. Notice as you click through the list of tables on the left side of the screen, the tables appear in the preview screen on the right.
6. Select Championship games, by year….
7. Click Load
Congratulations. You now have the table from the Web in an Excel sheet.