Getting Country from Latitude & Longitude co-ordinates in Excel

[nad5raf]

I have a list of co-ordinates which I want to automate somehow to get the Country the co-ordinates are pointing to.

I am not an Excel guru so some guidance will be greatly appreciated.
I have quite a few of these to do and will require accurate output.

Thanks you

 

[Toadstool]

Hi Nad5raf,

Countries are not a uniform shape so there's no longitude/latitude range you can use to calculate a country. Also some countries are small (Monaco and Vatican countries are each smaller than a square mile) so a map would be needed for accuracy.

I'm sure there's some Excel Addins or APIs which can be used to retrieve the country for co-ordinates so we can see whether other forum members have that experience.

You don't say how many is "quite a few" but you can probably estimate using some internet data. For example, this site has over 15,000 world city co-ordinates which may help:
World Cities Database | Simplemaps.com

 

[SteveOranjinSteve]

You're probably better off using Python for that. There is some very simple stuff, that's very easy to do. There are some tutorials online that'll talk you right through it.