Thought I would check out the Google Spreadsheets API whilst I sort out my mySQL database. The API lets you use the spreadsheet like a database – enabling structured queries, edits and uploads of data to the spreadsheet from a client application.
You can also specify how you want the data returned – for example as a list or in cell format and/ or with read only or full read and write capability to viewers.
The limitations are quite generous with the API catering for 10,000 rows of data and 50,000 cells. I tested it out with a web page that builds a structured URL query to interrogate an Ironman results spreadsheet published (ie made public) at Google documents . The results are from Ironman Australia 2007.
Here is the page link:
