This blog is for volunteers, webmasters and administrators of associations, clubs, charities, communities and other groups. We discuss issues and trends in modern web technologies that help your organization achieve more with less.

This blog is sponsored by Wild Apricot membership software: a set of tools for membership administration, event registration, website management, online fundraising - with friendly and knowledgeable tech support.

See for yourself how affordable and easy it is to use: - Take a tour!

Easy Embedded Tables for Your Website or Blog: Part One

Some kinds of information are best presented in table form: school alumni lists, genealogy data, annotated lists of resources, survey results and statistical data, and so on. When you have several data fields for each item, a simple list won't cut it. Here are 5 methods you might choose to show a table on your web page.

1. Screenshot Image

Yes, you could grab a screenshot of your spreadsheet and post it as a image, of course, but then the information in the table cannot be searched the way plain text can. This is an annoyance to readers who'd like to use their browser's search function to find one item in a long table, or to save the data for their own use; and it means, too, that the contents of your table cannot be read and indexed by search engines. Collaboration is not an option, and to update a table that's an image you will have to replace it with a new one.

2. HTML Table Code

Building a table in HTML code is another option. It does require a basic knowledge of HTML, but at least the result is a searchable table. The main drawback of hand-coding a table is that it is a labour-intensive chore and filled with opportunities for making errors as you transfer data from your spreadsheet to the page. Updating or making changes to an HTML-coded table can be even more of a hassle, and collaboration will require all the members of your team to have editing privileges on that web page. Readers can highlight and copy the text in a table produced by this method, but there's no convenient way for them to copy it into a spreadsheet, ready to use.

3. WYSIWYG Web Page Editor

Many web-builder programs let you create a table as easily as you would with a word-processing program,  but with most of them you will still have to manually transfer the data from your spreadsheet into the table. The result is an HTML table that has the same limitations on collaboration, updating, and sharing with readers as if you had hand-coded the layout.

4. Excel Webpage Format

Microsoft Excel allows you to save a spreadsheet file in webpage format, then copy and paste that HTML snippet into your web page. That is much easier than coding a table yourself, but you'll have to repeat that process every time you want to update the spreadsheet. Collaboration is extremely difficult. And, again, there's no convenient way for readers to get your HTML table data into a spreadsheet on their own computers, so they can work with it.

5. Interactive Embedded Spreadsheet

There's another option -- a searchable, interactive table that you can easily embed in a web page, which will update on your site automatically whenever you update the original spreadsheet.

Using a web-based application such as Zoho Sheet, Google Spreadsheets, or DabbleDB, embedding a searchable table becomes a simple matter of importing or creating a spreadsheet, then editing your web page to paste in a snippet of code.

Readers can't alter your table data that's displayed on your web page, but they can download the spreadsheet to work with their own computers. Updating is easy: you simply make your changes to your Zoho, DabbleBD or Google spreadsheet, and the changes are automatically reflected on your web site. And any member of your team who has editing privileges for that original spreadsheet can collaborate on keeping the information up to date.

In Part Two of this article, we'll take a closer look at how to use Zoho Sheet, Google Spreadsheets, or Dabble DB to embed an interactive, searchable spreadsheet in your blog or web page.

Published Thursday, May 15, 2008 7:30 PM by Rebecca
Email to friend AddThis Social Bookmark Button

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

annotations said:

June 4, 2008 12:03 AM

Leave a Comment

(required) 
(optional)
(required) 
Submit

We write on web technology and social media tools for non-profits - charities, associations, clubs and other organizations

  • How web masters and administrators can do more with less
  • Web 2.0 and Social Media trends
  • Ease of use - technologies that delight you and those that frustrate you
  • Industry news and upcoming events
  • Case studies and best practices

You will also see occasional posts about Wild Apricot product but we strive to be unbiased and helpful and focus on broader issues of interest to member-based, charitable and community organizations - so they can use web technology more efficiently.

About me - 'Curious Apricot'

I'm Rebecca Leaman, and it's my pleasure to join the Wild Apricot blog team in exploring how to use the internet and web 2.0 tools more effectively. Currently I am the primary blog writer. I work with Bonasource's Wild Apricot marketing team.

Please feel free to contribute non-profit technology tips and ideas by commenting on blog entries.

Read more about this blog

This blog is sponsored by Wild Apricot software:

membership management, event registration and online community website for associations, clubs and communities.

Take a tour! Take a tour!
Copyright © 2008. Wild Apricot (TM) by BonaSource Inc.
Terms of Use   Privacy Policy   Billing and Refund policy

Contact us: 144 Front Street West, Suite 725, Toronto, Ontario M5J 2L7, Toll-free phone: 1-877-270-4268, support@wildapricot.com