Download data from Google Spreadsheets

gsheet.py

import urllib2

DOC_PATH = 'https://docs.google.com/spreadsheet/pub?key=%s&output=txt'
GID_PARAM = '&single=true&gid=%s'

def load(docid, sheetid=None):
    srcpath = DOC_PATH % docid
    if sheetid != None: srcpath = srcpath + (GID_PARAM % sheetid)
    src = urllib2.urlopen(srcpath)
    return [l.split('\t') for l in src.readlines()]

if __name__ == '__main__':
    testid = '0Atgd-n28fU3PdGlsMTdLRUFqR3JvbktmcWhqTFpSZmc'
    print len(load(testid, 0))