Excel: Insert Tables From Web


Ask Quincy

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 grnarrw next to the table(s) you wish to copy (the icon will change to a green check grnchk  ).
  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…

View original post 73 more words