This morning, I set up a shared Google document spreadsheet and associated form for gathering basic object information for our museum website.
Dan and I will be wanting to easily add object records to the site, but we haven’t yet worked out the best way of doing this. Using Google Docs is a good interim (and possibly, final!) way of capturing basic object information. It also allows us to easily collaborate on object records (in real time, should we need it..).
As you’ll see, we’ve kept things extremely simple at the moment, adding columns for the name/title of the object, a brief description, a unique ID, some comma separated tags and image name. As we go on we expect we’ll have to add some additional stuff. Luckily, Google Docs is pretty flexible and lets us add field names to the form without much effort.
Google docs is a great choice for this kind of initial process: not only is it extremely simple to set up forms (see this tutorial for a guide) but we know we’re always going to be able to get our data out – either by downloading it as Excel, CSV or HTML or by accessing it programmatically using the Google Docs API or feeds.
Time spent setting up Google Docs spreadsheet: 5 minutes
Money spent: £0.00
0 Responses to “Setting up a google docs spreadsheet”