Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
microwin88x
Creator III
Creator III

Get City for Latitude/Longitude

Hello,

I have a table (loaded from an XLS) with the following fields: CarNumber, Latitude and Longitude.

Is there any way to get the City/Country for every Latitude and Longitude?

I'd need to do this automatically because I have like 10.000 points.

Thanks!

Labels (1)
3 Replies
Kushal_Chawda
MVP
MVP

if you have city names then you can get the lat/long for the same

Google maps

microwin88x
Creator III
Creator III
Author

Hi,

Yes but the thing is that I don't have the City Names, only the Lat/Long...

marcus_malinow
Partner - Specialist III
Partner - Specialist III

You could try the GeoDesix plugin for Excel - GeodesiX

This allows you to construct Excel formulae to retrieve geo data from Google Maps. There's a limit of (I believe) 2500 requests per day though, and you may have issues with the latest version of Excel (unless he's fixed it recently).