This is a tool that allows you take multiple starting locations and multiple ending locations and quickly calculate the driving distance between the two.
Only $29.99 - Google Free API Version
This version allows 2,500 calculations every 24 hours from the same IP address.
If you would like to try it before you buy, I have created a free test version that you can test to confirm that it works on your machine. The link is here.
Only $50.00 - Google API Key/Business Version
This is the full business version that does 100,000 calculations every 24 hours using an API key. This file has complete instructions on how to set everything up with Google to allow this extra functionality. Google charges $0.50 for every 1,000 calculations over the free 2,500 limit. If you need any extra help setting this up feel free to email me.
For any questions or comments email me at jobs@excelVBAmaster.com
- Paste Zip Codes or Addresses into first column
- Paste Zip Codes or Addresses into second column
- Push Calculate.
Q: Will this work outside of the United States?
A: Yes, the input and output are the same as if you manually went to Google Maps and entered your locations and submitted them online
Q: Can I calculate the distance between exact addresses, not just Zip Codes?
A: Yes, the calculator can handle partial addresses as well as complete addresses. (Cities, States, Countries, etc.)
Q: Will this work on a Mac as well as a Windows Machine?
A: Yes, the calculator will work on recent versions of Excel for Mac as well as Windows.
Q: Are there any limitations?
A: Yes, driving distance is generated using Google Maps API which limits the results to 2,500 calculations every 24 hours per IP address. If you need more than this, use the Google API Key Version which is limited to 100,000 every 24 hours.
Still have Questions? Email jobs@excelVBAmaster.com