Turn a list of origins and a list of destinations into a full distance or travel-time matrix.

Enter your origins down one axis and your destinations across the other. Route Matrix fills in every pairing — real road distance or real drive time, not straight-line estimates — in one pass.

WHAT YOU GET

• A complete matrix of every origin against every destination
• Distance or travel time, your choice
• Conditional formatting that highlights the optimal location automatically — so the facility, hub, or meeting point that minimises total travel across all routes is visible at a glance, without you scanning the grid

PERFECT FOR
✓ Facility and warehouse siting — which candidate location is closest to everyone it serves
✓ Meeting and venue selection — the spot with the least total travel for all attendees
✓ Territory and route planning — drive times across a whole service area at once
✓ Logistics and dispatch — compare depots, hubs, and cross-dock options
✓ Real estate and site selection — proximity scoring across a shortlist
✓ Anyone who has ever checked twenty routes by hand in Google Maps™

LOCATION FORMATS

If Google Maps™ can interpret it, Route Matrix can route it:

• Street address
• Latitude / longitude (snaps to the nearest road)
• Plus Code
• City, country, or other political boundary
• Point of interest
• Airport
• Park

PRICING

Basic usage is free. Searches of up to 9 simultaneous routes cost nothing. Larger searches use a faster API and cost $7 per 1,000.

Questions? Visit sheetshelp.com/contact

—
Google Sheets™ and Google Maps™ are trademarks of Google LLC. Route Matrix is an independent add-on and is not endorsed by or affiliated with Google LLC.