Search This Blog

Tuesday, March 21, 2006

Another quick way to do a table

It is difficult to do tables with Blogger as browsers count more than 1 space as a single space, as mentioned in my previous post "how to do a quick and dirty table". If you don't want to use the <table> tag, and you don't want to use the "how to do a quick and dirty table" tip, you may want to use Excel to do your table if you have it. Enter the data into the Excel spreadsheet. Format it the way you want your table to appear. Highlight the data of the table and copy into clipboard, log into Dashboard, select the relevant blog, create a post, put the cursor where you want the table to be, right-click, paste. Viola, your table will be inserted and formatted the way you want it to be. Below is a table done using this method:

Item code Price
Apple 123 1.25
Orange 242 1.45
Pear 254 1.36

Syndicating Web Sites with RSS Feeds For Dummies

Blogging: Genius Stragies for Instant Web Content by Biz Stone, former Senior Specialist on the Google Blogger team


  1. I just tried this several times both in compose mode and html mode and it doesn't work. my table loses all formatting, the columns are net evenly spaced -- please help.

  2. I have tried it and it works. Don't know why it didn't for you. Perhaps some setting in Excel.

  3. Peter,
    These are the exact steps I take:

    1. enter small table in excel 2003
    2. highlight table
    3. open browser
    4. login to blogger
    5. create new post
    6. click html tag
    7. go back to excel table
    8. copy selected cells to clipboard
    9. paste into blog entry form
    10. click html preview

    What I get is are several rows of information with the text jumbled together. I'm fairly confident that no excel formatting is being carried over to the html.

    I've also tried this by pasting into the WYSIWYG tab for blog entry too.

    Any advice greatfully appreciated.

    Making Our Way

  4. I just tried it again, first in the COMPOSE mode, then in the EDIT HTML mode. It worked in the COMPOSE mode. See Test Blog No 4

  5. This was the post generated by that method:

    <table str="" style="border-collapse: collapse; width: 96pt;" border="0" cellpadding="0" cellspacing="0" width="128"><col style="width: 48pt;" width="64"> <col style="width: 48pt;" width="64"> <tbody><tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt; width: 48pt;" str="Item " height="17" width="64">Item<span style=""> </span></td> <td class="xl22" style="width: 48pt;" width="64">Code</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">apple</td> <td class="xl22" num="">123</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">orange</td> <td class="xl22" num="">245</td> </tr> </tbody></table>

  6. tried using the excel method but it didn't seem to work for me at wouldn't take the formating but thanks for the html code...I'll just tweak it to meet my needs


Related Posts Plugin for WordPress, Blogger...

Find topics by using the Google custom search box above which can search multiple blogs, or the SEARCH BLOG in the left corner of navbar. You can also find topics in the Label List and Categrories in the right sidebar.

For more information and special deals related to any of the issues on this page, place your cursor over the double-underlined links. All information supplied by

Disclaimer: This blog has no relation with Wiley Publications