Skip to content

Create a distance matrix in Excel in seconds

Calculate driving distance or travel time between dozens or hundreds of locations at once, using Google Maps data, without leaving Excel.

  • No coding required
  • Real driving data from Google Maps
  • One-time purchase

See how it works in 2 minutes

Stop Calculating Distances One by One

A matrix does what hours of manual lookups can’t.

SAVE TIME

10 Locations, 100 Distances, One Click

What used to take hours of copy-pasting from Google Maps is done in seconds. The matrix calculates every combination for you.

SPOT PATTERNS

See Which Locations Are Closest at a Glance

The built-in heatmap turns your matrix into a visual map. Green for short, red for long. Make decisions faster.

ONE-TIME PRICE

One Price, Yours Forever

$69 one-time payment. No subscriptions, no monthly fees. Google includes 10,000 free calculations per month. Updates are free for life.

How it Works

Three steps from addresses to distances. No formulas, no scripting.

  • 1

    Enter Your Locations

    Type or paste your locations into a single list. The matrix handles all pairs automatically.

  • 2

    Click Calculate

    Choose your travel mode, hit calculate, and let Google Maps process every combination at once.

  • 3

    Get Your Matrix

    An N x N grid of distances and travel times appears in Excel. Toggle the heatmap to spot patterns instantly.

Who Uses the Distance Calculator

From logistics to real estate, sales to research.

Supply Chain & Warehousing

Warehouse-to-store distance analysis

Fleet & Logistics Managers

Multi-stop route optimization

Urban Planning & GIS

Accessibility and coverage studies

Retail & Franchise Operations

Store proximity and territory mapping

Event & Venue Planning

Venue comparison, attendee travel distances

Real Estate & Property

Property-to-property and amenity proximity

Manual Lookups vs. Distance Matrix Calculator

See how the numbers scale when you need every combination.

Criteria
Manual Google Maps
Matrix Calculator
10 locations (90 pairs)
~3 hours of copy-paste
~15 seconds
50 locations (2,450 pairs)
Days of manual work
~2 minutes
Heatmap visualization
Not available
One-click toggle
Travel time
Look up separately
Included in every cell
Error rate
Typos, missed pairs
Google Maps accuracy
Output format
Screenshots and notes
Clean N x N Excel grid
Cost
Your time
$69 one-time

FULL DISTANCE MATRIX

See every location compared at once

Calculate driving distance or travel time between all locations in one run. The full matrix appears directly in Excel, so you instantly see which places are closest or farthest.

FULL DISTANCE MATRIX

See every location compared at once

Calculate driving distance or travel time between all locations in one run. The full matrix appears directly in Excel, so you instantly see which places are closest or farthest.

CALCULATION CONTROL

Choose how distances are calculated

Select travel mode, units, and traffic behavior before you run the calculation. Measure driving, walking, cycling, or public transport, with or without traffic, in miles or kilometers.

Excel Distance Matrix Calculator Settings

HEATMAP VIEW

Spot distance patterns instantly

Turn on the heatmap to see distance and travel time patterns at a glance. Close locations stand out immediately, while long trips are impossible to miss.

HEATMAP VIEW

Spot distance patterns instantly

Turn on the heatmap to see distance and travel time patterns at a glance. Close locations stand out immediately, while long trips are impossible to miss.

FLEXIBLE INPUT

Work with the locations you already have

Use (incomplete) addresses, postal codes, landmarks, or coordinates. No reformatting needed. Paste your data and calculate.

Excel_Distance_Matrix_Calculator_Input_Format
Excel Distance Calculator Powered By Google Maps

RELIABLE RESULTS

Powered by Google Maps

Get accurate distance and travel time data every time. The calculator connects directly to the Google Maps API, so your results reflect real roads and real driving conditions.

Excel Distance Calculator Powered By Google Maps

RELIABLE RESULTS

Powered By Google Maps

Get accurate distance and travel time data every time. The calculator connects directly to the Google Maps API, so your results reflect real roads and real driving conditions.

Honest Feedback from Real Users

Simple, One-Time Pricing

One flat price in USD. No subscriptions. 14-day money-back guarantee.

$69

one-time payment

Lifetime access

✔ 10,000 free Google Maps lookups/month
✔ Full N x N distance matrix
✔ Built-in heatmap visualization
✔ 4 travel modes: drive, walk, cycle, transit
✔ Works worldwide, any address format
Get Started

Frequently Asked Questions

Everything you need to know before getting started.

Questions? Get in Touch.

If the FAQs missed a spot, I’m here to help. Ask away and get the answers you need, straight from the source!

Sven Bosau
Sven Bosau
Excel Distiance Matrix Calculator | General Contact Form

Stop Looking Up Distances One at a Time

Calculate driving distance or travel time between all your locations, directly in Excel.

Hi 👋