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. 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

Your email address will not be published. Required fields are marked *

You May Also Like

In this post, you’ll learn how to Find Blank cells in excel so that you can remove or delete the blank cells form...
In this article, you’ll learn what is a Gauge Chart in Microsoft Excel. Also, you will learn how to add...
Microsoft Excel provides a shortcut for the users to move columns in excel using two different ways – using Shift...