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  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 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..

• Insert Screenshot (askQuincy.Wordpress.com)
• Insert a screenshot in Word 2010 (Productivity Hub, technet.com)

Cheers!

hɔuᴉnb

Comments and questions are always welcome!

Author: quincy harley jr

Quincy is a technophile, coach and Learning Development expert. He has an extensive legal IT background and is practiced in MS Office application support and product development. As a project leader he has been integral in numerous new application rollouts. Whatever spare time he has, is spent with reading, archery and watching his young sons grow. View all posts by quincy harley jr