Home / Help / Geocoder

Excel Tool for Geocoding

Geocode information (latitudes and longitudes) is optional when uploading data to Geolytics for less than 100 addresses. For more than 100, a Geolytics PRO subscription is required.

This is because geocoding is expensive. Google charges 5 USD for every 1000 geocoding requests.

We know an awesome Excel tool for obtaining latitudes and longitudes, which can be downloaded from excelgeocodingtool.com. You can also cloud_download download the tool directly here .

With this tool, you can geocode thousands of addresses in no time. Please do note that this tool and its developer are completely independent from Geolytics. We are not related in any way to the developer of the tool. We recommend it simply because we had great experience with it.

Here are the how-to steps:

  1. Follow the steps in this page to register a Bing Map key
  2. Download the Excel tool from here, open it and enable Marco. Is it safe? You might ask. We did it, and everything was OK.
  3. Fill in the Bing Map key you created at step 1.
  4. Provide a proxy if necessary. (Optional)
  5. Go to Geocode tab and put all the addresses you need to geocode in the Location column
  6. Click Geocode all addresses button to start geocoding. There is a progress bar indicating how far it has gone.
  7. Copy and paste the latitudes and longitudes information to Geolytics template for upload.

It took us less than 5 minutes to geocode close to 3000 locations as of June 2019. We hope this works for you too.

If you find steps above not managable, you are of course welcome to subscribe to Geolytics PRO and to enjoy hassel free location mapping and many other features that are only available under PRO plan.

You may also be interested to know

have questions?

Contact us

and we'll get back to you in 24 hours.

Cookies help us deliver our services. By using our services, you agree to our use of cookies. Learn more