Excel Matrix Driving Distance Calculator

The Excel Matrix Driving Distance Calculator brings the Google Maps Driving results directly into your Excel Spreadsheet. It allows the user to generate Driving Distances in a Matrix Format directly in Excel. It will save you hours of looking individual trips one by one into Google Maps.  With a click of a button it will generate the distances of all the intersections of addresses or zip codes. 

Check out the video on how the Excel Matrix Driving Distance Calculator  works:

Who is the Matrix Excel Distance Calculator for?

The Excel Distance Calculator is an excel based distance calculator that allows the user to generate all the different Driving Distances permutations  of a large list of addresses, zip codes, cities or geocodes. It allows the user to save tremendous amount of time by automating the generation of the driving distances for a large list of address combinations!

What is the Purpose of the Excel Matrix Distance Calculator for?

It allows the user to generate all the driving distances for 2 sets of addresses. By calculating all the possible permutations of the 2 sets of data it has the following benefits:

  • NO installation necessary. All you need is Excel in your desktop. 
  • NO programming know-how required. A spreadsheet with a "Calculate" button in it and you are on your way to automating the driving distance calculations!
  • NO monthly charges. Just a one time fee!
  • REAL help if you need it. If you have any questions, email, call or just talk to me on the chat on this site!

Get all your distance calculation needs directly into the excel spreadsheet, all with the click of a button. 

How Does It Work?

The Excel Matrix Driving Distance Calculator is the Easiest to use tool of its kind. You can get your Driving Distances directly in Excel in a Matrix format in one easy step. See below:

Enter the Addresses or Zip Codes in the first row and first column. 
Click Calculate. 

The Excel matrix Distance Calculator will generate the driving distances between the intersections of each address or zip code combination. 

Excel Matrix Driving Distance Calculator

Frequently Asked Questions (FAQs)

While the Excel Distance Calculator works on some version of Mac Computers, I currently do not offer support for MACs. As Macs use different VBA libraries, that can cause some conflicts with some of the functions in this tool.

You will need a Google Maps API to use this tool!

All of our tools use the Google Maps API to generate results. This allows for accurate driving distance and time results and fast data. I have included some instructions on how to get a google maps API and what services to enable. Click here for more information on how to setup the Google Maps API Key.  

A few more things regarding the Google Maps API Key. 

You don't need to be a developer to setup a google maps api key. It takes about 5 minutes, and it is a simple as setting up an account with Google. 

  • The Google Maps API Key is free to setup. It doesn't cost anything. 
  • You will get up to 40,000 calculations free of charge. (Google allows for a 200 dollar credit for every calendar month). 
  • If you need more than 40,000 calculations in a calendar month, google charges an a-la-carte fee of 5 USD/1000 calculations. 
  • For most of my clients that use this tool, 40,000 calculations are more than enough. 
  • You will need to setup a billing account with Google, although you will not be charged unless you go over the 40,000 calculations per month. 
  • If you have a large number of calculations, (more than 40,000) contact me.  I might be able to help. 

Excel Matrix Driving Distance Calculator