Driving distance and time in your Excel formulas.

Drop =ROUTE.DISTANCE("Boston, MA", "New York, NY") into any cell and get the real driving miles back. Same for drive time and turn-by-turn directions — by car, on foot, by bike, or by transit, in miles or kilometers. Powered by HERE.

Get it on Microsoft AppSource See pricing Open Help

Available now on Microsoft AppSource. Free trial: 100 searches, no time limit.

See it in action

Type a formula, get real routing data back — right in your sheet.

ROUTE.DISTANCE returning driving miles for a column of addresses in Excel — Driving distance between any two addresses, filled down a whole column.

Excel showing the ROUTE.TIME autocomplete tooltip and its arguments — Smart autocomplete guides every argument as you type.

ROUTE.DIRECTIONS spilling turn-by-turn driving steps down a column — Full turn-by-turn directions, spilled down the sheet from one cell.

ROUTE.TIME comparing driving and transit travel times by departure time — Traffic-aware drive times and transit schedules, by departure time.

RouteMetrics task pane showing account, subscription, buy searches, and monthly usage — Manage your plan and track usage in the sidebar.

Four formulas, one workbook

Everything you need to turn a column of addresses into a route plan.

ROUTE.DISTANCE

Trip distance, miles or km

Real road distance between two addresses, not as-the-crow-flies — driving, walking, bicycling, or transit. Fills down across thousands of rows.

ROUTE.TIME

Trip duration in minutes

How long it actually takes to get there. Pass a departure time for traffic-aware drive times and transit schedules. Great for delivery routes, mileage reports, territory planning.

ROUTE.DIRECTIONS

Turn-by-turn steps

A spilled column of instructions with per-step distances, in any travel mode. One cell, fills the rows below with each step of the route.

ROUTE.URL

Clickable Google Maps link

Get a sharable Google Maps URL for any A → B trip in any mode. Free — doesn't consume a search.

Built for fleets, ops teams, and anyone running mileage reports

Survives reopening

Cell values persist when you reopen the workbook. No surprise API charges from re-calculating yesterday's spreadsheet.

Server-side cached

Common routes are cached for up to 30 days, so repeat lookups come back instantly.

Microsoft sign-in

Single sign-on with your existing M365 account. No new passwords. Works on Excel for Mac, Windows, and the web.

Real billing, no surprises

Clear monthly quotas, top-up packs that never expire, self-serve cancellation. Billing handled by Stripe.

Who built this

RouteMetrics is built and published by Adam Steinfurth, the spreadsheet educator behind Prolific Oaktree on YouTube and SheetsHelp, and the instructor of DataCamp's Conditional Formatting in Google Sheets course.

He's spent years teaching people to get more out of Excel and Google Sheets. RouteMetrics is that same practical, formula-first approach applied to routing — real road distances, drive times, and directions, right where your data already lives.