Ask coding questions

← Back to all posts
import sheets data to python
DeathTheKid665

how would i go about incoorporating my data from a google sheets file into my code. and get it so that i can search for specific information and get the data on where to find it.

Voters
fbaalache
eporter1977
FerdausIsa
ZacharyWood
Comments
hotnewtop
ash15khng

You would have to download the Google Sheet as an Excel file (.xlsx) then upload it to repl.it. Then you can follow this tutorial and try to figure it out: https://realpython.com/openpyxl-excel-spreadsheets-python/
(sorry I've never done it before so I can't really help you)