Demo: https://django-google-geocoding.herokuapp.com/
How this works:
- You upload an excel file (
.csv) which contains anaddresscolumn - It is assumed that the excel file contains multiple rows of addresses
- Address in each row is extracted and a Geocoding lookup is made through Google Maps Geocoding API
- The
latitudeandlongtitudeis pulled from the API response - The
latandlongfrom above is written against the same row in the address - The new excel file along with
address,latandlongis availabe for download
Note: NO address will be saved in the database
To prevent misuse, only the first 6 rows/addresses will be extracted