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 *

Your post must include a link to this post.

How does this work?
Write a response on your own website and include a link to this post. Then submit your response’s URL here. Your response may appear here after moderation. To update or remove it, edit or delete your original post and submit the same URL again. Learn more about Webmentions.