Python script to convert addresses to coordinates using google maps
simplejson
openpyxl
from script import coordinates
test = coordinates('first avenue, new york, usa')
>>> print test['lat']
40.763368
>>> print test['lng']
-73.95924
#The third argument of this function is the column that contains the address.
#It wil read the input.xlsx file, read the 'Plan1' sheet, looking for coordinates to addresses('0' column)
#And create another file 'output.xlsx' with two more columns lat and lng for each row.
from script import xlsx_coordinates
xlsx_coordinates('input.xlsx','Plan1',0,'output.xlsx')
from script import create_kml
create_kml('input.xlsx','sheet_name','output.kml')