Has anyone had any experience using Google spreadsheets to store data online so multiple people can enter and maintain data, then publishing or exporting (csv,xls,ods) the sheet for their application? What is the easiest way to process the sheet? If the data can be accessed as a link the updates could be immediately reflected in the client's app.
+1
A:
This article Data Scraping Wikipedia with Google Spreadsheets discusses using Google spreadsheets as an application platform.
It already has features that allow you to share the spreadsheet with multiple editors, as well as the ability to define forms that you can invite people to fill out who's results will be entered into the spreadsheet as a row.
HTH
Kyle Burton
2008-10-28 19:43:35
A:
Just in case its still vaguely of interest 5 months later, there is a SQL-like wrapper language for Google Spreadsheets at:
Its very much an alpha release - but maybe its of some use or perhaps the code could give you some ideas.
tonys
2009-04-24 11:05:07