Pasar al contenido principal
No se pierda lo que está por venir en Microsoft Ignite
No se pierda lo que está por venir en Microsoft IgniteAcceda directamente a las personas, los productos y los conocimientos que hacen posible la tecnología de Microsoft, con oportunidades para hacer preguntas, desarrollar aptitudes y aprender junto a la comunidad.
Microsoft
separator
https://catalogartifact.azureedge.net/publicartifacts/94818830.30528e84-8123-468f-a0ea-e205e396f8b3-10c26e6f-4616-436b-95e6-c55b7d0a96fd/image2_RMElogo300.png

RouteMetrics – Excel Route Planner & Distance Calculator

por Adam Steinfurth

Travel time for any trip, plus truck mileage by state for IFTA — generated right in your spreadsheet

Calculate driving distance and time for a list of addresses in Excel.

Put an origin and destination on each row, then fill down an Excel formula to get road miles or drive time for every trip. No mapping API key, macros, or scripts required. RouteMetrics adds eight Excel functions, including truck miles by state, toll estimates, and vehicle restriction checks.

The formulas

- =ROUTE.DISTANCE(origin, destination, [mode], [unit], [profile]) — estimated road distance between two locations, in miles or kilometers.

- =ROUTE.TIME(origin, destination, [mode], [departure_time], [profile]) — 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], [profile], [stops]) — 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], [profile], [stops]) — 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], [profile], [stops]) — 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.

- =ROUTE.TOLLS(origin, destination, [mode], [profile], [stops]) — estimated tolls for a lane, where pricing is available.

- =ROUTE.RESTRICTIONS(origin, destination, [mode], [profile], [stops]) — flags restrictions for the vehicle details supplied.

Travel modes: driving (default), walking, bicycling, transit, and truck — the truck profile supplies details for checks such as bridge clearances and posted weight limits. Confirm your vehicle's route before dispatch.

Flexible inputs. Use street addresses, cities and states, coordinates, airport codes, or place names.

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, tolls and restrictions, and one-time credit packs for standard routing. ROUTE.URL is always free.

Built by a spreadsheet educator. RouteMetrics is made by Adam Steinfurth, CPA, 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. The templates that touch money are built to the source documents: mileage worksheets follow the IRS business rate including split-rate years, and the IFTA quarterly worksheet mirrors the IFTA-101 fuel tax schedule item for item.

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.

Funcionalidades de la aplicación

Cuando se usa esta aplicación,
  • Puede leer el documento y hacer cambios
  • Puede enviar datos por Internet

De un vistazo

https://catalogartifact.azureedge.net/publicartifacts/94818830.30528e84-8123-468f-a0ea-e205e396f8b3-10c26e6f-4616-436b-95e6-c55b7d0a96fd/image0_RMScreenshot1.png
/staticstorage/20261108.1/assets/videoOverlay_62a424ca921ff733.png
https://catalogartifact.azureedge.net/publicartifacts/94818830.30528e84-8123-468f-a0ea-e205e396f8b3-10c26e6f-4616-436b-95e6-c55b7d0a96fd/image0_RMScreenshot1.png
https://catalogartifact.azureedge.net/publicartifacts/94818830.30528e84-8123-468f-a0ea-e205e396f8b3-10c26e6f-4616-436b-95e6-c55b7d0a96fd/image4_RMScreenshot2.png
https://catalogartifact.azureedge.net/publicartifacts/94818830.30528e84-8123-468f-a0ea-e205e396f8b3-10c26e6f-4616-436b-95e6-c55b7d0a96fd/image3_RMScreenshot3.png
https://catalogartifact.azureedge.net/publicartifacts/94818830.30528e84-8123-468f-a0ea-e205e396f8b3-10c26e6f-4616-436b-95e6-c55b7d0a96fd/image5_RMScreenshot4.png
https://catalogartifact.azureedge.net/publicartifacts/94818830.30528e84-8123-468f-a0ea-e205e396f8b3-10c26e6f-4616-436b-95e6-c55b7d0a96fd/image1_RMScreenshot5b.png
Español (Puerto Rico)
Icono de exclusión de opciones de privacidad Tus opciones de privacidad
Privacidad de la salud del consumidor Sitemap Contact Us Privacy & Cookies Terms of Use About our ads Manage cookies