Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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:

share|improve this question
What is your question - how do you geocode 11,000 addresses for free for commercial use? – Mapperz Jun 11 '13 at 16:56
For Europe ViaMichelin is very good and stable for geocoding for free see Mapquest Open API – Mapperz Jun 11 '13 at 16:58
Yahoo Geocoding (Boss) Placefinder is $4 for 1000 geocodes [PlaceFinder=10,001 - 35,000 $4.00] so $44 in total. – Mapperz Jun 11 '13 at 17:01
@mapperz thnaks for pointing to the free Mapquest Open API, looks very useful – Kurt Jun 11 '13 at 17:22
possible duplicate of What reliable GeoCoding service would you recommend me? – RyanDalton Jun 11 '13 at 17:27

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

A few that stick out are:

share|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.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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