Skip to main content

Dict wrapper for google spreadsheet

Project description

Manage your spreadsheets in dict way. A easy to use Google spreadsheets Python API. Manage information in the sheet in rows. Based on gspread


  • Manage the spreadsheet in dict way
  • Get/Set sheet mapping
  • Update a row or element(s) in a row.
  • Iterate rows in a spreadsheet.


  • Python 2.6+ or Python 3+, gspread


pip install dictsheet

Basic Usage

  1. [Obtain OAuth2 credentials from Google Developers Console](
  2. Obtain the sheet title.
  3. Start using dictsheet

Sample Code

import gspread
from oauth2client.service_account import ServiceAccountCredentials
from dictsheet import DictSheet

# The Credential file obtained from Google
CREDENTIAL_FILE = 'My Projecthah-xxxxxxx.json'
#Title of the sheet
SHEET_NAME = u'titleOfTheSheet'

# Create credentials
scope = ['']
credentials = ServiceAccountCredentials.from_json_keyfile_name(CREDENTIAL_FILE, scope)
# Use gspread to connect to Google Spread Sheet
gc = gspread.authorize(credentials)
sh =
wks = sh.get_worksheet(0)

# Initialize dictsheet
dict_wks = DictSheet(wks=wks)

# Basic usage
# Get mapping
print dick_wks.mapping

# Set mapping
map = {"name":1, "phone":2, "address":3}
dict_wks.mapping = map

# Appending
dict_wks.append({"name": "Chandler Huang","phone": 987654321})

# Updating (2 is the row number)
dict_wks.update({2: {"name": "Kelly"}, 6:{"phone": 12345}})

# Iterating
for idx, dict_data in dict_wks.items():
print idx, ' : ',dict_data

# Clearing a row


Chandler Huang, Xander Li

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 dictsheet, version 0.0.11
Filename, size File type Python version Upload date Hashes
Filename, size dictsheet-0.0.11.tar.gz (6.7 kB) File type Source Python version None Upload date Hashes View hashes

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