How to Import a Web Page to Excel 2007

Import Data from Web Page
1. Open both your Internet browser and Microsoft Excel 2007 program. Go to the web page that you want to import into Excel.
2. Go the Data tab on the user interface in Excel. In the 'Get External Data' command set, click 'From Web.' A 'New Web Query' box will appear on the screen.
3. Type in the web page that you want to import into Excel, if it does not automatically appear in the 'New Web Query' box. Select the 'Import' button. Excel will then give you the option to select the cell in which you want the web page information to be placed.
4. Select either Existing Worksheet or New Worksheet. If using an Existing Worksheet, choose the cell column and row. Press 'Okay' when complete. The information from the web page will then appear in the worksheet.
Copying and Pasting web page into Excel 2007
5. Copy the web page information by highlighting the information you want on the web page and pressing 'Control' and 'C' (Ctrl C) at the same time.
6. Go to Excel, select the cell in which you want the information to appear. Press 'Control' and 'V' (Ctrl V) at the same time to paste the information. You can also select 'Paste Special' in Excel by single right-clicking on your mouse. 'Paste Special' will give you the option to add the hyperlink or web page text to the Excel cell.
7. Click 'Okay.' The information will appear in the selected cell.
Export web page into Excel
8. Go to the web page that you want to import into Excel.
9. Right-click with your mouse and choose 'Export to Excel.' This will take you directly to Excel.
10. Select 'Import' on the 'New Web Query' box. The 'Import Data' box will appear.
11. Select the 'New or Existing Worksheet' and cell in which you want the data to appear. Click 'Okay.' The web page data will appear in Excel.