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.
Available now on Microsoft AppSource. Free trial: 100 searches, no time limit.
Type a formula, get real routing data back — right in your sheet.
RouteMetrics
ROUTE.IFTA formula over your whole quarter — every jurisdiction, totalled.Everything you need to turn a column of addresses into a route plan.
ROUTE.DISTANCE
Real road distance between two addresses, not as-the-crow-flies — driving, walking, bicycling, or transit. Fills down across thousands of rows.
ROUTE.TIME
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
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
Get a sharable Google Maps URL for any A → B trip in any mode. Free — doesn't consume a search.
Truck-legal routing for your rig, per-state miles for IFTA, toll costs and legality checks — on the Trucking plan.
ROUTE.STATEMILES
Truck miles a trip drives in a given 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
Point it at your From and To columns and it spills a table of every jurisdiction you drove and the total miles in each — a quarter's IFTA mileage in one formula.
ROUTE.TOLLS
What the tolls actually cost, priced against your truck's weight and axle count — a number you can add straight into cost-per-mile.
ROUTE.RESTRICTIONS
“OK”, or what the only available route violates — a low bridge, a posted weight limit, a hazmat prohibition. The mileage functions still return a number for a lane your rig can't legally run; this is what says so.
Gross weight, height, width, length, axles and any hazmat class go in the task pane and save into the workbook, so every truck formula in the file plans for the rig you actually run — not a generic truck. Individual rows can override it for an oversize or placarded load, and multi-stop lanes are counted through their pickups and drops, which matters for IFTA because a detour puts you in states the direct route never enters.
Most ways of getting road distances into Excel ask you to become a Google Cloud customer first. This one doesn’t.
No Google Cloud project, no API key to generate, no credit card on file with a mapping provider. Install from Microsoft AppSource, sign in with your Microsoft account, and type a formula. If a tool needs a screen-share to get working, that setup cost is real.
Pay once for the tool and again per lookup to Google, and your real cost depends on a meter you have to watch. RouteMetrics is a single price with the routing included, and a hard cap on our side so a runaway fill can’t produce a surprise invoice.
This is a sandboxed Office add-in, not a macro-enabled workbook. Nothing asks you to click “Enable Content”. That matters practically: Office blocks VBA macros from downloaded files by default, plenty of IT departments block them outright, and a macro workbook simply cannot run in Excel for the web.
Windows, Mac, and the browser — same formulas, same account, same searches. Because there are no macros, the web version isn’t a cut-down copy; it’s the same add-in.
=ROUTE.DISTANCE(A2,B2) is a formula like any other. It fills down, it
recalculates, it works inside IF and SUM. You aren’t
pressing a button and waiting for a batch to finish.
100 free searches to start, with no time limit. Then a monthly plan, or one-time credit packs that never expire if your work is seasonal — a quarterly IFTA filing shouldn’t need a year-round subscription.
Cell values persist when you reopen the workbook. No surprise API charges from re-calculating yesterday's spreadsheet.
Single sign-on with your existing M365 account. No new passwords. Works on Excel for Mac, Windows, and the web.
Clear monthly quotas, top-up packs that never expire, self-serve cancellation. Billing handled by Stripe.
Powered by HERE · Payments via Stripe · Microsoft sign-in
Two subscription tiers plus a one-time credit pack for occasional users.