Free Batch Geocoder retrieves latitude/longitude of adresses. It is based on OpenStreetMap API. OSM does not return geocodes if your input is incorrect (e.g. city misspelled), as it lacks a closest-match algorithm. Alternatives are presented at the end of this page.
Enter fields semicolon or tab separated (copy from Excel file, or import template).
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 had not set your postal code column to type "text". Incorrect postal codes will cause geocoding problems.
None of the address fields is obligatory as such. You may enter country and postal code only, or country and city only. However, the more valid address data entered, the more precise geocodes can become. But also note that if a city or street name is misspelled and does not match underlying OSM database, then OSM does not return geocodes (and it would have been better to leave out such misspelled name).
To save results manually: go to the output text area (above) and select all data (CTRL-A), then copy (CTRL-C) and paste (CTRL-V) into e.g. your MS Excel file.
To geocode another batch: refresh page (F5) after saving your results first!
Alternatives
Geonames.org file (free)
Download geocode files from www.geonames.org (1 per country, 1 for world) , import data into Excel, and XLOOKUP latitudes/longitudes.
Census Geocoder (free)
US governmental web app Census geocoder geocodes addresses that are within the United States, Puerto Rico, and the U.S. Island Areas.
Excel interfaces (free) with geocoding service providers (free up to some amount, requiring a user key)
There are many geocoding service providers. Stelling Consulting offers free Excel interfaces to 3 of them. They all offer closest-match "spelling correction", hence the "hit rate" becomes almost 100%, whereas OSM's "hit rate" can be considerably lower.
Download Excel Batch Geocoder - Google Maps
(50kB - downloaded 955 times, developed by Stelling Consulting, 2022‑02‑16, use at own risk).
You will need to create your own Google Maps key (not that easily done, compared to other providers below) to run it. Free to use, up to some amount. After that, you will need to pay Google Maps.
Download Excel Batch Geocoder - TomTom
(53kB - downloaded 853 times, developed by Stelling Consulting, 2022‑02‑18, use at own risk).
You will need to create your own TomTom key (easily done) to run it. Free to use, up to some amount. After that, you will need to pay TomTom which is less expensive than Google Maps or some other geocoding providers.
Download Excel Batch Geocoder - BING (developed by a 3rd party, use at own risk).
You will need to create your own Microsoft Bing key (easily done) to run it. If you qualify for free use, then the Basic key offers limited free use, else you need to setup an Enterprise key.
Online batch geocoder (paid by credit card)
If you do not want to spend time setting up a Google Maps/TomTom/Bing account to make an Excel interface work, then you can use online Batch Geocoder that has been developed by Stelling Consulting and is based on the superior Google Maps API.
