How to Add a Spreadsheet or Table into Blogger

Adding a Table to a Blog

We all know the potential power of blogging. It seems like everyone and their grandmother now has a blog offering advice about everything from the latest technology to knitting techniques. There are people who are passionate about their blogs and have created some lavish and very detailed ones. Some people blog for fun about a favorite pastime or hobby and others blog specifically to make money.

Whichever category you fall into you may have tried to place a table or a spreadsheet into Blogger or other blogging site without much success. I would like to show you a quick and easy way to do this.

Although most blogging platforms offer a variety of layouts, and themes sometimes we need to stretch things a little more. All too often blogs can be boring if it is merely a long stream of writing. To keep it interesting for your reader consider adding photos, surveys, and tables.



Take your blog to the next level

How To Make Money Blogging: How I Replaced My Day Job With My Blog
How To Make Money Blogging: How I Replaced My Day Job With My Blog

A great little book full of ideas about blogging. Unlike some which make it all sound so easy and tell you that you'll make a great wad of cash, this book is realistic. It makes you realize that without a lot of work and attention, your blog will go nowhere.

Start your blog off on the right foot by using his ideas.

 

Open Your Spreadsheet

Begin by opening up your spreadsheet or table. I use Calc in Open Office but if you use Excel that is okay as well. Highlight the area of your spreadsheet you wish to copy to your blog.

If your spreadsheet is proving problematic with regards to formatting, scroll down the page for information about how to correct this before completing this step. Don't worry it is easier than you think and you don't need to know anything about HTML.


Highlight Your Spreadsheet

Copy Your Spreadsheet

The next step will be to copy your spreadsheet. If you try to put this straight into Blogger the example below will happen. As you can see, this is not acceptable. You could make it a bit more tidy but there is an easier way.

Incorrect table layout in Blogger

Tableizer Rating

5 stars for Tableizer

Using Tableizer

After much scouring on the internet for a solution I found a wonderful site which will convert your spreadsheet into a form which will allow you to easily put this into Blogger or I imagine Wordpress as well.

Go to the site Tableizer and in the light rectangular box paste your data from your spreadsheet. Then click Tableize It.

Tableizer

Tableizer
Tableizer | Source

HTML Code for Blogger Table

Below is what you will receive. The HTML code is what you need to put into your Blogger post. You will also be shown an example of what your table will look like.

Your example will not have the red arrows, these I added merely to highlight the part you will need to copy.

Tableizer Result

Sign in to Blogger

Begin by signing into Blogger and selecting the blog you wish to insert your table into. If this is a new post, click new post.

Paste HTML in Blogger

Select HTML

When pasting your HTML code, which you have copied from Tableizer, you need to click the HTML button. The default is Compose so be sure to click on HTML as seen in the screenshot above.


Correct spreadsheet placement in Blog

View in Blogger

Below is what your table will look like in your blog. Your colors might be different as you may have chosen a different Blogger theme than I have when you first began your blog.

This is a chart for my blog about tilapia farming.

Doesn't it look nice.

Where do you write?

Where do you write?

See results without voting

Easy Way to Correct an Error on a Spreadsheet

At the beginning of this post I mentioned an easy way to correct spreadsheets.

If you have an error in your table which you need to change, do this before inserting your spreadsheet data into Blogger or other post. Although this seems like it should be straightforward, I have found it isn't always. I had one column which kept reverting the numbers back to a date even though I changed them to a general number setting.

I also tried inserting another column and copied the data excluding the problem areas. This too didn't work. However, I did find a solution which I would like to share with you. Don't waste your time wondering why the problem occurred, save that for a time when you have nothing better to do . Now you need to complete that blog post of yours.

Simply copy your table including the error and paste it into Notepad. This could be a program which you haven't use in ages or possibly have never used. It can be found by clicking start, all programs, accessories and Notepad. Paste your table there and you can easily make the necessary changes.


Then carry on with the steps of going to Tableizer for converting your spreadsheet into a usable table format suitable for using in Blogger or other blog providers.

Problem with date in Spreadsheet

Select your spreadsheet

You will need to copy and paste your problematic spreadsheet into Notepad.

Highlight the selected area and click copy.

Insert into Notepad

Paste your spreadsheet into Notepad. Click Edit and Paste.

Making Changes in Notepad

In Notepad you can easily move and alter the data of your spreadsheet. Once you have done this copy and paste into Tableizer and complete by copying your HTML code into Blogger. As explained at the beginning of this post.

Creating a more engaging blog

There you have it, a quick and easy way to insert create a table in Blogger or other blog post. Tables and spreadsheets help organize data into a user friendly format that your reader will enjoy and understand.

Along with bullet points, photos and videos using tables in your blog keeps your visitor reading and creates a better opportunity for you to capitalize on their visit. This also keeps your bounce rate low.

More by this Author


10 comments

billybuc profile image

billybuc 19 months ago from Olympia, WA

Nice tutorial my friend. I don't have blogger but if I did, I would be infinitely wiser at this moment. :)


Blond Logic profile image

Blond Logic 19 months ago from Brazil Author

Oh thanks for that. I know you are a busy man with all your projects on the go.

Great to hear from you.


Venkatachari M profile image

Venkatachari M 19 months ago from Hyderabad, India

Very useful information. I also face much problem in creating tables on blogger. Now, I can use this information and improve my blogs. Thanks for sharing it.

I know how to create categories or pages and shared that information in one of my hubs.

Your tutorial for tables is great. Voted up, useful and interesting.


Blond Logic profile image

Blond Logic 19 months ago from Brazil Author

Hello Venkatachari,

I am pleased to know it helped you. Thank you for the votes. I'll check out your hub about Blogger. Perhaps we can link the two together.


theonlineventures profile image

theonlineventures 19 months ago from Philippines

Another useful stuff! Thanks for sharing.


Venkatachari M profile image

Venkatachari M 19 months ago from Hyderabad, India

Mary, I have added back a link to your hub on my hub "How to create pages on Blogger". And thanks for linking my hub.


Blond Logic profile image

Blond Logic 19 months ago from Brazil Author

Thank you and you are very welcome.


Kristen Howe profile image

Kristen Howe 19 months ago from Northeast Ohio

Great job with this hub. I do use blogger for my book review blog and Open Office for my spreadsheet for my hub stats. This is handy. Voted up for useful!


Blond Logic profile image

Blond Logic 19 months ago from Brazil Author

Hi Kristen,

I'm pleased you found it useful. I think it is important to keep things interesting for the reader and tables along with videos, photos and interactive questions are all great ways to do this.

Thanks for your visit and vote.


Kristen Howe profile image

Kristen Howe 19 months ago from Northeast Ohio

Anytime Blond Logic.

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.


    Click to Rate This Article
    working