Skip to content

Cookbook

jfburkhart edited this page Mar 5, 2013 · 4 revisions

This is community generated cookbook. Please, feel free to share your recipes.

gspread with pandas

Had to share... this was just too easy.

import gspread
import pandas
gc = gspread.login('my@email.com', 'supersecretekey')
book = gc.open('My Spreadsheet')
sheet = book.sheet1 #in this case
dataframe = pandas.DataFrame(sheet.get_all_records())
Clone this wiki locally