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