Header Ads

How to convert Excel Table to Simple Web Table?

How to convert Excel Table to Simple Web Table?

If you are interested to upload the excel table data to a webpage then this article will help you.

Let us understand why I am not going for traditional approach.
So say you have a table with result of an exam
Where you have 3 students and and their result of a subject need to be published.

so either you can create

<table border="1">
<tr> <td></td> <td></td> <td></td> </tr>
<tr> <td></td> <td></td> <td></td> </tr>
<tr> <td></td> <td></td> <td></td> </tr>
to insert data. or you can convert Excel file to HTML format and get the code. This code can be placed inside webpage.

Both the cases have some disadvantages--
1. You need to expert in HTML coding to understand the logic better.
2. Junk unnecessary code need to be uploaded in the second case
3. Debugging will be tough
4. May destroy your webpage structure.

So what can be a good solution to convert Excel data to simple web format??? I found out the solution today.. Lets check out how it works..

The solution is

There are few simple steps to convert Excel data to web table

1. Copy your excel data sheet

2. Paste  it to Tableizer



Change the style
  • Font size
  • Header color
  • Font

Click on tableize it.
or you can reset to start a new one

The output code--

Even you can see the webtable output:

The code will look like-----

<style type="text/css">
table.tableizer-table {
border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #ccc;
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;

<table class="tableizer-table">
<tr class="tableizer-firstrow"><th>Name</th><th>Roll Number</th><th>Status</th></tr>

The original output will be--

NameRoll NumberStatus

Hope this will help you to create excel data to simple webpage table.

Powered by Blogger.