View Single Post
 
Old 11-18-2016, 10:55 AM
markusbohu markusbohu is offline Mac OS X Office for Mac 2011
Novice
 
Join Date: Nov 2016
Posts: 2
markusbohu is on a distinguished road
Lightbulb Convert Longitude/Latitude to Address OR get data from web form

Hi,
I have a spreadsheet that contains latitude and longitude fields for a person's location. I would like to convert this into an approximate address in another cell of the table.
There is a web form that can do this conversion at:
http://www.latlong.net/Show-Latitude-Longitude.html

Is anyone aware of a tool that allows me to automatically enter values from cells into this web form and then capture the result field from the form and put it into another cell in the same row?

Alternatively: Is there any other way I can bulk-convert latitude/longitude into addresses?

My sheet has over 2000 rows, so I do not want to do this manually.

Thanks,
Markus
Reply With Quote