Using Google Spreadsheets with R: an update

Prompted by a rush of visitors from Andrew Gelman's blog, I went back and updated the details of my post from 2009 on reading data from Google Spreadsheets into R. Since then, Google had switched to using a secure (https) connection for Google Docs, which required some tweaks to the code. If you haven't seen it before, it's a neat way of using Google Spreadsheets as a data editor (it makes it easy to import data into R), or as a way of sharing data for others to use with R. The link's below.

Revolutions blog: How to use a Google Spreadsheet as data in R

Comments

[Tony Hirst]

These posts may be of interest too - a way of using Google Spreadsheets as a database that you can query from within R:

http://blog.ouseful.info/2011/09/02/using-google-spreadsheets-as-a-database-source-for-r/

http://blog.ouseful.info/2011/09/07/google-spreadsheets-api-listing-individual-spreadsheet-sheets-in-r/

[Al]

I was a little thrown off when Google Documents changed. I've since adjusted and appreciate the improved features. My SEO reseller appreciates the faster loading time, too.