Use the Insert from Web option, to quickly import tables from web pages into Excel.

Watch this 2 minute video to see all you need to know.

To Insert Data From Web into Excel

1. Using your web-browser, locate the content to be imported.
2. RIGHT + CLICK in the addressbar and select Copy.
3. In Excel, on the Data tab of the Ribbon, click From Web. A New Web Query dialog will appear.
4. RIGHT + CLICK in the addressbar, select Paste, and click Go. The source webpage will populate the dialog.
5. Click the yellow arrow  next to the table(s) you wish to copy (the icon will change to a green check   ).
6. Optionally, click Options and select formatting preference (i.e., None, Rich Text, HTML) then click OK.
7. Click Import. The Import Data dialog will appear.
8. Select starting cell to import data to or select “New…