HomeMicrosoft OfficeExcelHow to Export Excel data as HTML in Microsoft Excel 2016?

How to Export Excel data as HTML in Microsoft Excel 2016?

There are times when you might need to export the excel data to a HTML web page and its pretty easy to do it with Microsoft Excel 2016.

How to Export Excel data as HTML in Microsoft Excel 2016?

You can use the Save As command in Microsoft Excel to perform this.

1. Select the range of cells that you want to export as HTML file in excel sheet.

2. Click the File Tab in Microsoft Excel 2016 and the select “Save As”.

image

3. This should display the “Save As” screen. Select “This PC” and then click on the “Browse” button. In the Save As dialog , select the radio button “selection” and the value “Web Page” from the Save as type combo box. Also select the path where you want this to be saved. In this example , we will be saving the file in the Documents folder. Click the “Save” button.

image

4. In the “Publish as Web Page” dialog , leave the options as it is and then click the “Publish” button.

image

5. Go back to the path where the file is saved and open the htm page , you should see the selected cells being displayed in the webpage.

image

    1 Comment

  1. User Avatar
    Sandhya
    April 14, 2023
    Reply

    Excel has a very simple mechanism for exporting data to HTML.
    Excel data can be exported into HTML even by novice users.

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021