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.

Chrome:

Firefox:

IE:

 

 

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