Batch Geocoder

This web app is a batch geocoder retrieving latitude and longitude of multiple adresses, using Google Maps API.
Price = $0.01/record. Minimum price = $2.50.

Download Excel template

Record_numberCityPostal_codeStreet_name_and_numberCountryStateCounty/ProvinceOther_1Other_2Other_3
Record_number;City;Postal_code;Street_name_and_number;Country;State;County/Province;Other_1;Other_2;Other_3;Precision;Latitude;Longitude;City;Postal_code;Country;Full_address
1;Alphen aan den Rijn;2402GX;Handelhof 82;Nederland;;;;;;ROOFTOP;52.1463105;4.670809800000029;Alphen aan den Rijn;2402 GX;Netherlands;Händelhof 82 # 2402 GX Alphen aan den Rijn # Netherlands
2;Mountain View;94043;1600 Amphitheatre Parkway;US;CA;;;;;ROOFTOP;37.4223244;-122.0843505;Mountain View;94043;United States;1600 Amphitheatre Pkwy # Mountain View # CA 94043 # USA
  • Fields precision, latitude, longitude, and full address are added to your inputs.
  • Geocoding precision:
    • ROOFTOP indicates that the returned result reflects a precise geocode.
    • RANGE_INTERPOLATED indicates that the returned result reflects an approximation (usually on a road) interpolated between two precise points (such as intersections). Interpolated results are generally returned when rooftop geocodes are unavailable for a street address.
    • GEOMETRIC_CENTER indicates that the returned result is the geometric center of a result such as a polyline (for example, a street) or polygon (region).
    • APPROXIMATE indicates that the returned result is approximate.
  • Though the template presents a handy structure, all fields are fed "as one" to Google Maps api. Providing your input differently - though not recommended - will usually still work, as long as all data is in, even if two inputs are fed into a single field (see 3rd line in sample below, with both state and postal code sitting in field postal code) or field sequence is changed (4th line). All 4 lines below - sitting in a single file - will result in the same ROOFTOP geocodes.
    1;Mountain View;94043;1600 Amphitheatre Parkway;US;CA;;;;
    2;Mountain View;94043;1600 Amphitheatre Parkway;US;California;;;;
    3;Mountain View;CA 94043;1600 Amphitheatre Parkway;US;;;;
    4;CA 94043;Mountain View;US;1600 Amphitheatre Parkway;;;;
  • To force Google Maps api to search only within specified oountry, enter that country as two letter ISO 3166-1 code from the list on ISO 3166-1. In this case, make sure that you enter country code really into field Country (stick to Excel template). In general, such specific country forcing is not necessary at all! Besides, you can always double check afterwards if the country within full address output matches input country.
  • You can copy the results file directly into Map Maker to create a map for free (with the option to highlight those locations that got ROOFTOP precision). See also working example in Map Maker itself.

Invoice data form

  optional
  optional
USD
 %
USD

Upon payment, the invoice and results file will be sent to you by e-mail within a couple of minutes (dependent on batch size).