How to Build a Distance Matrix in Excel in 4 Steps
1:02 · Published November 16, 2026
In this video
About this video
Get every distance between two lists of locations in Excel, with no formulas. The CDXGeoStream Distance matrix tool reads two columns and writes the full grid to a new worksheet.
What you get
- A grid on a new worksheet: List A down the side, List B across the top. Driving adds a second grid for drive time.
- Street addresses or ZIP codes in either list
- Straight-line distance in miles, kilometers or nautical miles, or driving distance and drive time in miles or kilometers
- The rate is shown before you build, and a large grid shows its exact total for you to confirm






