How to export a range of data from Excel to HTML or web page file?

If you need to export a range of data as a web page (HTML file), how do you deal with it? This article will talk about ways about how to export 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


Export a range of data from Excel to Html / Pdf / Csv / Txt file:

Kutools for Excel's Export Range to File feature can help you quickly export and save a range of cells into a specific Html / Pdf / Csv / Txt file as you need.

doc export data to html 9

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


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

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

2. Click the File > Save As to save the selected cells.

3. In the Save As dialog box, choose a location where 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 html 1

4. Then click Save button, and you will get into the Publish as Web Page dialog box, click the Publish button. See screenshot:

doc export data to html 2

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

doc export data to html 3


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 : with more than 120 handy Excel add-ins, free to try with no limitation in 60 days. 

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

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

doc export data to html 4

3. In the Export Range to File dialog box:

(1.) Check the Simple HTML option or Complex HTML (all formatting) option as you need.

(2.) Then select the file options, such as background color, font name, size, color as you want to keep.

(3.) And then click doc export data to html 6 button to choose a location to put the exported HTML file.

doc export data to html 5

4. And then click Ok, in the popped out Export Range to File dialog box, please type a new file name for your exported file, see screenshot:

doc export data to html 7

5. Then click OK, and the selected data in excel has been exported to html file.

doc export data to html 8

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…

Click Download and free trial Kutools for Excel Now !


Demo: export a range of data from Excel to HTML or web page file

Kutools for Excel: with more than 200 handy Excel add-ins, free to try with no limitation in 60 days. Download and free trial Now!


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

Comments  

Permalink 0 Sunny Chhabra
WOW. Amazing learning & so helpful. I liked this one very much.. Thanks. :)
2014-05-10 00:05 Reply Reply with quote Quote
Permalink 0 Deb Key
I have an excel spreadsheet and one column I need as html, but I need all columns to merge into a Word document, so I can't save the selection separately from the master spreadsheet. I tried saving the whole sheet as html, but it wouldn't merge either. Any suggestions?
2014-09-29 23:38 Reply Reply with quote Quote
Permalink 0 metric
how to export html to excel using javascript
2015-03-03 08:47 Reply Reply with quote Quote
Permalink 0 metric
help for export html data to excel,i want it to work to all browser.
2015-03-03 09:17 Reply Reply with quote Quote
Permalink -3 luis
It sucks and I absolute dislike this fucking tool
2015-07-14 21:37 Reply Reply with quote Quote
Permalink 0 Fricikoma
Search for HTML-Cleaner.co m a free online tool which has a nice feature to convert Excel, Word etc. to HTML and it can also convert tables to div elements ;)
2015-08-03 10:22 Reply Reply with quote Quote

Add comment


Security code
Refresh