Schatt95 Schatt95 - 1 month ago 17
R Question

Import Google table csv to RStudio

Is it possible to import csv table into R directly form Google docs? Got to give a hands-on seminar to people who are not supposed to do anything with R.

Thanks for help!

Joe Joe
Answer

With the package gsheet you can read in a sheet from the shareable link. Example given in the docs:

library(gsheet)
url <- 'docs.google.com/spreadsheets/d/1I9mJsS5QnXF2TNNntTy-HrcdHmIF9wJ8ONYvEJTXSNo'
a <- gsheet2tbl(url)

It's quite nice.

Comments