Skip to main content

Export CSV files to Google Spreadsheets

Project description

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

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Filename, size & hash SHA256 hash help File type Python version Upload date
csv_export_gsheets-0.0.13-py2.py3-none-any.whl (6.9 kB) Copy SHA256 hash SHA256 Wheel py2.py3
csv-export-gsheets-0.0.13.tar.gz (15.9 kB) Copy SHA256 hash SHA256 Source None

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page