How to get the latitude and longitude of an address in excel?

D

Dima Samsonov2019-11-18 10:24:45

Macros

Dima Samsonov, 2019-11-18 10:24:45

I have an excel sheet with an address column (20k addresses). These addresses require latitude and longitude.
How to populate the next column "Latitude" and the second next column "Longitude"?
Is there a useful tool now?
any suggestion?

Reply

Answer the question

In order to leave comments, you need to log in

3 answer(s)

C

coderisimo, 2019-11-18
@coderisimo

There is such a solution https://www.adventuresincre.com/auto-populate-lati... , but there is a limit for free requests of 2500 per day. So you can handle the tail in a week (well, or look at the prices).

B

BasiC2k, 2019-11-18
@BasiC2k

If you send a GET request to the Yandex website like this:
https://yandex.ru/maps/?text=moskva%2C%20Turgeneva...
(address: Moskva, Turgeneva, 15),
then a redirect will occur to the address containing the coordinates:
https: //yandex.ru/maps/213/moscow/?ll=37.595820%2C...
where they can be selected and saved.
It remains to figure out how to work with GET requests in Excel.