I need to somehow convert google maps link into geographical coordinates( longitude, latitude). Like in one column I have the link and in other two must be the coordinates.
1
-
Welcome to Web Applications Stack Exchange. See How do I ask a good question?– doubleunaryJun 19, 2022 at 21:15
Add a comment
|
1 Answer
If column A contains the links (starting at A2), you will get the two values (lat & lng) into two separate columns using this formula:
=Index(if(A2:A<>"",Split(regexextract(A2:A,"@([^,]*,[^,]*)"),","),))
-
What if the links do not contain the lat/lon already in the url string? For example: maps.app.goo.gl/DYZim92V68RLKQ2Y9 -- is there a google sheets formula or API call we can make to return lat/lon? Nov 9 at 16:42