Google Spreadsheets As A Database

Following on from the Google Spreadsheet links in the previous post, I spotted this retweet from Guardian Datastore. Interesting – database querying of a Google Spreadsheet. So following a link takes me to Tony Hirst’s blog and a how-to on applying SQL type queries to a Google Spreadsheet. Very useful.

Tony then takes the data and visualises it using Many Eyes Wikified. Very impressive and a site I hadn’t heard of or used before. Applying the same principles Tony has now applied visualisations to the Shadow Cabinet spreadsheet.

Only slight snag I can see is that spreadsheets are easy to change and hence the visualisations could break easily – more easily than a database would. Apart from that though I’m very impressed. I’m off to dabble!

Leave a Reply