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
If you are blogging to have fun and keep a journal of daily activities, then carry on as you are. If, on the other hand you want to make money, and you haven't been able to do i, you're not alone. I was in the same boat until I bought this book.
My blogging was all over the place, and not targeted to making money. If I was a famous rock star, then sure, people would have read it. But since I couldn't carry a tune in a bucket, I had to give people what they wanted. It turned my blog into one that people began reading.
There is no magic formula, it takes work, but at least I'm on the right track now.
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
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
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.
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.
Yours will not have the red arrows, these I added merely to highlight the part you need to copy.
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
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?
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
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.
- 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