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.

Files for csv-export-gsheets, version 0.0.13
Filename, size File type Python version Upload date Hashes
Filename, size csv_export_gsheets-0.0.13-py2.py3-none-any.whl (6.9 kB) File type Wheel Python version py2.py3 Upload date Hashes View
Filename, size csv-export-gsheets-0.0.13.tar.gz (15.9 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page