How to Convert HTML Documents to Excel Spreadsheet Files

The Open Command
1. Open your Web browser, then navigate to a Web page you'd like to convert to an Excel spreadsheet.
2. Click your browser's 'File' menu and select 'Save as' or 'Save Page as.' Type a name for the file, then click 'Save.' Jot down the folder into which you saved the file. This file is the stored Web page you'll convert to an Excel spreadsheet.
3. Open Excel, then click the Office button.
4. Select the 'Open' command, then navigate to the Web page you saved to your hard drive in step 2.
5. Double click the file to open it. Excel will import both text and graphics into the current spreadsheet.
6. Click the Office button, then click the 'Save as' command.
7. Type a file name for the workbook and click any item in the 'Type' drop-down list that says 'Excel.'
8. Click 'Save' to save the converted HTML document as an Excel file type.
Use the Data Tab
9. Open Excel, then click the 'Data' tab.
10. Click the 'From Web' button. Excel displays a small browser window. You'll notice small black arrows with yellow backgrounds displayed here and there on the page. These indicate portions of the Web page you can convert to Excel.
11. Click the top most arrow, then click the 'Import' button. Excel will display a dialog box asking you to choose the location for the imported data. Click 'OK' to accept the default option, which is the current spreadsheet. Excel will load the text of the Web page portion you selected.
12. Click the disk icon in the Quick Access toolbar at the top left of the application window.
13. Type a file name for the converted Web page, then click one of the 'Excel' file types in the 'Type' drop-down box.