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

Your email address will not be published. Required fields are marked *

To respond on your own website, enter the URL of your response which should contain a link to this post's permalink URL. Your response will then appear (possibly after moderation) on this page. Want to update or remove your response? Update or delete your post and re-enter your post's URL again. (Find out more about Webmentions.)