Download Google sheet as text.

Share:

Description

Downloads a Google sheet as text, using just the url. The Google sheet must have 'share by link' turned on.

Usage

1
gsheet2text(url, format = "csv", sheetid = NULL)

Arguments

url

the google sheet url

format

controls the column separator used. csv or tsv

sheetid

the id of the sheet to download from. (Default NULL, downloads the first sheet)

Details

sheetid is the index of the sheet to be downloaded. If you use the direct sheet URL, rather than the share by link, this will automatically be extracted. Otherwise, the first sheet will be downloaded by default.

See Also

gsheet2text to download as a table

Examples

1
2
3
url <- 'docs.google.com/spreadsheets/d/1I9mJsS5QnXF2TNNntTy-HrcdHmIF9wJ8ONYvEJTXSNo'
a <- gsheet2text(url)
b <- read.csv(text=a)

Want to suggest features or report bugs for rdrr.io? Use the GitHub issue tracker.