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

Question

Macros

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?

Answer 1

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).

Answer 2

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.