Hi,
I think, what you're looking is Geocoding. Unless you have some sort of street and streetnumbers data that you can use along with your Excel file, you can try Geocoding API from Google.
This Web Service will return you coordinates in JSON format that you can use later on.
You should give it a try (call it with HTTPCaller or similar transformers) and tell us your findings.
Cheers,
Zelimir
Did you have a look at the GeoCoder transformer in FME?
That seems to be the right way to do it.
Hi,
I think, what you're looking is Geocoding. Unless you have some sort of street and streetnumbers data that you can use along with your Excel file, you can try Geocoding API from Google.
This Web Service will return you coordinates in JSON format that you can use later on.
You should give it a try (call it with HTTPCaller or similar transformers) and tell us your findings.
Cheers,
Zelimir
Just a quick reminder: if you use the Google API for geocoding you can only use the results on a Google Map... I've used the
OpenCage geocoder myself, they have a reasonably good free tier and you can use the results any way you like.