Excel: Insert Tables From Web

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 Worksheet” to import into a new sheet.
  9. Click Properties, uncheck Save Query Definition*, and click OK.
    *Alternatively, to maintain a link to variable data, leave Save Query Definition checked; you will be prompted to ‘Enable Content’ each time the file is opened.
  10. Click OK to complete the import.
Additional reading..

Cheers!

hɔuᴉnb

Comments and questions are always welcome!

Enter your email address to follow this blog and receive notifications of new posts by email.