HomeSoftwareMicrosoft ExcelHow to Convert a File From *.HTML Format to *.XLSX

8.1. How to Convert a File From *.HTML Format to *.XLSX


Download the HTML page to your desktop.






Open the file with Internet Explorer (IE 6 Or Higher Version)

Right click anywhere on the page in the open IE window

Select the option to Export to Microsoft Excel



It will open a window (New Web Query)

Ensure that the Address at the top of the window points to the location of your saved *.HTML file. If you need to, navigate to the folder in which you saved the file.

Use the yellow arrows  to select the data from the webpage that you wish to enter into the spreadsheet

Once you have finished making your selection, click Import at the bottom of the window



This will open another window asking about inserting a table. Leave the settings as they are and click OK


The newly exported Excel spreadsheet should appear with the selected information entered into the cells

This page was: Helpful | Not Helpful