Wednesday, January 17, 2007

Testing embeding Google Spreadsheet into the New Blogger blog

I have prreviously written 2 posts on including spreadsheets with blogs at How to add PDF files, spreadsheet, etc. into your blog (close new window/tab to get back to this page) and Testing embeding Zoho spreadsheet into a New Blogger (formerly beta) blog (click "BACK" button to get back to this page).

I have discovered that in Google Spreadsheet, there is also an option to embed a spreadsheet into your website. I am testing it now:

Well, it worked. The way to do this is to go to Welcome to Google Docs & Spreadsheets!, start a Google account if you don't have one already, then make your spreadsheet. When your spreadsheet is ready, the "PUBLISH" tab at the top right-hand corner of the page, select which part of the spreadsheet you want published (in my case, it was sheet 1 only). You can even choose whether you want the spreadsheet to be updated automatically (every 5 minutes) or updated manually.

Then click on "MORE PUBLISHING OPTIONS" at the bottom of the pop-up.
Google Spreadsheet Publishing Options
Then under drop-down menu "FILE FORMAT", click the down arrow and select "HTML TO EMBED IN A WEBPAGE". Put in the range of the cells you want to include in the spreadsheet (in my case, it was A1:C4), click "GENERATE URL" and the script to paste into your post editor window will be generated.
Google Spreadsheet Publish Format


Rex said...

Hi, how did you remove the published via Google Docs & Spreadsheets - updated automatically every 5 minutes
title. Can't seem to fgure that out.

Peter Chen said...

Hi Rex,

To tell you the truth, I hardly do tables, and I was just doing it for the test, and I can't remember all that I did. Whatever I did had been described in the post. Maybe something changed between the time I did the test and now. Maybe Google decided to add that "Published via ..." thing in recently. I don't know.

Peter Chen said...

Maybe I will test again and see what happen

Peter a.k.a. Enviroman
Enviroman Says

Peter Chen said...

Hi Rex,

Tested embedding Google spreadsheet again according to what had been described in this post. See post Testing embedding Google spreadsheet in New Blogger (formerly beta) again.

Mayotruck said...

This spreadsheet is currently not working.

The Stock Speculator said...

Hey, thanks for posting this - I have been struggling with how to make this work for 2 days now.

BWise said...

Top advice I did this and it looks great. here it is.

thanks a lot