RouteMetrics

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

RouteMetrics adds six 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.

For trucking and IFTA (requires the Trucking plan; free-trial accounts can try them within their trial allowance):

=ROUTE.STATEMILES(origin, destination, state, [mode]) — truck miles a trip drives in one state or province. Returns a single number, so you can put a column per state and fill it down your whole trip list.

=ROUTE.IFTA(origins, destinations, [mode]) — point it at your From and To columns and it returns every jurisdiction your trips crossed with the total miles in each. A quarter's mileage in one formula.

Travel modes: driving (default), walking, bicycling, transit, and truck — truck routing follows truck-legal roads, accounting for restrictions like low bridges and weight limits.

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, and IFTA fuel-tax prep — 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 100 free searches that never expire — no payment details required. Paid plans add monthly search allowances sized from occasional reports to fleet-scale routing, a Trucking plan for per-state mileage, and 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.

Per-state mileage is an estimate produced by truck routing, provided for planning and record-keeping. It is not a certified mileage source and may differ from mileage standards required by a jurisdiction, broker, or auditor.

Routing and map data © HERE Technologies. ROUTE.URL returns a Google Maps link.