Step 1: Go to Tableizer: http://tableizer.journalistopia.com/
Step 2: Paste your data from Excel into Tableizer and hit “Tableize it!”
Step 3: Go to your post and in the “Source code” editor in Movable Type (the button that looks like <>), paste the output into your post and add a title.
Dos and Don’ts
Do: PREVIEW PREVIEW PREVIEW. Always.
Do: Add a title. Here’s how:
- As soon as the table is in your post, open the blog tool’s HTML editor.
- In the row immediately after the
<table>
tag, add this:
<caption>ENTER YOUR TITLE HERE</caption>
Do: Clean up your copy before pasting from Excel
- AP Style: Still applies. Charts are more readable when text reads like news stories.
- Words: Convert all-caps to plain English, manually or with Excel’s PROPER function.
- Numbers:Use Excel’s Format/Cells menu to make numbers look clean.
- Use the comma feature
- Use 0 decimal places if possible, 1 at most
- Money should appear as $
- Percent should show as %
Don’t: Go wild with fonts and colors
- Helvetica looks plenty good
- Black is a nice header option
Don’t: Pack in too many columns. Use 3 or 4 max; fewer will look better.
Pro tip
Wrap story body around table… Add the following red lines to the Tableizer code:
table.tableizer-table {
border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
float: right;
margin: 0 0 15px 15 px;
}