How to Copy a Table from a Web Page to Excel 2010

Recently, I posted an article on iTunes keyboard shortcuts. The shortcuts were detailed in a table format. Now, if you want to copy the table from the web page onto Excel following the usual copy and paste or copy and paste special process, you will find that the content is skewed and badly formatted. Luckily, Excel 2010 provides a simple way to accomplish this task. In this tutorial, I’ll show you how to copy a table from a web page in a few quick steps.

How to Copy a Table from a Web Page to Excel 2010

1. Open a new Excel 2010 worksheet.

2. On the Data tab, in the Get External Data group, click From Web.

How to Copy a Table from a Web Page

3. In the New Web Query dialog box, in the address bar, enter the web page containing the table you want to copy. Alternatively, you can use Google search to navigate to the desired page. Then click Go.

new web query

4. Observe as you scroll through the page that there are small yellow arrow icons through various sections of the web page.

5. Scroll to the table section, click the yellow icon, and then click Import.

yellow icon

5. In Excel 2010, in the Import Data dialog box, select the cell in the worksheet you want to place the data and click OK.

import data

You will have to wait for a few minutes for the data to get populated in the Excel worksheet. This of course depends on the volume of data you are importing.

Once the data is imported save the worksheet data.

This is a pretty cool and easy way to get table data from websites and will be helpful when you want to research and analyze specific information from the internet.

You can follow us on Twitter or join our Facebook fan page to get tutorials, updates and how-to articles on Microsoft, Google and Apple products.

About Adeline Gear

Adeline is a tech enthusiast who loves exploring the latest tools and applications in the marketplace. She also loves her Android and spends time reviewing apps and games on android-resources.net.

Comments

  1. I’m using microsoft office 2010 on my laptop. It’s hard to run. It’s helpful and good for me… Thanks for the post…