Saturday, January 14, 2012

How to Convert a Webpage Table to an Excel Spreadsheet


How to Convert a Webpage Table to an Excel 2003 Spreadsheet
1. Open the Excel worksheet into which you want to import the webpage table. Go to the 'Data' menu, point to 'Import External Data' and select 'New Web Query.' The 'New Web Query' window will open.
2. Type or paste the webpage address into the 'Address' bar and click 'Go.' The webpage will open in the dialog box with arrows to the left of each available table.
3. Click the arrow beside to table that you want to convert from the webpage to your Excel spreadsheet.
4. Click the 'Import' button. The 'Import Data' dialog will open. Under 'Where Do You Want to Put the Data,' select 'Existing Worksheet' and click 'OK.'
5. Wait while Excel converts the table to your worksheet. Modify the table and save your changes as desired.
How to Convert a Webpage Table to an Excel 2007 or 2010 Spreadsheet
6. Open the Excel worksheet into which you want to import the webpage table. Go to the 'Data' tab.
7. Click 'From Web' in the 'Get External Data' group. The 'New Web Query' window will open.
8. Enter or paste the webpage address into the 'Address' bar. The address may be up to 255 characters in length. Click 'Go' to navigate to the webpage.
9. Click the arrow icon next to the table you want to convert to your spreadsheet or click the arrow icon at the top left of the window to import the entire webpage. If you do not see arrows on the webpage, click the 'Show Icons' button on the 'New Web Query' toolbar.
10. Click the 'Import' button and Excel will convert the webpage table to your worksheet.

Blogger news