Convert Google SpreadSheet document to CSV files
Google sheets to csv
An utility tool to download google sheets to csv files.
As common python library you can use pip to get the latest stable release
pip install google-sheets-to-csv
The most accurate information will be available using
gs-to-csv --help usage: gs-to-csv [-h] [--service-account-credential-file SERVICE_ACCOUNT] [-f] [-b BUFFER_LINES] [--logging-file LOGGING_FILE] [--logging-level LOGGING_LEVEL] [--logging-format LOGGING_FORMAT] spreadsheet selector directory Convert google spreadsheet sheets to csv optional arguments: -h, --help show this help message and exit Converter options: --service-account-credential-file SERVICE_ACCOUNT If you want to use this command in a script without user interractions, you can create a service account from google console: https://developers.google.com/workspace/guides/create- credentials#create_a_service_account and share read access sheets you want to export. (default: None) -f, --force Tell this app tp overwrite existing files if present. (default: False) -b BUFFER_LINES, --buffer-lines BUFFER_LINES Maximum number of lines to retreive by http calls. (default: 500) spreadsheet Id of the spreadsheet you want to export to csv. Spreadsheet id is the weird data present in the uri just after `d/`: https://docs.google.com/spreadsheets/d/<the spreadsheet id is here>/ selector Sheet selector is a regex expression to match sheets titles. Some examples: - `.*`: would export all sheets - `(abcd)|(efgh)`: would export abcd and efgh sheets directory Output directory with write access where csv files will bewritten. Logging params: --logging-file LOGGING_FILE Logging configuration file, (logging-level and logging-format are ignored if provide) (default: None) --logging-level LOGGING_LEVEL --logging-format LOGGING_FORMAT This will create a .csv file per sheet with title match with the regex expression.
There are two ways to let this program access to your google sheets:
You can provide google service account credentials with
By default script will open your browser that let you authorize (or not) readonly access to all your Google Sheets documents to this application which is running on your computer. An authorization token will be saved in your home directory:
.gs-to-csv-token.json(You can control that path using
GS_TO_CSV_TOKEN_FILE_PATHenv variable). You can watch following howto on youtube:
Google sheets API give a
columnCountvalue which is a bit useless as we get extra cells. So for convenience this return, for each row, the same number of cells as the first line (expected header line!) which can result with empty lines or truncated data.
lines without any values do not return blank line even in the middle of the sheet.
Using user account (with auth flow) has http call rate limit using an highest
--buffer-linesoption can counter part a bit this limitation.
- Share your spreadsheet using "Anyone with link can view".
- Then do a wget (or curl) with the download url, you'll find the
sheet_idin the url in your browser
$ wget --output-file="logs.csv" "https://docs.google.com/spreadsheets/d/<document_id>/export?format=csv&gid=<sheet_id>" -O "downloaded_content.csv"
The data will be in the file: downloaded_content.csv
- nothing special to install
- enable share link access on each spreadsheet
sheet_idfor any sheets you want to download
- use one command per sheet to export
Logo is derived from CSV File by Milinda Courey from the Noun Project
- Major version introduce API change
- Minor version change behaviour
- Patch version are about released documentation or refactor or hotifx that do not meant to change previous numbers
.gs-to-csv-token.jsontoken file is create in read/write only for the current user.
- Initial implementation
Release history Release notifications | RSS feed
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Hashes for google-sheets-to-csv-0.2.0.tar.gz
Hashes for google_sheets_to_csv-0.2.0-py3-none-any.whl