Calculate distance and travel time between places using Google Maps API in Excel
HTML-код
- Опубликовано: 13 сен 2024
- Here is something fun and useful. Ever wanted to calculate distance between points, travel time using Excel? See a demo of the technique and visit chandoo.org/wp... for more and sample workbook.
You ROCK! (Pro Tip: specifying "departure_time=now" in the URL allows you to use 'duration_in_traffic' for live conditions)
Sir , you are the best this works flawlessly !!!!
Hello Sir. I just wanted to thank you for your amazing work. This has truly helped me on a recent project at work. I wish I could thank you in person. Take care.
You are welcome Sed. :)
You Sir, are a legend. So helpful, thank you.
Amazing, been searching for something like this for a while
thanks Chandoo for sharing!
I have a 50 Point-to-Point locations that i would like to find out the Distances and Time; can you help me understand if i could do that in one go? Would like to know how.
Hi Chong... you can try the formulas in sample workbook and modify the structure to have point to point lookup in a table.
HI Chandoo, I find your video and excel template very helpful. I will need to get distance data for 9 million postalcode pairs. Do you have any idea how i can get an API that allow me to do that? Thanks.
Hi Chandoo,
I need to use the exact model that you provided here, but must also have a stopover (waypoint) between the origin and destination.
How can I please adjust the formulas to fit in a stopover in the middle?
Thanks.
Very helpful...thank you!
Thanks so much for such a wonderful tool. Now when Im using Excel in MAC the excel call to the web service doesn't work, is there way to make it work on a MAC? I tried on my windows VM and worked perfectly. But I normally use my MAC for all this stuff. Any help will be greatly appreciated. Thanks
Works fine but longitudes and latitudes are not displayed correctly. Which troubles me when using them in the second API. Distance is not included since the coordinates can not be solved. For example 37.56404 converts into 3756404. Does anybody know how to solve this. Tried almost any format there is, but there has to be a simple solution for this.
Hi Joris.. it might be something to do with your locale settings. I suggest testing the API from browser first to see if the lat / long is shown correctly.
Excelente! Gracias
Big thank you! That is all.
You're welcome!
Hi Chandoo!
I have a question for the geocoding;
How do I express the xpath to pick specifically the POSTAL CODE of the ?
I am not sure exactly. Try using xpath tester like www.xpathtester.com/xpath to see what xpath works.
Very very nice. Thank you.
how can i get the API key ? it s for free or not ?
Doesnt work pre 2013
Hello vous pouvez faire une vidéo avec powerquery ?
Thank you. Here it is - ruclips.net/video/PiFAa_jjaEI/видео.html
Google api limit ??
Yes. there are api limits for free users. If you are a paid user of Google Maps API, you will be just billed based on the request volume.
@@chandoo_ so is there any open source Library is r or python to do the same ...
From excel title, it literally says Bing Map API. But yeah
The video & file show both APIs. All the best.
Great, but not working . keeps having conflicts
with _xlfn.FILTERXML
That means your version of Excel doesn't have FILTERXML. It only works in new versions of Excel on PCs
Excel & Power BI Tuts from Chandoo thank you for your response
Used the key but it isn't working. Displays the following response when I click on the cell beside Request URL: Key just generated, can't be invalid.
{
"destination_addresses" : [],
"error_message" : "The provided API key is invalid.",
"origin_addresses" : [],
"rows" : [],
"status" : "REQUEST_DENIED"
}