How to export Excel data as HTML?

Exporting Excel data as HTML starts with having a file with data, such as this:

Data preparation 

 

export Excel as HTML data table

Select all the data, and then click on File.

export Excel as HTML ribbon click file

Click Save as and browse to the folder where you want to save the file.

export to html

 

Publishing the file

Give the file a title beside file name (1). Choose web page in the Save as type (2), choose selection (3), and press publish (4).

export Excel as HTML publish as webpage

 

Check the AutoRepublish every time this workbook is saved, and then click publish.