What I have:

  • an Excel file with 11 thousand address (street + zip code + city)
  • all address are from Portugal
  • the address are not accurate (some address have the name street in a short way)

What I am looking for:

  • get "geocodes" (latitude/longitude) of all address.
  • using a opensource API, or a service of a website

What I will do with the data collected:

  • with the "geocodes" I will create a file like a KML file with all address and some others information about each address
  • the "geocodes" will be use in a commercial product by the company I am working.

In my research I have found some API and websites. But I am not sure if they suit my requirements

  • Google Maps API
    • I think it was a limit if 2500 requests per IP per day.
    • I think I can not collect the latitude/longitude, only show the location in a Google Map webpage
  • Yahoo PlaceFinder API
    • I think it is not free
  • website Gisgraphy
    • The results on my test are not good for Portugal address
  • website GPS Visualizer's Address Locator
    • uses Google and API Yahoo API, So have the same restrictions above

Some links I found:


I think you will find numerous answers to similar questions on our site by searching the geocode tag.

A few that stick out are:

| improve this answer | |
  • Good job with the recursive answer! Thanks for including some specific answers. – Jeffrey Jun 11 '13 at 18:20

Maybe this will also work for you: How to find coordinates for a lot of locations based on the town or village name?

The presented programme uses Nominatim (Open Street Map). I expect it to also work well with street names in most cases.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.