ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Technology»
  • Internet & the Web»
  • Blogs

How to Add a Spreadsheet or Table Into Blogger

Updated on April 5, 2018
Blond Logic profile image

Having met with business owners both locally and internationally, I bring fresh ideas to help you 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

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

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

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.

Comments

    0 of 8192 characters used
    Post Comment

    • Kristen Howe profile image

      Kristen Howe 3 years ago from Northeast Ohio

      Anytime Blond Logic.

    • Blond Logic profile image
      Author

      Mary Wickison 3 years ago from Brazil

      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 3 years 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
      Author

      Mary Wickison 3 years ago from Brazil

      Thank you and you are very welcome.

    • Venkatachari M profile image

      Venkatachari M 3 years 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.

    • theonlineventures profile image

      Jonathan Caquilgan 3 years ago from Philippines

      Another useful stuff! Thanks for sharing.

    • Blond Logic profile image
      Author

      Mary Wickison 3 years ago from Brazil

      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 profile image

      Venkatachari M 3 years 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
      Author

      Mary Wickison 3 years ago from Brazil

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

      Great to hear from you.

    • billybuc profile image

      Bill Holland 3 years 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. :)

    working

    This website uses cookies

    As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

    For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: "https://hubpages.com/privacy-policy#gdpr"

    Show Details
    Necessary
    HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
    LoginThis is necessary to sign in to the HubPages Service.
    Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
    AkismetThis is used to detect comment spam. (Privacy Policy)
    HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
    HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
    Amazon Web ServicesThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized. (Privacy Policy)
    CloudflareThis is used to quickly and efficiently deliver files such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
    Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
    Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
    PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
    Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
    Features
    Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
    Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
    Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
    Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
    VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
    MavenThis supports the Maven widget and search functionality. (Privacy Policy)
    Marketing
    Google AdSenseThis is an ad network. (Privacy Policy)
    Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
    Index ExchangeThis is an ad network. (Privacy Policy)
    SovrnThis is an ad network. (Privacy Policy)
    Facebook AdsThis is an ad network. (Privacy Policy)
    Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
    AppNexusThis is an ad network. (Privacy Policy)
    OpenxThis is an ad network. (Privacy Policy)
    Rubicon ProjectThis is an ad network. (Privacy Policy)
    TripleLiftThis is an ad network. (Privacy Policy)
    Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
    Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
    Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisements has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
    Statistics
    Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
    ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
    Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)