extract-gsheet
Quickly extract JSON data from a public Google Sheet without any API keys. (by ngblaylock)
tabletop
Tabletop.js gives spreadsheets legs (by jsoma)
extract-gsheet | tabletop | |
---|---|---|
1 | 3 | |
2 | 3,775 | |
- | - | |
4.2 | 0.0 | |
4 months ago | 6 months ago | |
Nunjucks | JavaScript | |
MIT License | MIT License |
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.
extract-gsheet
Posts with mentions or reviews of extract-gsheet.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-03-24.
-
Extract Data from Google Sheets
If you have questions, drop them in the comments here, or let me know on GitHub. I hope you find this useful.
tabletop
Posts with mentions or reviews of tabletop.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-03-24.
-
Extract Data from Google Sheets
One solution I have used to get Google Sheet data was Tabletop.js which was written several years ago and no longer works. Other solutions out there cost money. Some seem a little questionable when you hand over your Google credentials allowing them access to your Google Drive.
- Google Sheet data to Max/MSP?
-
Using Google Sheets as a simple database with Papa Parse
The promising library user in the aforementioned example was Tabletop. I was excited while reading their npm page, but the Github readme stated how the package is getting deprecated by Google's changes. It's a shame since that package seemed to offer many utility features for listing data from spreadsheets out of the box (including reading data from multiple sheets). Luckily, they provided an alternative (albeit much more general-purpose, but still usable for simple examples). The alternative in question is...
What are some alternatives?
When comparing extract-gsheet and tabletop you can also consider the following projects:
gsSQL - Use real SQL SELECT syntax to filter your Google Sheets data using a simple custom function.
React95 - A React components library with Win95 UI
SheetsIO - Small configurable Java app that pulls data from a Google Spreadsheet (using v4 api) and writes to files and a local webserver.
qsheets - Questrade to Google Sheets bridge
cachefinance - A custom function and trigger to supplement GOOGLEFINANCE so data is always available and unsupported stocks can get price/name/yield data. As you can guess from the name, data is cached so when '#N/A' appears it does not mess up your asset history logging/graphing.