Calculating trip distance using Excel spreadsheet

[doxadevelopment]

Dear all,

I am having trouble with adding a formula in the Excel cell for calculating the trip distance between two destinations. Does it have to link to Google map?

Thank you.

 

[Michael M]

Have a reaad here for plenty of info for trip distances.....

Calculate travel time and distance between two addresses using Excel + Maps API

Ever wanted to calculate distance using Excel? Use Google Maps or Bing Maps API in Excel WEBSERVICE() to get distance & travel time between two addresses.

chandoo.org

 

[Cubist]

I answered a similar question today. See post#12 in this thread using GoogleMaps API.

Calculate distance between 2 postcode

Hi, Is it possible to do this in excel? I have a single column of customer postcodes. I wish to compare this column to the same source/origin postcode each time. So one of the lookup postcodes is the same each time. Any help much appreciated. Thanks Gareth

www.mrexcel.com

Example:

Book1
	A	B	C	D	E
1	Origin	Destination	Distance	Duration
2	Dallas, Texas	Irving, California	2,287 km	20 hours 38 mins
3	RG8 7JF	WA7 5PS	299 km	3 hours 17 mins
4	75094	94559	2,824 km	1 day 2 hours
5	Disney Land, Florida	Space Needle, Seattle	4,959 km	1 day 21 hours
6
Sheet1

Cell Formulas
Range	Formula
C2:C5	C2	=GetDistance(A2,B2)
D2:D5	D2	=GetDuration(A2,B2)

 

[doxadevelopment]

I answered a similar question today. See post#12 in this thread using GoogleMaps API.

Calculate distance between 2 postcode

Hi, Is it possible to do this in excel? I have a single column of customer postcodes. I wish to compare this column to the same source/origin postcode each time. So one of the lookup postcodes is the same each time. Any help much appreciated. Thanks Gareth

www.mrexcel.com

Example:

Book1
	A	B	C	D	E
1	Origin	Destination	Distance	Duration
2	Dallas, Texas	Irving, California	2,287 km	20 hours 38 mins
3	RG8 7JF	WA7 5PS	299 km	3 hours 17 mins
4	75094	94559	2,824 km	1 day 2 hours
5	Disney Land, Florida	Space Needle, Seattle	4,959 km	1 day 21 hours
6
Sheet1

Cell Formulas
Range	Formula
C2:C5	C2	=GetDistance(A2,B2)
D2:D5	D2	=GetDuration(A2,B2)

Hi Cubist,

Do I have to download Google API?

Thank you.

 

[Cubist]

Hi Cubist,

Do I have to download Google API?

Thank you.

You don't have to download it but must make an account. The free version is fine depending on your purpose. All you need is an API Key and replace that in the code provided in the other thread. See this link on how to get started.

Google Maps Platform Documentation | Distance Matrix API | Google for Developers

Google Maps Platform Documentation

developers.google.com

Set up your Google Cloud project | Distance Matrix API | Google for Developers

developers.google.com

 

[EX_CEL_C_MAP]

Hey, I tried the VBA just throws a value error. Would it need a JSON parser to go along?