RouteMetrics

Turn a column of addresses into a route plan — without leaving Excel.

RouteMetrics adds four custom functions to Excel that pull real HERE routing data straight into your cells. No copy-pasting between browser tabs, no macros, no scripts. Fill down a formula across thousands of address pairs and watch the distances arrive.

The formulas

- =ROUTE.DISTANCE(origin, destination, [mode], [unit]) — real road distance between two locations, in miles or kilometers. Not as-the-crow-flies — the actual route.

- =ROUTE.TIME(origin, destination, [mode], [departure_time]) — trip duration in minutes. Pass a future departure time to get traffic-aware drive times or transit schedules.

- =ROUTE.DIRECTIONS(origin, destination, [unit], [mode], [departure_time]) — turn-by-turn directions as a spilled column, with the distance of each step. One formula, a full route plan.

- =ROUTE.URL(origin, destination, [mode]) — a clickable, sharable Google Maps link for the trip. Never consumes a search.

Every function works in four travel modes: driving (default), walking, bicycling, and transit.

Flexible inputs. Full addresses, city + state, coordinates, airport codes, or place names — if HERE can find it, RouteMetrics can route it.

Built for real workloads. Mileage and expense reports, delivery and service-call routing, sales territory planning, relocation comparisons, logistics quoting — anywhere a spreadsheet meets a map.

Sign in with the Microsoft account you already use. RouteMetrics authenticates with Microsoft single sign-on — no separate password to create or remember.

Try it free. Every account starts with a 7-day free trial — no payment details required. Paid plans add monthly search allowances sized from occasional reports to fleet-scale routing, plus one-time credit packs for bursts. ROUTE.URL is always free.

Built by a spreadsheet educator. RouteMetrics is made by Adam Steinfurth, the creator behind the Prolific Oaktree YouTube channel and SheetsHelp, and instructor of DataCamp's "Conditional Formatting in Google Sheets" course — the same practical, formula-first approach applied to routing.

Map data © HERE. HERE is a trademark of HERE Global B.V. Google and Google Maps are trademarks of Google LLC; ROUTE.URL returns a Google Maps link.