Welcome, guest | Sign In | My Account | Store | Cart

Notice! PyPM is being replaced with the ActiveState Platform, which enhances PyPM’s build and deploy capabilities. Create your free Platform account to download ActivePython or customize Python with the packages you require and get automatic updates.

Download
ActivePython
INSTALL>
pypm install gspreadsheet

How to install gspreadsheet

  1. Download and install ActivePython
  2. Open Command Prompt
  3. Type pypm install gspreadsheet
 Python 2.7Python 3.2Python 3.3
Windows (32-bit)
Windows (64-bit)
Mac OS X (10.5+)
Linux (32-bit)
Linux (64-bit)
0.3.0 Available View build log
 
Author
License
Apache Software License
Dependencies
Imports
Lastest release
version 0.3.0 on Jan 9th, 2014

A wrapper around a wrapper to get Google spreadsheets to look like csv.DictReader.

If you're used to working with CSVs or a human, you'll find that working with Google's Python API for spreadsheets is so frustrating. With gspreadsheet, you can adapt your existing csv code to work with Google Spreadsheets with just two line changes. As an added bonus, if you alter the dict, those changes get saved back to the original spreadsheet.

Installation

pip install gspreadsheet

Usage

If your old CSV code looked like this:

from csv import DictReader
reader = DictReader(open('myspreadsheet.csv'))
for row in reader:
    process(row)

It would look like this with gspreadsheet:

from gspreadsheet import GSpreadsheet
reader = GSpreadsheet("https://docs.google.com/myspreadsheet")
for row in reader:
    process(row)

So looking at more examples...

Get a spreadsheet if you know the key and worksheet:

sheet = GSpreadsheet(key='tuTazWC8sZ_r0cddKj8qfFg', worksheet="od6")

Get a spreadsheet if you just know the url:

sheet = GSpreadsheet(url="https://docs.google.com/spreadsheet/"
                         "ccc?key=0AqSs84LBQ21-dFZfblMwUlBPOVpFSmpLd3FGVmFtRVE")

Since just knowing the url is the most common use case, specifying it as a kwarg is optional. Just pass whatever url is in your browser as the first argument.:

sheet = GSpreadsheet("https://docs.google.com/spreadsheet/"
                     "ccc?key=0AqSs84LBQ21-dFZfblMwUlBPOVpFSmpLd3FGVmFtRVE")
Authenticating

Get a spreadsheet as a certain user:

sheet = GSpreadsheet(email="foo@example.com", password="12345",
                     key='tuTazWC8sZ_r0cddKj8qfFg', worksheet="od6")

You can also specify the email and password using environment variables: GOOGLE_ACCOUNT_EMAIL and GOOGLE_ACCOUNT_PASSWORD.

And as an authenticated user, you can modify the spreadsheet.:

for row in sheet:
    print row
    if row['deleteme']:
        row.delete()  # delete the row from the worksheet
        continue
    row['hash'] = md5(row['name']).hexdigest()  # compute the hash and save it back

data = row.copy()   # get the last row as a plain dict
sheet.add_row(data)  # copy the last row and append it back to the sheet
Advanced Usage: Saving data back to the spreadsheet

If you modify the dict that represents a row, those changes will get pushed back to the spreadsheet:

>>> row['value']
'foo'
>>> row['value'] = 'bar'  # Change this value
>>> row['value']
'bar'
Advanced Usage: Deferring Saves

If you do multiple changes to a row, the script can get very slow because it has to make a syncronous request back to the server with every change. To avoid this, you can turn on deferred saves by setting deferred_save=True when instantiating a GSpreadsheet. Just remember to .save():

sheet = GSpreadsheet(email="foo@example.com", password="12345",
                     key='tuTazWC8sZ_r0cddKj8qfFg', worksheet="od6",
                     deferred_save=True)

row = sheet.next()
for key in row.keys():
    row['key'] = ''
row.save()

Scary Warnings

I really want to say this is alpha software, but we've been using bits and pieces of this for over a year now. Everything is subject to change, even the names. This also relies on google's relatively ancient gdata package, which does not have support for Python 3.

Similar Python packages

Subscribe to package updates

Last updated Jan 9th, 2014

What does the lock icon mean?

Builds marked with a lock icon are only available via PyPM to users with a current ActivePython Business Edition subscription.

Need custom builds or support?

ActivePython Enterprise Edition guarantees priority access to technical support, indemnification, expert consulting and quality-assured language builds.

Plan on re-distributing ActivePython?

Get re-distribution rights and eliminate legal risks with ActivePython OEM Edition.