blog/working-with-google-sheets-from-r/

[utterances-bot]

Working with Google Sheets from R | Jonathan Trattner

In Google Sheets, a 'spreadsheet' is a file containing individual, often related, 'worksheets' (tabs). In this post, I briefly cover the distinction between these -- and their correlate in Microsoft Excel -- as well as highlight how to read/write data stored within or between worksheets. I share my thoughts on which method is better (whichever meets your use-case!) and introduce a utility function, wrapping the R package googlesheets4, for aggregating data from multiple worksheets.

https://www.jdtrat.com/blog/working-with-google-sheets-from-r/