Friday, November 11, 2011

How to embed a spreadsheet into a blog

A friend of mine is a translator (English, Russian, Tajik), and she keeps in a spreadsheet a record of some of the phrases and words she translates. I suggested that she make this available on line for other translators to refer to. We had no idea how to do this, so I looked up how to embed a spreadsheet into a blog (she has a blog). I found the following resource:

Which it tested. It works - see the embedded test spreadsheet below:

If you want to change the content of the spreadsheet, you can log into your account (free, see the link above) and make the change in your original spreadsheet. When you refresh the blogpost page, it updates the spreadsheet with the change.

The only think I have found, so far, that one needs to be mindful of is that if your text is longer than then size of the cell that you put it in, then you need to adjust the with of the column in your account accordingly, in order to show the entire content of the cell.

UPDATE: Suppose you want to use google docs instead of It is possible - check this out:

This actually looks MUCH better. The instructions that gave me a rough idea of how to do this are here:

But actually the directions don't match the menu options available in google docs - it must be outdated, I guess. For example, this link says to "click on Publish in the upper right corner to open the Publish sidebar on the right side..." etc.  Here are some updated instructions (as of 18 Nov 2011):

1. In google docs, open the spreadsheet that you want to embed in your blog.
2. Click "File" then select "Publish to the Web" to open the publishing menu.
3. Under the second heading, the one that says "Get a link to the published data," click on the box immediately below it (which by default is "Web Page"), and select "HTML to embed in a page."
4. There is a textbox at the bottom - in that text box is HTML code. Copy and paste this code into your blog (make sure you've set your blogger editor to "HTML" and NOT "Compose"). 

Anyone have any ideas on how to get the "Sheet 1" out of the spreadsheet name above? Or how to reduce the size of the box when there are lots of empty cells?

No comments: