Bluehost

How to Insert a Table Into a WordPress Blog Post

March 19, 2008 Posted under: Make Money Blogging by Caroline Middlebrook

The default WordPress editor does not allow much HTML and it does not allow tables to be inserted. In this post I’ll show you a neat plugin that allows you to insert tables into your WordPress posts and exactly how to use it.

Update: Newer versions of WordPress now support tables properly

tables in wordpress blog posts

I was actually first asked about this a little while ago by Trevor Mulligan. At the time I had not needed to insert a table into any of my blog posts so I was unable to help him. A few days ago I published a list of over 100 CSS Galleries which are great for getting backlinks and traffic and I wanted to format the information in a table so I needed to figure out how to do it.

The wp-table Plugin

One of the reasons I love WordPress so much is that its functionality is infinitely expanded by the wide range of plugins available for it. One such plugin is wp-table by Alex Rabe. The instructions on that page work but I found it somewhat non-intuitive to use so I thought I’d do my own little write-up.

Setting up the Tables

Now here’s the weird thing – the plugin provides a table editor but that editor is separate from your blog posts. You create tables for your blog as a whole, each table gets its own ID and then to put a table into a blog post you insert a special tag. I would have expected the table editor to be built into the post editor but it isn’t which is why it’s a little confusing.

Once you’ve uploaded and activated the plugin you get a new option under the manage tab. You can see it below:

wordpress tables manager

That screenshot also shows the one and only table I have at the moment which is the CSS Galleries one. There are two ways to create a table. You can manually add one by specifying the name and the number of rows and columns but that is restrictive as the drop-down only allows 20 rows.

Thankfully there is a second option to import a table from a file. You simply browse from a file on your computer and select a delimiter character to use. Here is a picture of that in action:

import wordpress table data

What I did for my post was to write the information out in Microsoft Excel (Open Office has the same functionality) and then export that as a CSV file. CSV is a Comma Separated file which means that each row in the spreadsheet is exported as one line of text with a comma character separating each column.

Inserting a Table Into a Post

Now once you’ve setup your table, inserting into a blog post (or page) is very simple. Make a note of the ID of the table which is 5 in the example above and then you use the following bracket notation to insert it:

wordpress table bracket notation

Simple really.

Embedding Links in the Text

I hit a snag right away – a CSV file is plain text and I wanted to link to each one of the directories or the post wouldn’t have been nearly as useful. In Excel I was able to automatically turn the url’s into links but as soon as I exported them as a CSV they got stripped back to plain text.

However, the plain text can contain HTML so I changed the text of the link to the HTML required to display as a link using the HREF tag. I knocked up a quick program to do this for me so I didn’t have to do it manually for 100 lines of text!

Basically, if you want links in your table you have to ensure that the source text contains the full HTML to use.


Want to Make Money Blogging? My free course, The Bloggers Bible contains everything you need to know about building a highly popular and profitable blog from scratch!

Just fill in your email below to get your first lesson immediately:


Post to Twitter Tweet This Post Post to StumbleUpon Stumble This Post


You might also like these similar posts:

101 Ideas for “How To” Internet Marketing Blog Posts
AdSense Units Added to This Blog
Email Course Update – Content Development Underway, Website Coming Soon
AdSense Stats for October 2008
Articles

42 Comments:

DeFries
March 19, 2008

This is a neat way of doing it, but my personal favorite is to use Windows Live Writer with which you can add tables like you would in Excel. Real Easy….

DeFries’s last blog post..Premium Themes kick-off met Mimbo Magazine

Andrea_R
March 19, 2008

There’s other ways too, like usign the Code tab in the Wirte window instead of the visual editor.
Or adding more buttons to the visual editor (or RTE) with plugins. (I know they’re out there.)
That way you don’t even leave the write window.

Andrea_R’s last blog post..It’s coming…

Hi Caroline,

Great tip.

Tables are a great way to increase readability and draw attention. Once more I pat myself on the back for choosing WordPress, as it has as many plugins as there are ideas in peoples’ minds.

Cheers,
Alex

Tom Beaton
March 19, 2008

Now that does look very useful. Wordpress constantly surprises me. It is pretty much impossible to keep on top of all the features available to wordpress.

Tom Beaton’s last blog post..Apologies and Contingency planning

Eklavya
March 20, 2008

Thanks for this great post Caroline. I could not full understand how did you embed links in the tables using a quick program. Can you elaborate a bit on that? It will be a great help.

Eklavya’s last blog post..An update on full RSS feed and a video tutorial

Charlie
March 20, 2008

Cool tip Caroline, I’m getting a little crazy adding widgets here and there but there are so many that are useful.

Homebizseo.com
March 20, 2008

Very infomative use of wrdpress plugins.

Massimo
March 20, 2008

Great technical hint here Caroline. Out of the millions of plugins out there it’s great finding somebody that pulls out and spends time explaining the good and useful ones.

Caroline Middlebrook
March 20, 2008

@DeFries, I’ve heard of Windows Live Writer, I might have to check that out!

@Eklavya, I am a programmer and I wrote some software to do some text manipulation for me. Thats about as far as I want to elaborate as it would be totally off-topic for this blog.

Bob Younce
March 20, 2008

Cool tool, Caroline. Thankya!

I know just enough html to be dangerous, so this is a good thing for me. Seriously, any time I’ve needed a table I wind up having to cut and paste from a wysiwyg into the code tab in Wordpress. This is very cool.

Bob Younce’s last blog post..Banging My Gong – The Voice

Scott
March 20, 2008

It has been a while since I have read a post that gave some good practical tips, thanks. Scott

DeFries
March 20, 2008

@ Caroline: Yeah, you should check it out. I have been using it now for almost a year and it is the perfect tool to maintain a lot of blogs for one, but it’s so much easier to just add content with WLW.

Cheers!

DeFries’s last blog post..Premium Theme: Structure van Justin Tadlock

Caroline one of my readers just asked me about this plug in and I played with it a bit, Ill send him your way, I hit the same snag with Excel and gave up, lol Plug ins dont like me

Making Sales Making Money’s last blog post..Monika Mundell Joins the Team and More

Caroline, first let me say I am a huge fan and appreciate all you do and secondly you are one of my online heroes, watching what you have been able to do in the short time you have been blogging… I’m jealous but happy for you.

Finally, about the post. Thanks for the info about the plugin I will install it right away but unfortunately I needed it a couple of days ago when I posted to my blog and needed a table. In my case, necessity was the mother of invention. I couldn’t figure out how to get it in there and look right so I ended up taking a screenshot of my table that I had created in Word and inserted it as a picture.

Maybe a good tip for someone that might have trouble with the plugin or hardly ever need one. Thanks again. Kirk

Kirk “Bassett Hound” Hanna’s last blog post..Bassett Hounds For Sale: How Much is Red Ribbon?

Mademind
March 24, 2008

Thx, that is great plugin and works fine.

Mademind’s last blog post..Top 30 Young Bloggers Under 21

Allen
April 1, 2008

I just went to download this plugin and saw that it’s not supported on WordPress 2.5 and a newer version isn’t planned. That’s a shame as it looked like a useful plugin.

Allen’s last blog post..Four worm experiment

matt
April 14, 2008

this plugin is not work with wordpress 2.5,

Caroline Middlebrook
April 14, 2008

@Matt, yes that’s right. In Wp 2.5, this post is obsolete as you can now insert tables into the code and it wont mess it up for you.

Andrew
June 2, 2008

Can you elaborate on how to do tables in WP2.5.1 as easily as this plug-in let me do it before I upgraded?

~Andrew~

Andrews last blog post..Power Picnic on the Millennium Meadow

@Andrew, I’ve not tried it in the latest version and I don’t think this plugin is needed anymore as I believe table support is now built in.

Vladimir
June 8, 2008

Thanks Caroline, I am glad that you share your knowledge with others. I didn’t know how to insert table to wp-post or page so I device some shortcut – google docs/table/insert table Write or insert what you want to create. Go to edit/html/copy then go to wp/write post/HTML/paste. I know that my process was slow compare to yours now. Anyway. Thanks. Vladimir

zam
July 1, 2008

I’m looking for this topic for the whole day. I found same source that probably not compatible with wordpress 2.5. Hope you can give another source that compatible with wp 2.5

Rajesh
July 13, 2008

Hi Caroline,
It was a nice post. I use blogger. Do you have any idea on how to embed a table in blogpost using blogger.com ?

Rajeshs last blog post..IPO’s make a dent in Investor’s Coffers

@Rajeh, no idea, I don’t even know if it is possible but I don’t use blogger so I am not the person to ask.

redsaid
September 28, 2008

found the fix for fatal error in wp 2.5+
http://www.wpsnippets.com/2008/06/wp-table-plugin-fatal-error-fix/

now it works perfectly in wp 2.6

Tandarts
November 8, 2008

Looks great but euh.. it seems that you can only use text but no images for the table..
useless for me

David Newman
January 31, 2009

Regarding HTML in the source, how to add a background color to a “cell” in the table? I know how to do this in HTML tables (, but not in a CSV table.

Many thanks!

tedi ruswandi
February 2, 2009

thanks for the information, it works..

CoLiq
February 20, 2009

Maybe projectmanager is the solution.

Pradeesh
March 4, 2009

Good tutorial , but I do hope you’ll update it for Wordpress 2.7 as well. anyway , it did help me a lot !

Thanks

Pradeeshs last blog post..My Thoughts on DiGi 3G Internet

Tracy
April 12, 2009

Thank you for this! I installed the plugin and created my tables. I’m not getting the insert into post part. When I type [TABLE=6] I don’t get my table. I get [TABLE=6]. I am totally new so I apologize for a dumb question. Every post I’ve seen on this plugin says to insert into the post, simply type [TABLE=6]

Tracy

Jude
April 22, 2009

Thanks for the write up. I remember trying to use this a while back but as you said, not intuitive. The CSV import is a godsend.

Judes last blog post..Sautéed Morel Mushrooms and Fava Beans

Tobias
May 7, 2009

Hallo,

wp-Table development is continued as WP-Table Reloaded:

http://tobias.baethge.com/wordpress-plugins/wp-table-reloaded-english/

Tobias

ningbo weather
May 20, 2009

Thank you Caroline for your useful tips !
And good news to see that Tobias is now continuing the development of WP-Table as WP-Table Reloaded.
More here :

Melman
July 22, 2009

Great job! I wonder if it is possible to insert link for one cell…
Bests!

Fenton
July 23, 2009

Thanks for this, I was searching a way to draw a table and your results came the second in google.
Fenton´s last blog ..Hello world! My ComLuv Profile

Kompressionsstrümpfe
August 3, 2009

Hey, try the build-in table-tools from the TinyMCE.
The easiest way to activate is:

http://wordpress.org/extend/plugins/tinymce-advanced/
Kompressionsstrümpfe´s last undefined ..If you register your site for free at My ComLuv Profile

carol
August 16, 2009

I needed to get a table in my blog a few weeks ago. Need it in a hurry. I was forced to create it in Excel and make it to a jpeg. Then inserted it as an image in WP. What ended up working great with this technique is that I used SnagIt to really customize the file with some of the tools in the program. Worked well and fast.

Paul Schlegel
September 9, 2009

I’ve been experimenting with WP-Tables reloaded and have found that for some reason Google doesn’t always pick up the table entries.

So if you have keywords in your tables that you want Google to pick up you might want to doublecheck that they’re getting picked up after you post.

Casey
October 1, 2009

I can’t see the images. Can someone please tell me what the brackets used are, to insert the table into the post?

Thanks!

Tania
November 22, 2009

Has anyone figured out how to show the table “lines’ using tinymce?
I’ve tried it and it does the table spacing, but no formatting to make a larger table easier to read.

kenwooi
December 2, 2009

newer versions of wordpress now supports table?
how come I don’t see the function on the “write post” page?
kenwooi´s last blog ..Banana People! My ComLuv Profile


7 Trackbacks:

This Weeks Great Reads | Bare Fly.com

[...] How to Insert a Table Into a WordPress Blog Post [...]

Are Desktop Blogging Clients Worthwhile? | Richard Farrar's Blog

[...] a bit of a mission in WordPress without having to resort to hacking in HTML or installing a custom plugin for tables. I’ve always found this to be a serious omission with the WordPress [...]

Metal Shaper Man’s Blog

[...] 3 spaces Result: Failure…. Need to do some research here: I found this very interesting sight here: Oh boy….. Do I have a long way to go.. Alrighty I followed this link to the guy who wrote a [...]

The metal shaper man’s blog » Experiments with tables in 1&1 wordpress blog

[...] 3 spaces Result: Failure…. Need to do some research here: I found this very interesting sight here: Oh boy….. Do I have a long way to go.. Alrighty I followed this link to the guy who wrote a [...]

The Easiest way to Insert Tables into a Wordpress blog post | techtangerine

[...] alternative is to use a Wordpress plugin that can import tables created in Microsoft [...]

How to Insert a Table Into a WordPress Blog Post Caroline | debt solutions

[...] How to Insert a Table Into a WordPress Blog Post Caroline Posted by root 44 minutes ago (http://www.caroline-middlebrook.com) My aim is to learn how to make money online and transfer that knowledge to others import wordpress table data what i did for my post was to write the plugin that can import tables created in microsoft leave a comment tweet this post links powered by tweet Discuss  |  Bury |  News | How to Insert a Table Into a WordPress Blog Post Caroline [...]

Leave a comment

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

CommentLuv Enabled


Recommended Services
MyBlogLog Community
Top Commentators
Copyright © Caroline MiddlebrookTheme designed by Design Farmer

Twitter links powered by Tweet This v1.6.1, a WordPress plugin for Twitter.