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

Recommended Productivity Software

Office Tab: Use tabbed interface in Office as the use of web browser Chrome, Firefox and Internet Explorer.
Kutools for Excel: Adds 120 powerful new features to Excel. Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Brings back your familiar menus to Office 2007, 2010 and 2013 (includes Office 365).

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

Hint


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:

doc-export-data-to-html1

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:

doc-export-data-to-html2

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

doc-export-data-to-html3


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:

doc-export-data-to-html4

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.

doc-export-data-to-html5

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.

doc-export-data-to-html6

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:


Is your problem solved?

Recommended Productivity Tools

The following tools will greatly save your time and effort, which one do you prefer?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: 120 powerful new functions for Excel, Increase your productivity in 5 minutes. Save two hours every day!
Classic Menu for Office: Bring back familiar menus to Office 2007, 2010, 2013 and 365, as if it were Office 2000 and 2003.

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 More than 120 powerful advanced functions which designed for Excel:

  • 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