Convert your adresses to GPS Coordinate

How to integrate the GPS Google API into your Excel formulae

[@njdmak]

this was amazing. thank you

[@jameschaplin2340]

This has been a great tool but I have a problem. When I carry put the function the latitude and longitude outputs are displayed as -338585403 and 1511166430 not as -33.4800462, 150.1389424 which is needed to plot it on a map. Its a large dataset so cannot do this manually. How can it be solved?

[@wotmate3719]

Have you solved this problem?

[@krcarlosm]

I might have solved it. It's not an "elegant way," but I get the coordinates as supposed to. I think the root cause is due to his own Excel configuration, which considers the "dot/point" as the decimal marker, while our Excel is configured to consider the "dot/point" as the thousand separator. In that case, we have three solutions: Find and Replace after calculation: change dot to comma. Change Excel's configuration to consider the "dot" as the decimal marker instead of the "comma." Use the "FIND TEXT" formula to extract the value after the delimiter "" or "." I'm using the third option, like this example: =FIND("", G2) where G2 is where my formula (webservice) is located, and I want the location where the first tag appears. Example of result: 1352 (after ... characters). Then, I add +5 to this result to ignore the "" characters. Finally, I use the "TEXT EXTRACTION" formula to get the 10 characters of the coordinates after this last result. The final formula is like this: =MID(G2, FIND("", G2) + 5, 10)

[@MultiHeos]

Hello, thank you for the very useful tool. When I test it in excel the dots between the coordinates are deleted by excel. If the coordinate is 4.36 after the filter.xml formula, excel indicate 436. Do you know how the keep these dots in the coordinates?

[@FredericLEGUEN-Excel]

Nope, never seen this issue. I can't help you

[@ccfarms8497]

When I ping the API I get the lat/long but when I do it on excel, it does not display. Any ideas why?

[@wotmate3719]

Have you solved this problem? I have the same

[@krcarlosm]

I might have solved it. It's not an "elegant way," but I get the coordinates as supposed to. I think the root cause is due to his own Excel configuration, which considers the "dot/point" as the decimal marker, while our Excel is configured to consider the "dot/point" as the thousand separator. In that case, we have three solutions: Find and Replace after calculation: change dot to comma. Change Excel's configuration to consider the "dot" as the decimal marker instead of the "comma." Use the "FIND TEXT" formula to extract the value after the delimiter "" or "." I'm using the third option, like this example: =FIND("", G2) where G2 is where my formula (webservice) is located, and I want the location where the first tag appears. Example of result: 1352 (after ... characters). Then, I add +5 to this result to ignore the "" characters. Finally, I use the "TEXT EXTRACTION" formula to get the 10 characters of the coordinates after this last result. The final formula is like this: =MID(G2, FIND("", G2) + 5, 10)

[@nortibynature]

i would give 3 thumbs up, if i could : - )