Can you get distance between two GPS location points from Google maps or some other way in Excel?

[Paul B]

Using Excel 2003

I have a list of GPS data, Latitude in column I and Longitude in column J starting in row 3, if I put a Latitude and Longitude location in R1 and S1 is there anyway to get the miles between them to show up in column M? The date is in decimal format and example would be if I put 34.084317 in R1 and -83.729373 in S1 than with 34.68371778 in I3 and -83.70893544 in J3 M3 would show 55.6 miles, and fill in the miles in M for the rest of the data I have in columns I and J. If that can be done could the travel time also be put in another cell?

 

[mrshl9898]

Straight miles would be =ACOS(COS(RADIANS(90-R1))*COS(RADIANS(90-I1))+SIN(RADIANS(90-I1))*SIN(RADIANS(90-R1))*COS(RADIANS(J1-S1)))*3959

To get the driving distance you'll need to use the Google API and you will need a Key.

How to add Google API Key in VBA

I have an excel file that I am trying to build with Google Maps API so I can tell the distance between addresses. Due to limitations, I can only run a few rows at a time. I do have an API key, but ...

stackoverflow.com

Has some basic code.

 

[Paul B]

Thanks, I will take a look