Geocode an Address using Excel and Geocoder.us

geocodeI’ve been experimenting with the Google Maps API lately and find myself frequently visiting Geocoder.us to geocode addresses to latitude and longitude.

GeoCode: “A geocode is a geographical code to identify a point or area at the surface of the earth.”

In the process I developed a spreadsheet that would look up the latitude and longitude of a given address via geocode.us and return the result to Excel.

Here’s a stripped down version which will return the geocoded results for one address: Download the Geocode Spreadsheet.

Related: Google Maps in Excel