Web Hosting

How To: Add Excel Files To Blogger

Web Hosting
Today, I’m going to show you how to add Excel files to blogger. There could be other ways to achieve the same results, however, I find this way more convenient for me. Thanks to Google Docs which makes it all possible.
Without further ado, let’s go through this simple tutorial.

I’ve created a table in Excel file, and named it ‘example’. Obviously, I cannot copy & paste it directly to ‘Compose’ session in blogger or the lines will go missing, leaving the data floating in mid air. So, here’s what I’ll do:

1. (In Microsoft Excel) File > Save As > Name the file (here I named it ‘example’).

excel file
2. Go to Google Docs. Log in with your Google username & password.

3. You will be directed to a page illustrated below. Click ‘Upload’ and ‘Browse’ to locate the ‘example’ file we created earlier.

Google doc
You can even rename the file before you ‘Upload File’.

upload excel file to Google doc 2

After loading, you’ll have a spreadsheet opened for you, showing the table you just uploaded from your computer. Almost like Microsoft Excel, isn’t it?

excel spreadsheet in Google Doc
4. Highlight your table (in this case, dragging B2:E7). At the right side of your page, click ‘Share’ and you’ll find a list of dropdown menu’s, choose ‘Publish as a web page’.


5. A pop up window appeared. In ‘What Parts?”, choose the Sheet where the table is at. Then, select ‘More Publishing Options’.

More Public option for sharing excel file
6. A list of dropdown choices:

- File format: HTML to embed in a webpage
- What sheets? : Sheet name where the table is at
- What cells? : According to the highlighted table, here is B2:E7.

Click ‘Generate URL’, you’ll get the HTML code. Copy & paste it to your ‘Edit Html’ in Edit Posts session (of blogger).

copy & paste code generated for excel file
7. So here is the table in your blog post after hitting ‘Publish’. There! Now your excel file is attached to your post!

add excel file to blogger

It is possible that the border lines shown are slightly different from what it is seen in Excel file, but it’s close enough. Perhaps some codes needed to be modified to suit your taste, but then it’s another story (tutorial).

It is possible to do the same with Word, Power Point, even PDF files, since Google Docs can support these file types. I haven’t tried it yet though, perhaps you could.

Hope you find this tutorial helpful. If you have better ways to add Excel files to blogger, by all means, do share with us.

Copyright © 2009 by Wong Ching Ya, All Rights Reserved, “How To: Add Excel Files To Blogger“.


Web Hosting
24 Comments

Add a Comment

Your email address will not be published. Required fields are marked *