Search code examples
rcsvcurlweb

Read csv file hosted on Google Drive

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.

Solution

  • 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))