'Read data from google sheets and dump into Postgres database using python and django
I have data on google sheets and I want to dump data into the Postgres database using python and Django. Note that each row in a google sheet contains information for different tables like it could be a foreign key etc. Am looking for any tutorial/blog to serve this purpose.
Solution 1:[1]
Try any of the resources below
- https://xlsxwriter.readthedocs.io/
- django-import-export: A widget that allows you to import excel files from admin section. It's very easy to install, here you find the installation tutorial, and here an example. https://django-import-export.readthedocs.io/en/latest/
- You can also try this showing you how to import data into django
- This also works.
Is this what you are looking for?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Yusuf Ganiyu |