Record_number | City | Postal_code | Street_name_and_number | Country | State | County/Province | Other_1 | Other_2 | Other_3 |
---|
- Enter fields semicolon or tab separated (copy-paste from Excel file, or import template). Limit a batch to 2,500 records.
- Do not enter table headers!
- Check your postal codes for leading zeroes. If - for example - you notice German or French postal codes with only 4 digits only in your data instead of 5, then there is a leading zero issue/missing. This issue is quickly caused in/by Excel if you have not set your postal code column to type "text". Only if both city name and postal code are entered, then Google Maps can automatically correct for missing leading zeroes in postal codes.
- None of the fields is obligatory and can be left empty, except for field Record_number. You may enter country and postal code only, or country and city only. However, the more valid address data entered, the more precise geocodes will become. Always enter 10 fields, even if left empty. Fields Other 1,2,3 can be used to add some free format address details.
- Though the Excel template presents a handy structure, providing your input differently will (usually) also work. See section "Example results file and more info".
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
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.