Home » Excel Spreadsheet » Convert Excel Spreadsheet To Html Table

Convert Excel Spreadsheet To Html Table

Convert Excel Spreadsheet To Html Table– How to Convert Excel Sheets or Cells to an HTML Table?

Suppose you have a range of cells and you want to convert the range of cells into an html table as shown below, how can you handle it quickly? In this article, I present some tricks to help you easily convert a sheet or a range of cells into an HTML table in Excel.

Convert Excel Spreadsheet To Html Table

Convert Excel Spreadsheet To Html Table

Convert Excel Spreadsheet To Html Table

Office tab: enable editing and tabbed browsing in Office and make the job much easier … Read more … Download …
Kutools for Excel: the best Office productivity tool brings advanced features of 300 to Excel
Super Formula Bar (easily edit multiple lines of text and formulas); Reading design (easily read and edit a large number of cells); Paste in filtered range …
Merge cells / rows / columns and maintain data; Content of divided cells; Combine duplicate rows and sum / average … Prevent duplicate cells; Compare ranges …
Select Duplicate or Unique Rows; Select Blank rows (all cells are empty); Super Find and Fuzzy Find in many workbooks; Random Selection …
Exact copy of several cells without changing the formula reference; Automatically create references to several sheets; Insert bullets, check boxes and more …
Favorite and quickly insert formulas, ranges, graphics and images; Encrypt cells with password; Create mailing list and send emails …
Extract text, Add text, Delete by position, Delete space; Create and print paging subtotals; Convert between cell content and comments …
Super filter (save and apply filter schemes to other sheets); Advanced Sort by month / week / day, frequency and more; Special filter for bold, italic …
Combine workbooks and worksheets; Merge tables based on key columns; Split data into several sheets; Batch conversion xls, xlsx and PDF …
Grouping of dynamic tables by week number, day of the week and more … Show unlocked and locked cells by different colors; Highlight cells that have formula / name

1. Select the cells you want to convert, and click Send the> Save As> Search to display the Save as window. See screenshot:
doc cell to html table 2

2. In the Save as window, specify a folder in which you will place the html table, type the file name you use and then select Web Page From Save as type the drop-down list. You can then choose to save the workbook or just the selection in the html table by checking Full workbook or Selection option. See screenshot:
doc cell to html table 3

3. Click SAVE, a Publish as web page pop-up dialog box, and you can click Change to specify the title, if you want to automatically update and republish the html table every time, check AutoRepublish every time this workbook is saved, and if you want to automatically open this web page after saving it, see Open the web page published in the browser. See screenshot:
doc cell to html table 4

4. Click Publish to finish saving
doc cell to html table 1

blue arrow right bubble Convert Cells In Html Table With Formulas
If you want to convert cells to html table format and copy it to an html editor as shown below, you can do the following:
doc cell to html table 5

Kutools for Excel, with more than 120 practical Excel functions, improve your work efficiency and save work time.
Go to download
Free 60-day trial Buy
PayPal / MyCommerce
1. Enter these texts in a range of cells as shown below:
doc cell to html table 6

2. Then go to the next cell, here is H1, and enter this formula = D1 & E1 & A1 & F1 & E1 & B1 & F1 & E1 & C1 & F1 & G1, press enter, and then drag down the formula to the cell you need.
doc cell to html table 7

3. Then, copy these formula cells and paste them as value in another location. Select formula cells and press Ctrl + C and select a blank cell, J1 and right-click to select Paste as an option value in the context menu. See screenshot:
doc cell to html table 8

4. You can then copy the range of cells to the html editor and enter tbody table, Kayak and / tbody / table separately at the beginning and end of the string range. See screenshot:
doc cell to html table 9

Now Excel cells have been converted to an html table.

blue arrow right bubble Convert Cells In Html Table With Kutools For Excel
If you have Kutools for Excel – a useful Excel tool, you can apply your Export Range to File utility to quickly convert Excel cells to the html table / pdf table / Unicode text table, etc., as you need.
pay attention1 If you are interested in this add-on, download the 60-day free trial.
Kutools For Excel: The Best Office Productivity Tool Brings Advanced Features From 300 To Excel
Super Formula Bar (easily edit several lines of text and formula); Reading design (easily read and edit a large number of cells); Paste in filtered range …
Merge cells / rows / columns and maintain data; Content of divided cells; Combine duplicate rows and sum / average … Prevent duplicate cells; Compare ranges …

Select Duplicate or Single Rows; Select blank rows (all cells are empty); Super Find and Fuzzy Find in many workbooks; Random Selection …
Exact copy Multiple cells without changing the formula reference; Create references to multiple sheets automatically; Insert bullets, Check boxes and more …
Favorite formulas and quickly inserted, Ranges, pictures and pictures; Encrypt cells with password Create a mailing list and send emails …
Excerpt from the text, Add text, Delete by position, Delete space; Create and print paging subtotals; Convert between cell content and comments …
Super filter (save and apply filter schemes to other sheets); Advanced classification by month / week / day, frequency and more; Special filter for bold, italic …
Combine workbooks and worksheets; Merge tables based on key columns; Split data into several sheets; Batch conversion xls, xlsx and PDF …
Dynamic table grouping by week number, day of the week and more … Show cells locked and unlocked by different colors; Highlight the cells that have formula / name …
kte tab 201905Read more … Download …
Office Tab: Bring The Interface With Tabs To Office, Make Your Work Easy
Enable editing and reading with tabs in Word, Excel, PowerPoint, Editor, Access, Visio and Project.
Open and create several documents in new tabs of the same window, instead of in new windows.
Increase your productivity by 50% and reduce hundreds of mouse clicks for you every day!

Kutools for Excel, with more than 120 practical Excel functions, improve your work efficiency and save work time.
Go to download
Free 60-day trial Buy
PayPal / MyCommerce
After free installation Kutools for Excel, do the following:

1. Select the range of cells you want to use and click Company> Import / Export> Export range to file. See screenshot:
doc cell to html table 10

2. In the Export Range to File dialog, verify simple HTML or complex HTML (all format) option as needed, and then specify a desired export destination. See screenshot:

Tips:

Simple HTML: The selected range is exported with grid lines, and the following options can be reserved in the exported file: background color, font name, font size, font color, italic bold, column width and horizontal alignment .

Complex HTML: All formats of the selected range will be kept in the final file.
doc cell to html table 11

3. Click Ok, and a dialog box appears to remind you to give a name to the exported file, by default it was named with the cell ranges, change it as you need.
doc cell to html table 12

4. Click Ok, and the range has been converted to the html table.
doc cell to html table 13

Click here to learn more about the Export Range to File utility.

Gallery of Convert Excel Spreadsheet To Html Table

( Click Image to Enlarge )

Other Collections of Convert Excel Spreadsheet To Html Table

Convert Xls To Html TableExport Html Table Data To Excel Using JqueryConvert Spreadsheet To Html TableExport Html Table Data To Excel Using JavascriptConvert Excel Spreadsheet To Html TableConvert Excel Spreadsheet To Html CalculatorConvert Excel Into HtmlExport Html Table Data To Excel Sheet Using JavascriptExport Html Table Data To Excel Using Jquery In IeConvert Excel To Html Table OnlineConverting Excel To Html TableConvert Excel To Html TableConvert Excel Into Html Table