Convert Longitude/Latitude to Address OR get data from web form

[markusbohu]

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

[macropod]

Presumably a macro could automate a web browser (one that supports automation) for this. On a PC, you'd do that with Internet Explorer. For an example of such automation, see: https://www.msofficeforums.com/excel...html#post94814

See also:
http://www.tushar-mehta.com/publish_...eocoding.shtml
http://www.aspsnippets.com/Articles/...oding-API.aspx

[markusbohu]

Right.
I'm using Macs exclusively right now, so I guess I'll look into Applescript. It's been a while since I've used that.

Thanks for the suggestion, macropod.