=====================================

This Python program depends on a geopy python wrapper and a Google API key. It will read and geocode a csv file. Through the Google geocoding API, you can geocode up to 2,500 address per day. The Geopy wrapper has methods for several geocoding services though, so one could try/except through many more addresses.

The code as written requires the address csv file to contain the following columns: fullAddress = row["Address"] + ', ' + row["City"]+ ', ' + row["State"]+ ' ' + row["Zip"]

However, this can easily be modified to any address column, such as: fullAddress = row["Full Adddress"] or fullAddress = row["Address"] + ', ' + row["CityStateZip]

The better the address input, the more accurate the geocoding results.

pip is required to install python modules. Make sure to add Python to the PATH environmental variable (C:\Python27\ArcGIS10.6 for ArcGIS installations of Python).

First install GeoPy API using pip with:

pip install geopy

Install xlswriter to write Excel files:

pip install xlswriter