Snapsheets
Effortlessly download public Google Spreadsheets in bulk!
Tired of downloading Google Spreadsheets one by one through your browser? Snapsheets is here to save you time and effort! With this tool, you can quickly grab multiple Google Spreadsheets straight from your terminal --- all you need is a public link to the sheets.
No more repetitive clicking. No more hassle. No auth needed. Just fast and easy spreadsheet downloading!
Install
$ pip3 install snapsheets
$ pipx install snapsheets
$ uv tool install snapsheets
Usage
$ snapsheets --url="copy_and_paste_url_here"
2022-06-09T08:09:31 | SUCCESS | 🤖 Downloaded snapshot.csv
2022-06-09T08:09:31 | SUCCESS | 🚀 Renamed to _snapshot.csv
Docs and Repository
- Read the Docs : https://snapsheets.readthedocs.io/en/latest/
- GitLab Pages : https://qumasan.gitlab.io/snapsheets/
- GitLab Repos : https://gitlab.com/qumasan/snapsheets/
- PyPI package : https://pypi.org/project/snapsheets/
Help
snapsheets -h
usage: snapsheets [-h] [--config config | --url url] [-o filename]
[-d description] [-t format] [--skip] [--debug]
[--version]
snapsheets
options:
-h, --help show this help message and exit
--config config set config file or directory
--url url set URL of Google spreadsheet
-o filename set output filename
-d description set description of a spreadsheet
-t format set datetime prefix for backup filename
--skip skip file
--debug show more messages
--version show program's version number and exit
- For Sheet-mode: Use
--urloption to download single spreadsheet. - For Book-mode: Use
--configoption to download multiple spreadsheets.- create a directory for config files.
- create a config file in TOML format.
Examples
Book-mode: with --config argument
$ snapsheets --config="config/"
2022-06-09T08:05:48 | SUCCESS | 🤖 Downloaded filename.csv
2022-06-09T08:05:48 | SUCCESS | 🚀 Renamed to 2022_filename.csv
2022-06-09T08:05:49 | SUCCESS | 🤖 Downloaded filename.csv
2022-06-09T08:05:49 | SUCCESS | 🚀 Renamed to 20220609_filename.csv
Sheet-mode: with --url argument
snapsheets --url "https://docs.google.com/spreadsheets/d/1NbSH0rSCLkElG4UcNVuIhmg5EfjAk3t8TxiBERf6kBM/edit?gid=0#gid=0"
2024-10-02T17:25:06 | SUCCESS | 🤖 Downloaded as snapshot.csv
2024-10-02T17:25:06 | SUCCESS | 🚀 Renamed to _snapshot.csv
-
Downloaded file is temporarily named as
snapshot.csv, then renamed to_snapshot.csv. -
Make
./config/directory and place your TOML files.- If
./config/does not exist, it will search from. (current directory).
- If
-
Downloaded files are saved to
./snapd/directory- If
./snapd/does not exit, it will be saved in. (current directory).
- If
As module: import snapsheets
from snapsheets.sheet import Sheet
url = "https://docs.google.com/spreadsheets/d/1NbSH0rSCLkElG4UcNVuIhmg5EfjAk3t8TxiBERf6kBM/edit#gid=0"
sheet = Sheet(url=url, desc="Get Sample Sheet")
sheet.snapshot()
📣 Get Sample Sheet
🤖 Downloaded snapshot.csv
🚀 Renamed to 20220602T225044_snapshot.csv
Other requirements
- Install
wgetif your system doesn't have them - Make your spreadsheet available with shared link (OK with read-only)
1 maintainer
Metadata
1 maintainer
Release files for snapsheets 1.1.3
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | |
|---|---|---|---|---|
| snapsheets-1.1.3.tar.gz | 21.8 kB | Without provenance | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| snapsheets-1.1.3-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 36.8 kB
Release files / snapsheets-1.1.3.tar.gz
| Download URL | snapsheets-1.1.3.tar.gz |
|---|---|
| Size | 21.8 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
82657c8ca232e8f63f83dd54f1f8c5c7383f5836a74df2d69615eaab35fc3182
|
|
BLAKE2b-256 checksum How to use checksums |
3fe5bfd8ef37479dd989365012981625a3f260107f993d388f68a7fb30c45fcc
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
uv/0.13.5 {"installer":{"name":"uv","version":"0.13.5","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"macOS","version":null,"id":null,"libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}
|
Release files / snapsheets-1.1.3-py3-none-any.whl
| Download URL | snapsheets-1.1.3-py3-none-any.whl |
|---|---|
| Size | 15.0 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
a47fd4ac4ad716a3dc062115dd3f1583940dfa0a6e22931999c47095b8806059
|
|
BLAKE2b-256 checksum How to use checksums |
e89f76b357636592e25b671ddbb685c2e59d5def4873ecfd1224fa098a0a54e4
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
uv/0.13.5 {"installer":{"name":"uv","version":"0.13.5","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"macOS","version":null,"id":null,"libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}
|
Security for snapsheets 1.1.3
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
No provenance found
None of the files in this release were uploaded with provenance metadata.
A note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.
