README.md

Geocoding-Excel-Input-Output

Problem statement

1. Create a web service that allows user to upload an Excel sheet with address field. One or ore rows allowed.
   
2. The system should use these address fields and using Google eocoding API, get the latitude and longitude of that address.
   
3. The system then provides an excel download of the address excel ith latitude and longitude and formatted address fields.
   

---

Choose a Excel file(.xlsx or .xls) with name of cities or countries in one column and resulting file will contain the latitute and longitude of cities in the second and third column.
This application demonstates a simple Web Application based on [Django Framework 1.11](https://www.djangoproject.com/) of Python. The application uses python2.7

To run this app locally

1. Install Python2.7 : https://www.python.org/downloads/
2. Install pip for python
   sudo apt-get update
sudo apt-get install python-pip
3. Install Virtual Environment
   sudo pip install virtualenv
4. Extract the Zip Folder and create Virtual Environment
   virtualenv venv
   
5. Activate the Virtual Environment
   source venv/bin/activate
pip install -r requirements.txt
python manage.py runserver
   Open localhost on your browser 127.0.0.1:8000
   

Choose a File and Click the Upload Button, the required file with Longitude and Latitudes data will start download.