How to export Excel data as HTML in Microsoft Excel?

If you need to export Microsoft Excel data as a web page (HTML file), how will you deal with it? This article will talk about ways about how to export Microsoft Excel data in selection to an HTML file quickly.

Export Excel data to html files with the Save As command

Export Excel data to html files with Kutools for Excel

arrow blue right bubble Export Excel data to HTML file with Save As command

Using the Save As command can save a selection data in Microsoft Excel  as a web page (html file).

Step 1: Select the range you want to export as html file.

Step 2: Click the File tab in Excel 2010 or click the doc-office-2007-button button in Excel 2007;

Step 3: Click Save As button;

Step 4: In the Save As dialog box, choose a location that you will put the file, and select the Web Page from Save as type section, and then check the Selection in Save section. See screenshot:


Step 5: Click the Save button.

Step 6: Now you will get into the Publish as Web Page dialog box, click the Publish button. See screenshot:


And then the selection has been exported as an html file. See screenshot:


arrow blue right bubble Export Excel data to HTML file with Kutools for Excel

Kutools for Excel's Export Range to File can help you export a range data in Microsoft Excel as html files quickly and conveniently.

Kutools for Excel includes more than 120 handy Excel tools. Free to try with no limitation in 30 days. Get it Now.

Step 1: Select the range you want to export as html file.

Step 2: Click Enterprise > Import / Export > Export Range to File…. See screenshot:


Step 3: Check the Simple HTML option or Complex HTML (all formatting) option in the Export Range to File dialog box.

If you do not want to keep the formatting of data in exported HTMl file, such as background, font size/color/name, or other formatting, please check the Simple HTML option, and don’t check any options from right section. Meanwhile, you can choose the specific formatting that you need.


If you want to keep all formatting in exported HTML file, please check the Complex HTML (all formatting) option. Also you can specify the title for this range data by checking Use this title.


Step 4: Then click OK, and choose the location that you want to put the file in. And the selected data in excel has been exported to html file.

Kutools for Excel's Export Range to File makes it possible to easily export a range of date to a file, either an Excel workbook, a CSV, a text file, a simple HTML or all formatting HTML. Click to know more…

Related articles:

Recommended Productivity Tools

Office Tab

gold star1 Bring handy tabs to Excel and other Office software, just like Chrome, Firefox and new Internet Explorer.

Kutools for Excel

gold star1 Amazing! Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day!

gold star1 200 New Features for Excel, Make Excel Much Easy and Powerful:

  • Merge Cell/Rows/Columns without Losing Data.
  • Combine and Consolidate Multiple Sheets and Workbooks.
  • Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
  • Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,
  • More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools...

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Add comment

Security code