CornDog Computers

Copy Data from a Table in a Web Page to Excel

posted by Rob Johnson on Apr.15, 2009, under Tips

MS_excel_2007

If you see a data table on a Web page and you want to import it into Microsoft Office Excel:
1. Copy the URL (address) of the page.
2. In Excel, on the Data tab, in the Get External Data section, click From Web.
3. In the New Web Query dialog box, paste the URL into the Address box.
4. Select the table that contains the data you want to work with, and then click Import.
5. In the Import Data dialog box, indicate where you want the data to appear, and then click O


Leave a Reply

You must be logged in to post a comment.

blog comments powered by Disqus

Looking for something?

Use the form below to search the site:

Still not finding what you're looking for? Drop a comment on a post or contact us so we can take care of it!