About the Tableizer
Selecting cells in Excel, Numbers or Google Sheets and copying puts tab separated text on the clipboard. That is all this tool needs. Paste it in and you get a complete table plus a small stylesheet, so what lands in your page or your email is readable immediately instead of being an unstyled grid you then have to fight with.
Three presets cover the usual needs. Bordered draws a one pixel rule around every cell with a grey header strip, the look most people picture when they think of a data table. Striped uses a coloured header bar and alternating row tints, which helps when a table runs past twenty rows. Minimal drops the vertical rules entirely and keeps a single line under the header, closer to how tables are set in print. Choosing No CSS gives the bare markup with the class names still attached, ready for your own rules.
Numbers are handled without being told. Each column is inspected, and if every value below the header parses as a number, with thousands separators, a percentage sign or a short currency code allowed, that column is right aligned so the decimal points line up. A column mixing text and numbers is left alone. Empty cells are filled with a non breaking space so browsers still draw their borders, an optional caption becomes a real <caption> element for accessibility, and the class names are prefixed so the CSS cannot collide with the rest of your page. When you want plain semantic markup with no styling at all, Table to HTML is the simpler tool.
How to use
- Select the cells in your spreadsheet and copy them, then paste into the left pane.
- Pick a Style preset, or choose No CSS to use your own stylesheet.
- Add a Caption if the table needs a title that screen readers will announce.
- Press Copy and paste the markup, style block included, into your page.
Common questions
- Do I need to save the spreadsheet first?
- No. Copying a selection is enough, because the clipboard already holds the cells as tab separated text.
- Why is a column right aligned that I wanted left?
- Every value in it looked numeric. Untick the alignment option, or add a non numeric character to one cell if only that column should differ.
- Can I keep the CSS in a separate file?
- Yes. Choose No CSS for the markup alone and write rules against tableizer-table and tableizer-firstrow in your own stylesheet.
- Does formatting from the spreadsheet come across?
- No. The clipboard text carries values only, so bold cells, fills and number formats are lost and the preset styling replaces them.