Reading Google Docs using R Curl


and finally I can download my Google spreadsheet file using-


download.file(url=””, destfile=”cacert.pem”)


b <- getURL(url,cainfo=”cacert.pem”)

write.table(b,quote = FALSE, sep = “,”,file=”test.csv”)


Previously (for past 3 5 7 hours)-

The codes at dont work thanks to the SSL authentication issue. and the packages at [] and [] are missing in action. 

So I mixed the codes at and

and I get this error while using

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


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s