Categories
Data Science

How to Retrieve Data from Google Sheet

R data is huge, so it is general to analyze on a desktop (local computer) or a server which provides better computing power. However, the former is inconvenient when you analyze data without your computer while the latter requires a complicated set-up process. There is an option to use cloud DB without paying money: Google Sheet.

gSheet_to_R

The process is very simple as in the guideline of this website.

Simply, you make two R files to clean and read data from Google tables (download or copy-and-paste them). Then, you can put some lines into your R script as follows:

> library(“XML”)
> source(“cleanGoogleTable.r”)
> source(“readGoogleSheet.r”)
> data <- “URL of data”
> elm <- readGoogleSheet(data)
> out <- cleanGoogleTable(elm, table=1)

Leave a Reply

Your email address will not be published. Required fields are marked *