googlesheets4
Google Spreadsheets R API (reboot of the googlesheets package) (by tidyverse)
unpivotr
Unpivot complex and irregular data layouts in R (by nacnudus)
| googlesheets4 | unpivotr | |
|---|---|---|
| 4 | 2 | |
| 352 | 182 | |
| 0.9% | - | |
| 4.7 | 0.0 | |
| 3 days ago | 9 months ago | |
| R | R | |
| GNU General Public License v3.0 or later | GNU General Public License v3.0 or later |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
googlesheets4
Posts with mentions or reviews of googlesheets4.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-02-11.
-
Use spreadsheet as data source?
I have used google sheets as a data source before. One can feed it with google forms (to populate rows) and it can handle concurrent users entering stuff. Never did ~1000 though— that’s a lot. There is a tidyverse package, googlesheets4, that reads the sheets. It works fine. There are similar packages for excel.
-
Beginner needing help splitting a table into 2 tables based on mean value
Here is a guide to reading Google Sheets data into R.
-
R Shiny Input UI
If you can do it programatically, you can do it with Shiny (its just the interface). Here is an api for working with Google sheets (https://googlesheets4.tidyverse.org/).
- Need help converting google sheet to pandas dataframe, without google API or public viewing setting.
unpivotr
Posts with mentions or reviews of unpivotr.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-06-03.
-
Importing Excel Formulae into R
maybe try {unpivotr} (https://nacnudus.github.io/unpivotr/) or {tidyxl} packages?
-
[Question] Currently painstakingly copying and pasting data from messy, unformatted Excel spreadsheet into a new spreadsheet in order to analyze it. Is there an easier way?
If you’re okay programmer in R, try the unpivotr package https://github.com/nacnudus/unpivotr
What are some alternatives?
When comparing googlesheets4 and unpivotr you can also consider the following projects:
dplyr - dplyr: A grammar of data manipulation
datapasta - On top of spaghetti, all covered in cheese....
ExcelDataReader - Lightweight and fast library written in C# for reading Microsoft Excel files
xlsx - An R package to interact with Excel files using the Apache POI java library
ShinyWebAppWithFormAndLeafletMap - This repo contains the code to build a webapp for data collection and viewing the map on a leaflet map using R Shiny. The specific webapp that I built is aimed to collect data of sustainability practices of various eateries around the world, in the times of climate change.
excel.link - Convenient Data Exchange between R and Microsoft Excel