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.
Asked
Active
Viewed 525 times
0
-
What have you done so far? – Naeem Khan Feb 20 '22 at 07:47
-
Have not done anything yet, looking for tutorial to start – The knight Feb 20 '22 at 07:49
1 Answers
0
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?
Yusuf Ganiyu
- 842
- 9
- 8
-
I have data on the google sheets not in the hard drive as a CSV downloaded file – The knight Feb 20 '22 at 09:32