Skip to content

Instantly share code, notes, and snippets.

@Amice13
Forked from tukachev/gspreadsheet.R
Created June 11, 2014 11:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Amice13/e2f09005e931f9a2f486 to your computer and use it in GitHub Desktop.
Save Amice13/e2f09005e931f9a2f486 to your computer and use it in GitHub Desktop.
read.gspreadsheet <- function(key) {
require(RCurl)
myCsv <- getURL(paste("https://docs.google.com/spreadsheet/pub?hl=en_US&hl=en_US&key=",
key, "&single=true&gid=0&output=csv", sep = ""),
.encoding = "UTF8")
read.table(textConnection(myCsv), header = T, sep = ",", stringsAsFactors = FALSE)
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment