Excel Help Forum

Excel add-ins and Outlook plug-ins - AbleBits.com Excel VBA Calculate distance between two addresses or coordinates Ever wanted to calculate the distance between two addresses in Excel? I recently had the following issue: from a list of over approx. 50 administration offices across my city I wanted to find the one that is closest to my workplace. Of course open Google Maps and type each location one by one… and then choose the shortest connection. By why bother when we have Google Maps Distance Matrix API!!! Using the Google Maps Distance Matrix API Google has a lot of useful API out there and I encourage you to go sometime to the Google API Explorer and have a look at what other information you can easily utilize from Excel or your other applications. Let’s however focus on getting the distance between two addresses. The API is configured using GET HTTP Params. Google Distance Matrix Builder Want to quickly test the Google API? Google Maps Distance Matrix URL: Calculate distance between two addresses using Google Maps in Excel Get Google Maps distance in meters Get Google Maps duration (in seconds) Help!