r - Read csv file hosted on Google Drive

Question

I am trying to access (read into R) a .csv file hosted on Google Drive (NOT a Drive spreadsheet) -- having set file permission to 'publicly shareable'.

So based on the shareable URL:

sURL <-"https://drive.google.com/file....view?pli=1"

I have been trying to read in using:

library(curl)
x <- curl(sURL)
data <- read.csv(x)

I'm getting this error message:

Error in read.table(file = file, header = header, sep = sep, quote = quote,  : 
more columns than column names

Any idea what the complaint is about? Thanks guys.

Answer 1

You could try it like this

id <- "0B-wuZ2XMFIBUd09Ob0pKVkRzQTA" # google file ID
read.csv(sprintf("https://docs.google.com/uc?id=%s&export=download", id))