Tableizer – Excel and Google Sheets to HTML Table

How to use the Tableizer: Excel to HTML Table

Select the cells in Excel, Google Sheets or LibreOffice Calc, copy them and paste into the input editor.

Pick a Styling (Striped rows, Bordered or No CSS), a Header colour, a Font family and a Font size (px) between 8 and 32.

Keep First row is header ticked if the first copied row holds column names.

Click Tableize!, check the Preview tab, then copy the HTML and paste it into your page, post or email template.

Tableizer: paste spreadsheet cells, get a styled HTML table

Tableizer is for the moment when a figure already lives in a spreadsheet and needs to appear on a web page. You copy a range of cells, paste it here, and receive a small <style> block plus a table that looks tidy without any other CSS. It is meant for blog posts, newsletters, intranet pages and CMS articles where you cannot, or do not want to, touch the site stylesheet.

Example

Copying three columns from a sales sheet gives tab-separated text:

Region	Q1	Growth
North	12,400	6.0%
South	9,870	4.8%

With the default settings, Tableize! returns:

<style>
table { border-collapse: collapse; font-family: Arial, Helvetica, sans-serif; font-size: 14px; }
th, td { border: 1px solid #d0d7de; padding: 6px 12px; text-align: left; }
thead th { background: #1f6feb; color: #ffffff; }
tbody tr:nth-child(even) td { background: #f6f8fa; }
tbody tr:hover td { background: #eef4ff; }
</style>
<table>
  <thead>
    <tr>
      <th>Region</th>
      <th>Q1</th>
      <th>Growth</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>North</td>
      <td>12,400</td>
      <td>6.0%</td>
    </tr>
    <tr>
      <td>South</td>
      <td>9,870</td>
      <td>4.8%</td>
    </tr>
  </tbody>
</table>

The thousands separators and the 6.0% survive untouched. Tableizer never reinterprets numbers, which matters for financial figures, product codes with leading zeros and anything already formatted the way you want readers to see it.

Styling options

Styling – Striped rows (default) shades every second row, Bordered keeps the grid lines without stripes, and No CSS returns only the table markup.
Header colour – the background of the header row; header text is white, so choose a reasonably dark colour. Use a hex code such as #1f6feb or #b91c1c. Other formats, like colour names, are replaced by a default blue.
Font family – any CSS font stack, for example Georgia, serif or system-ui, sans-serif. Characters that could break out of the CSS rule are removed.
Font size (px) – from 8 to 32; values outside that range are clamped.
First row is header – untick it if you copied data rows only; the table then has no header section.

The Preview tab updates as you change these, so you can try a few colours before copying.

Pasting tips

Copy at least two columns. The tab between cells is how Tableizer recognizes spreadsheet data. A single column has no tabs, is read as CSV, and a value such as 12,400 would be split at the comma.
Cells with line breaks are copied by spreadsheets inside quotes. They are kept as one cell.
Formulas are not copied, only their displayed results, which is usually what you want on a page.
Merged cells and colours from the sheet are not carried over; the clipboard text holds only values.
You can also paste CSV, a Markdown table or a JSON array. Tableizer detects the format, although it is designed around spreadsheet pastes.

Why not paste straight into the editor?

Many rich-text editors accept a table pasted from a spreadsheet, but the result often carries fixed column widths, inline fonts and colours from the sheet, and it can look different on every page. Going through Tableizer gives you short, predictable markup with one consistent style that you control from the options above, and it is easy to regenerate when the numbers change next month.

Using the output in email and CMS pages

In a CMS, paste the whole output, style block included, into an HTML or code block. In an email builder, check how the message renders before sending: email clients differ widely in CSS support, and some ignore <style> blocks, in which case the table still shows its data but without colours. Also note that the rules target all table, th and td elements, so on a page with other tables they will be styled too.

Related tools

If you need a CSS class on the table for your site's stylesheet, use Table to HTML. For a whole .xlsx workbook rather than a copied range, Excel to HTML reads the file directly, and Markdown table generator makes the same paste work in README files.

Privacy

Pasted cells stay in your browser while the table is generated. Nothing is sent to our server unless you load a URL or save a share link.

Frequently asked questions

How do I copy a table from Excel into Tableizer?

Select the range, press Ctrl+C (Cmd+C on a Mac) and paste into the input editor. Excel puts tab-separated text on the clipboard, which Tableizer reads directly.

Does Tableizer work with Google Sheets?

Yes. Copying from Google Sheets or LibreOffice Calc also produces tab-separated text, so the result is the same as with Excel.

Why are my numbers shown exactly as in the sheet?

Tableizer deliberately keeps the text of every cell, including thousands separators, currency symbols, percentages and leading zeros. It does not convert values to numbers.

Can I keep the colours and fonts from my spreadsheet?

No. The clipboard text contains only cell values, not formatting. Use the Styling, Header colour, Font family and Font size options to style the table instead.

Will the table look the same in my email?

It depends on the email client. Some clients ignore style blocks, so the table may appear unstyled. Send yourself a test message before mailing a list.