Top 3 Ways to Convert Excel Sheet to HTML Table

I was recently working on a simple Excel sheet that I needed to insert as a table into a webpage. The first thought that crossed my mind was to manually write the HTML code for the data table on the page. While you can do this, it is quite tedious and time consuming. Why waste so much energy when you can achieve this in a minute or two? Let’s check 3 easy methods to convert Excel cells to HTML table format.

To view spreadsheet data in an HTML table, you can use the native feature in Excel to convert pages to web pages. If the generated code doesn’t look clean, you can try HTML editors online or use special online tools to convert Excel sheets to HTML.

Let’s get started with converting Excel sheets into HTML tables that you can add to websites.

1. Use the HTML Editor

The simplest method is to copy the cells from your Excel sheet and paste them into an HTML editor. This will automatically generate the required code for the HTML table. Here are the detailed steps:

Stage 1: Open your Excel sheet. Copy the cells containing your data. Use the Ctrl + C keyboard shortcut to copy cells.

step 2: Now open any HTML editor. You can also use online HTML editors. For now I can recommend https://html-online.com/editor/. Open it and paste the copied cells into the box on the left.

As soon as you paste it, the editor will generate your HTML code for the table. It will be a basic table. You can then format it according to your needs.

Fly: Learn how to convert text to a table in Microsoft Word.

2. Save as Web Page

Excel allows you to save your documents in different formats. One of them is an HTML web page. You can use this feature to convert an Excel sheet to an HTML document. However, this adds a lot of extra code that might be unnecessary if you’re trying to convert a simple table. If you are familiar with HTML coding, you can remove these extra lines.

Here are the steps to convert Excel to HTML using Save as web page:

Stage 1: Start the Excel sheet you want to convert.

Step 2: Click the File option at the top and select Save As. Select the folder where you want to save the generated HTML file.

Stage 3: The Save As dialog box will open. Click the Save as type drop-down box and select the Web page.

Step 4: If you have multiple worksheets, next to Save, select Entire Workbook. If it’s a simple table, choose Selection. Click Save

Step 5: Another popup window will open. Click Publish.

The file will be saved as an HTML page. Follow the instructions given below to view its code.

View HTML Code for a Web Page

Go to the folder where you saved the HTML file. Then double-click on the file to preview it in a browser.

To copy the HTML code, right-click the file and select Open with. Choose your HTML editor if it is installed on your computer or choose any regular text editor such as Notepad or its alternatives.

Here’s a snapshot of what the HTML code looks like using this method:

3. Use Online Tools to Convert Excel to HTML Table

Various online tools are available that allow you to convert your Excel documents to HTML. You need to add your Excel sheet and they will display the HTML code. There are two sites that I like. Let’s check the steps for both.

Method 1: Using Conversion Tools

Stage 1: Launch https://conversiontools.io/convert/excel-to-html in your browser.

Step 2: Navigate to the Excel document you want to convert using the Browse button. Alternatively, you can also drag and drop the file.

Stage 3: The Run Conversion button will be enabled. Click on it to start the conversion process.

Step 4: Click Download File to download it to your computer.

To view the HTML code of the downloaded file, follow the steps outlined above for the ‘View the code of a web page’ section. To reiterate, open the page in a regular text editor to view its code.

Method 2: Using Beautification Tools

This website generates cleaner code compared to the one above. With this you will get a basic table.

Here’s how to do it.

Stage 1: Open http://beautifytools.com/excel-to-html-converter.php in the browser.

Step 2: Click the Browse button. Select the file you want to convert.

The generated HTML code will be displayed in the box below. You can copy and paste or click the Download button to save it as a TXT file.

learn HTML

It’s pretty easy to automatically convert your pages into HTML tables. Some of the methods may add extra code that can be easily removed. If you’re new to HTML, check out W3Schools.com for tips on using HTML.

Next: Online HTML editors are a great alternative to apps. Learn the best and free online HTML editors from the next link.