3 Best Ways to Convert Excel Sheet to HTML Table
I recently worked on a simple Excel sheet that I had to add in the form of a table on a web page. The first thought that came to my mind was to manually write the HTML code for the data table in the sheet. Although you can do it, it’s quite tedious and time consuming. Why waste so much energy when you can get there in a minute or two? Let’s see 3 simple methods to convert Excel cells to HTML table format.
To display data from a spreadsheet in an HTML table, you can use native Excel functionality to convert sheets to web pages. If the generated code doesn’t look clean, you can try online HTML editors or use dedicated online tools to convert Excel sheets to HTML.
Let’s start by converting Excel sheets to HTML tables that you can add to websites.
1. Use the HTML editor
The easiest method is to copy the cells from your Excel sheet and paste them into an HTML editor. This will automatically generate the code required for the HTML table. Here are the steps in detail:
Step 1: Open your Excel sheet. Copy the cells containing your data. Use the keyboard shortcut Ctrl + C to copy the cells.
2nd step: Now open any HTML editor. You can also use online HTML editors. I can recommend https://html-online.com/editor/ for now. Open it and paste the copied cells into the box on the left side.
Immediately when you paste it, the editor will generate your HTML code for the table. It will be a basic table. You can format it later according to your needs.
Point: Learn how to convert text to a table in Microsoft Word.
3. Use online tools to convert Excel to HTML table
There are various online tools that allow you to convert your Excel documents to HTML format. You need to add your Excel sheet, and they will display the HTML code. There are two websites that I like. Let’s check out the steps for both.
Method 1: Using the conversion tools
Step 1: Launch https://conversiontools.io/convert/excel-to-html on your browser.
2nd step: Using the Browse button, navigate to the Excel document you want to convert. You can also drag and drop the file as well.
Step 3: The Execute conversion button is activated. Click on it to start the conversion process.
Step 4: Click Download File to download it to your computer.
To display the HTML code of the downloaded file, follow the steps mentioned above for the “Displaying the code of a web page” section. To reiterate, open the page in a normal text editor to view its code.
Method 2: Using the Beautify Tools
This website generates a cleaner code than the one above. You will get a basic table with this one.
Here’s how.
Step 1: Open the page http://beautifytools.com/excel-to-html-converter.php in the browser.
2nd step: Click the Browse button. Select the file you want to convert.
The generated HTML code will be displayed in the box below. You can either copy and paste it, or click the Download button to save it as a TXT file.
Learn HTML
It is quite easy to automatically convert your sheets to HTML tables. Some methods may add additional code which can be removed easily. If you’re new to HTML, check out W3Schools.com for tips on using HTML.
Then:
Online HTML editors are a great alternative to applications. Discover the best free online HTML editors from the following link.
Last updated on June 15, 2020
The above article may contain affiliate links that help support Guiding Tech. However, this does not affect our editorial integrity. The content remains impartial and authentic.