This tutorial is about How to Convert MS Excel Sheet to HTML Table. Recently I updated this tutorial and will try my best so that you understand this guide. I hope you guys like this blog, How to Convert MS Excel Sheet to HTML Table. If your answer is yes then please do share with your friends after reading this.
Check How to Convert MS Excel Sheet to HTML Table
Assuming you have a cell range and you want to convert the cell range to html table as below screenshot shown, how can you quickly handle it? In this article, I present some tricks to help you mainly convert sheet or cell range to html table in Excel.
Convert cells to HTML table with Save As command
In Excel, you can use the Save As command to quickly convert a range of cells or the entire workbook to an html table.
- Select the cells you want to convert and click File> Save As> Browse to display the Save As window. See screenshot.
- In the Save As window, specify the folder in which to put the html table, type the filename you use, and then select Web Page from the Save as type drop-down list. Then you can choose to save the workbook or just the selection in the html table by checking the Entire workbook or Selection option.
- Click Save, a Publish as web page dialog box will pop up, and you can click Change to specify the title, if you want to automatically update and republish the html table every time, check Automatically republish every time it is saved this workbook, and if you want to automatically open this web page after saving, check Open published web page in browser.
Convert cells in an HTML table with formulas
- Enter these texts in a range of cells as shown below:
- Then go to the next cell, here is H1, and enter this formula = D1 & E1 & A1 & F1 & E1 & B1 & F1 & E1 & C1 & F1 & G1, hit Enter, and then drag the formula down to the cell you need.
- 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 value option in the context menu. See screenshot:
- Then you can copy the cell range to the html editor and enter table tbody and / tbody / table separately at the beginning and end of the string range. See screenshot:
Final remarks: How to Convert MS Excel Sheet to HTML Table
I hope you understand this article, How to Convert MS Excel Sheet to HTML Table. If your answer is no, you can ask anything via the contact forum section related to this article. And if your answer is yes, please share this article with your friends and family to give us your support.
