Distance between Zip Codes or Addresses in Excel

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 $49.97 - Google API Key/Business Version

This tool allows you to calculate distances between addresses using Google Maps API. The Google Maps API gives you every month 40,000 calculations free of charge. (which is included in a 200 dollar Credit you receive every month.

  • There is no fee to get the google api key.
  • No monthly fees.
  • Pay as you go for calculations in excess of 40 thousand calculations per month. 
  • $5 for every 1,000 calculations in excess of the 40k calculations every month. 
  • The credit will reset every month.

This tool allows the user to do up to  100,000 calculations every 24 hours using theAPI key. This file has complete instructions on how to set everything up with Google to allow this extra functionality.  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

How To USE Distance Between Zip Codes Calculator

  1. Paste Zip Codes or Addresses into first column
  2. Paste Zip Codes or Addresses into second column
  3. 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 100,000 calculations every 24 hours per IP address. If you need more than this, please contact me at the email below.  jobs@excelVBAmaster.com

Still have Questions? Email jobs@excelVBAmaster.com