pandas read google sheet
from io import BytesIO import pandas as pd import requests r = requests.get('https://docs.google.com/spreadsheet/ccc?key=0Ak1ecr7i0wotdGJmTURJRnZLYlV3M2daNTRubTdwTXc&output=csv') data = r.content df = pd.read_csv(BytesIO(data), index_col=0,parse_dates=['Quradate']) df.head()