Read Data from Google Sheets into Pandas without the Google Sheets API

Two quick and easy ways to read in data from Google Sheets without using the Google Sheets API

Merlin Schäfer
Towards Data Science
3 min readDec 21, 2020

--

Photo by Myriam Jessier on Unsplash

Google Sheets is a common alternative to Microsoft Excel and is especially useful if you wish to work collaboratively on your spreadsheet or share your data. I want to quickly share two…

--

--

Data Scientist at HMS Analytical Software with a psychology background. Interested in all things “data”, cloud and AI.