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

Kutools for Excel: add 120 new features in Excel. Save one hour every day.
Classic Menu for Office: brings back classic menus to Office 2010 and 2013 (includes Office 365).
Office Tab: brings tabbed interface to Office as the use of web browser Chrome, Firefox and Internet Explorer.

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

Hot
Amazing! Using Tabs in Excel like Firefox, Chrome, Internet Explore 10!

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:


Kutools for Excel

More than 120 Advanced Functions for Excel 2013, 2010, 2007 and Office 365.

screen shot

btn read more     btn download     btn purchase

Comments  

-1#urHelper2014-03-04 07:15
this is good example
you can also do same thing excel to html online convert on http://codebeautify.org/excel-to-html
Reply | Reply with quote | Quote
0#Sunny Chhabra2014-05-10 00:05
WOW. Amazing learning & so helpful. I liked this one very much.. Thanks. :)
Reply | Reply with quote | Quote

Add comment


Security code
Refresh