Updated date:

How to Add a Spreadsheet or Table Into Blogger

I meet with business owners both locally and internationally and share what I learn to help readers generate more income.

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

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 this 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

spreadsheet-into-blogger

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

spreadsheet-into-blogger

Tableizer Rating

Using Tableizer

After much scouring on the internet for a solution I found a wonderful site which will convert your spreadsheet into a form that 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

HTML Code for Blogger Table

Below is an example of what you'll receive. If you've never worked with a code like this, don't worry. All you'll be doing is using a copy and paste function. The HTML code is what you'll put into your Blogger post. You will also be shown an example of what your table will look like.

Yours will not have the red arrows, these I've added to indicate the part you need to copy.

Tableizer Result

spreadsheet-into-blogger

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

spreadsheet-into-blogger

Select HTML

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


Correct Spreadsheet Placement in Blog

spreadsheet-into-blogger

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.

spreadsheet-into-blogger

Where do you write?

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. Or if you use Windows 10 click the start button and type in notepad. Open up Notepad, and paste your table there where 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

spreadsheet-into-blogger

Select your spreadsheet

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

Highlight the selected area and click copy.

spreadsheet-into-blogger

Insert into Notepad

Paste your spreadsheet into Notepad. Click Edit and Paste.

spreadsheet-into-blogger

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.

spreadsheet-into-blogger

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.

  • How to Create Pages on Google Blogger
    As a writer we may be blogging on different subjects. To make it easier for the viewers, arrange the content in a systematic and easily accessible format. Creating Pages on menu bar facilitates this.

This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.

© 2015 Mary Wickison

Comments

Rasith from Chennai on December 30, 2019:

Thanks for sharing.

Kristen Howe from Northeast Ohio on May 04, 2015:

Anytime Blond Logic.

Mary Wickison (author) from Brazil on May 04, 2015:

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 from Northeast Ohio on May 03, 2015:

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!

Mary Wickison (author) from Brazil on April 29, 2015:

Thank you and you are very welcome.

Venkatachari M from Hyderabad, India on April 29, 2015:

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.

Jonathan Caquilgan from Philippines on April 27, 2015:

Another useful stuff! Thanks for sharing.

Mary Wickison (author) from Brazil on April 27, 2015:

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.

Venkatachari M from Hyderabad, India on April 27, 2015:

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.

Mary Wickison (author) from Brazil on April 27, 2015:

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

Great to hear from you.

Bill Holland from Olympia, WA on April 27, 2015:

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