Skip to main content

Embedding a Spreadsheet into a Blog

Embedding a spreadsheet into a blog can be extremely useful. It's usefulness need not be confined to mathematicians and statisticians. Spreadsheets can be a great way to present information as it is concise and easy to read. In addition you don't need a massive amount of spreadsheet knowledge to build a simple one. Here is a simple spreadsheet about cats!




These are the steps for embedding a spreadsheet into a blog - note: Google improves things all the time so changes are possible but the basic process remains the same as described:
  1. Open a Google account if not done already. This can be done by invitation from a person with an account or from this page:
  2. https://www.google.com/accounts/NewAccount
  3. Create Google as home page when browsing the internet. This is not obligatory but sensible. The best home page is Google's iGoogle. This home page allows widgets to be placed on the page that do things like translations, conversions of weights, reception of feeds, time and calendar, weather etc.
  4. Top left of the screen on Google search home page is a menu, select "more" (second level menu drops down) and click on "documents". After you have been to Google docs for a while the Firefox browser (the best) will remember this and all you have to do is type "docs" in the URL box at the top of the page. Google Chrome, another browser, does this even better. (You can get into Google docs through your Google account as well).
  5. In Google Docs, using the far left menu select "New" and drop down to "Spreadsheet" and select.
  6. Create the spreadsheet. If this is the first time I would just play around and keep it simple. As my example shows even a two line spreadsheet can be useful, in part because you can incorporate a chart as well that is based on the spreadsheet to jazz up the presentation.
  7. You've got your spreadsheet. Go to the top right hand side of the page and select "Share" and click on the down pointer. A drop down menu comes up and select "Publish as web page". There are two buttons on the new page. Click on the top button that says, "Publish as a Web Page"
  8. When that is done Google creates a URL for that document (a website in effect). You are given the URL and options below. Click in the check box "Automatically republish when changes are made" (this is not necessary for this exercise but handy for the future).
  9. Below the check box Google asks, "What parts?" and below that it has selected "All sheets". This can left as it is. At the bottom of the window is a link to "More publishing options". Click on this link, which takes you to:
  10. A fresh pop up window on which the top line of options says, "File format" and to the right is a drop down menu, in which their is already one option selected, "HTML". Open up the drop down menu and select the second option down, "HTML to embed in a web page"
  11. Then click the button "Generate URL". The code to embed into the blog comes up.
  12. Copy the generated code.
  13. The code can be dropped into you blog post. You do this in "Edit Html" mode if you are using Google Blogger. Of course the code can be used in any website, blog or not.
  14. I center align the embedded spreadsheet by typing in, before the code for the spreadsheet, the tag <div align="center"> and after the code the tag, </div>
  15. That is it. I will leave it to you to play with creating a chart but start by selecting, "Insert" in the Google Spreadsheet and select "chart". It is pleasantly easy. Embedding a spreadsheet into a blog is also pretty easy as you can see.


From Embedding a Spreadsheet into a Blog to Home Page

Comments

neil said…
top tips cheers

Popular posts from this blog

Cat Ear Mites

Brown gunge. Yes, I know this is a ferret! It does show the build up of dark brown to black ear wax caused by the presence of the cat ear mites in the outer ear canal. This parasite is not restricted to the domestic cat, which makes this photo valid and a useful illustration (I was unable to find a suitable photo of a cat with the condition). Photo Stacy Lynn Baum under a creative commons license. Ear mites (minute crab like creatures) are one of the causes of inflammation of the outer ear canal (scientific term for this inflammation is Otitis externa ). The outer ear canal is the tube that runs from outside to the ear drum (the pathway for the reception of sound), which can be seen when looking at the ear. Otitis externa affects humans and often swimmers as it is called "swimmer's ear" in humans. This YouTube video show ear mites under a microscope. They are not actually in the ear in this video. There are many possible causes of Otitis externa in c

Feline Mange

I'll write about three types of feline mange (a) feline scabies or head mange (b) demodectic mange and (c) sarcoptic mange. The source material is from Cat Owner's Home Veterinary Handbook - the best on the market . Generalised feline mange? Puerto Rico - Photo by Gotham City Lost And Found Feline Scabies - head mange Head mange or feline scabies, is a fairly rare condition in cats, which is caused by the Notoedres mite (head mite) that only reproduces on cats. The female mites burrow a few millimeters (that is a lot) into the skin around the head, and neck to lay eggs, which hatch and lay their own eggs. Their presence and activities causes intense itching that in turn causes the cat to scratch. The scratching will obviously be noticed and it will cause the skin to become red, scratched and worse infected. Symptoms: hair loss and scabs, thick wrinkled skin and grey/yellow crusts form plus the symptoms of scratching. Feline mange (head mange) is contagious and tr

Cat Anatomy

Cat Anatomy - Photo by Curious Expeditions . The picture above was taken at Wax Anatomical Models at La Specola in Florence, Italy. The photograph is published under a creative commons license kindly granted by the photographer. I am sorry if it is a bit gruesome. It is pretty well all I could find as an illustration that was licensed for publication. Cat Anatomy is a very wide ranging subject. The anatomy of a cat is very similar to human anatomy. If you were writing a biology book for students of biology you would go through every part of the a cat's anatomy in some detail. It would be similar to writing a book about the human anatomy. It would be a thick book and pretty boring for your average internet surfer. So, how do you limit such a big subject and make this post meaningful? The answer I think lies in doing two things: Having a quick general look at cat anatomy - an overview and; Focusing on the areas of cat anatomy that are particular to the cat and of parti