Check out the store for many more

Geocode Cells

offered by mlucool17,638 users


Use Google's geocoding to convert addresses to GPS coordinates in a Google spreadsheet.
Install this to add an add-on to geoencode an address/location into latitude and longitude in a Google spreadsheet. To use, select a contiguous column of data to convert and choose Macros->Geoencode Selected Cells. The results are stored in the columns labeled 'Lat' and 'Lng'. 

Google requires you to turn this on for every sheet you wish to use it. To enable go to: Add-ons->Manage Add Ons. Click "manage": next to Geocode Cells and select "Use in this Documenting" 
See: for more info. 

Note: This uses the Google geoencode API to do geoencoding, which has a strict limit on calls per day.


Version: 10
Updated: November 21, 2015
Language: English