Google Sheet to Jupyter Notebook

This video walks you through importing a google sheet with multiple tabs into a Jupyter Notebook using python and pandas. This will create a pandas data frame you can easily manipulate in python.

[@thivankadilshanlokuliyanag5783]

Thank you so much you sold my problem easily. thanks again

[@1TreukFlyyy]

Simple and effective !!! Thanks a lot ! Awesome when you want to load a sheet into a colab notebook !

[@sortedsandy]

OMG... I don't know why this video doesn't show up... This is what everyone needs and YT shows all the other longer unnecessary ways of doing it.
Thanks much for this video
It's very helpful

[@taylorallynsexoticskincare1154]

Hello I just want to thank you for the video. I almost had to drop my class. You helped me stay in the game. Thank you

[@LifeHappens2]

👍 I used Colab notebook instead and it worked like a charm. Great Video !!!👍

[@akshaymishra633]

Hy amy; i saw your video but the method you demonstrated does not works on my system could you help.
upon following the exact on jupyter notebook it is showing following error
"Invalid file path or buffer object type: "
on following line: 5 read_1=pd.read_excel(xls,'practice',header=1)

[@franciscohernandez7308]

Thank you so much, it really helped me

[@chrismacintosh4719]

Thanks! :) Nice to have a quick solution without a bunch of hoops!

[@chrisruzicka2309]

thanks for the great video, do you also have one that shows how to write data to a google sheet?

[@virturus7720]

YOU ARE THE BEST, THANK YOU SO MUCH

[@veerkaku9448]

Awesome..i need this ...thank you .

[@gabrielsantosribeiro3965]

thanks!! amazing solution

[@mbaniyounis]

I try that , but I received this SMS "Host is unreachable" ! what to do ?

[@file_one]

thank you, extremely useful!

[@RahulA-b9o]

how to do that for specific sharing people? in google sheets

[@shreyshainaluthra1991]

awesome !!! ty