fixing the data for longitude and latitude

chinu267

Good Day.

Please look at the attched file. Is there a public library where I can download the latitude & longitude for the list of countries in the attached. file.

Some do not have a province and some have wrong GIS data.

For example Afghanistan information is below. I know technically 3rd one is correct. but if I can have a mapping table from any public data set, I can use Find & Replace to fix every record

Afghanistan
Afghanistan	33	65
Afghanistan	33.9391	67.71

DimProvinceCountry.xlsx

cgoodman

Hi @chinu267 

I would suggest taking a look at the Mapbox macros.

There is a free quota that you can use for search which hopefully will meet your requirements.

The macro you need is the one called "Mapbox Search".

Then you get results like this:

What's cool is there is in-built fuzzy matching just incase the Country names are mistyped.