Skip to main content

Import/Export CSV files to Google Spreadsheets

Simple CSV import/export wrapper for gspread package.

Build status Latest PyPI version Download format License

Installation

PIP

You can install the latest stable package running this command:

$ pip install csv_export_gsheets

Also you can install the development version running this command:

$ pip install git+http://github.com/dlancer/csv_export_gsheets.git@dev

Usage

Before you start you should:

  1. Create Google Service Account key (use JSON format):

    https://gspread.readthedocs.io/en/latest/oauth2.html

  2. Create new spreadsheet in the Google Spreadsheets.

  3. Share this spreadsheet with email from created service account file.

From command line:

$ csv2gsheets --help

From python code:

from csv_export_gsheets.gsheet import import_csv

# src - path to source CSV file or StringIO object
# url - destination sheet url
# cell - destination sheet cell (can include tab name: 'MyTab!A1')
# credentials - path to service account credentials or dict
# config - path to config file or dict
import_csv(source=src, url=url, cell=cell, credentials=credentials, config=config)

Please note: destination sheet will be cleared before import.

TODO

  • export from google spreadsheet to CSV

Metadata

Release files for csv-export-gsheets 0.0.13

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for csv-export-gsheets 0.0.13
File Size Uploaded Provenance Actions
csv-export-gsheets-0.0.13.tar.gz 15.9 kB Without provenance Details for csv-export-gsheets-0.0.13.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for csv-export-gsheets 0.0.13
File Interpreter ABI Platform Actions
csv_export_gsheets-0.0.13-py2.py3-none-any.whl Python 3, Python 2 none any Details for csv_export_gsheets-0.0.13-py2.py3-none-any.whl

Total release size: 22.9 kB

Release files / csv-export-gsheets-0.0.13.tar.gz

Download URL csv-export-gsheets-0.0.13.tar.gz
Size 15.9 kB
Tags Source
SHA-256 checksum
How to use checksums
967326fddda1efc34628ee66394f6080fee031c48d1fa1c7afb9f427b96ee833
BLAKE2b-256 checksum
How to use checksums
317422ba148624fdb8ec7fb3aadf8f3d222f2a71a4f263f700ac558983ed7bb7
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/1.13.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.0.1 requests-toolbelt/0.9.1 tqdm/4.32.1 CPython/3.6.7

Release files / csv_export_gsheets-0.0.13-py2.py3-none-any.whl

Download URL csv_export_gsheets-0.0.13-py2.py3-none-any.whl
Size 6.9 kB
Tags Python 2 Python 3
SHA-256 checksum
How to use checksums
ab1bd277f498eadcf5ed82ae468e2bd248e2cd909d8124d844d121eb6e8561c5
BLAKE2b-256 checksum
How to use checksums
308f08b58890779c1751be5d3d949469ce2f4d816255b636a75912c99e39d3f3
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/1.13.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/41.0.1 requests-toolbelt/0.9.1 tqdm/4.32.1 CPython/3.6.7

Security for csv-export-gsheets 0.0.13

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.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page