import pandas as pd sheet_url = 'https://docs.google.com/spreadsheets/d/1XqOtPkiE_Q0dfGSoyxrH730RkwrTczcRbDeJJpqRByQ/edit#gid=0' url_1 = sheet_url.replace('/edit#gid=', '/export?format=csv&gid=') df=pd.read_csv(url_1)