The Scenario
A courier company dispatcher has an Excel workbook open with eight delivery stop addresses in column A, in the order the driver should visit them. The driver needs a briefing sheet in 30 minutes. The dispatcher needs turn-by-turn directions, total distance, and total travel time — not a screenshot from Google Maps, but something that can go into the standard briefing template.
The bad version:
- Paste all eight addresses into a routing tool, get the route summary, try to copy the step-by-step instructions.
- The routing tool's export options are "Print" and "Share Link." Neither gives you editable text you can paste into the Excel briefing template.
- Start typing the steps from the screen into the workbook manually. There are 34 steps. The briefing is in 30 minutes and there are three other routes to prepare.
The standard briefing template exists precisely so drivers don't get verbal directions. But filling it manually defeats the point.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook. It reads the stop column, calls Radar's routing API with the addresses in order, and writes the step-by-step instructions and summary figures into the workbook — briefing-ready.
Fetch Radar directions for the route through all stops in column A of this Excel workbook and write each leg's distance and duration into columns B and C, then add a total row at the bottom
What You Get
- Each routing step or leg written into the workbook in sequence
- Column B: distance for each leg in kilometers
- Column C: duration for each leg in minutes
- A total row at the bottom showing overall distance and time for the complete route
What If the Data Is Not Quite Ready
Some stops are marked as optional depending on delivery confirmation
Get Radar car route directions for all stops in column A where column B is marked "Confirmed" — write leg distance (km) and duration (min) to columns C and D, then add a total row at the bottom
The stops have inconsistent address formatting
For each stop in column A: standardize the address format (street number first, city and state separated by comma), then call Radar routing for all stops in order and write leg distance and duration to columns B and C with a total row at the bottom
You need step-by-step turn instructions rather than per-leg summaries
Using the stops in column A in order, call Radar for turn-by-turn car route directions and write each individual instruction step to column B — add the total route distance (km) and total duration (min) as a summary at the bottom
Clean stops, get directions, and format a driver-ready summary in one pass
For the stops in column A: fix any formatting issues, call Radar car routing in stop order, write each leg distance (km) to column B and each leg duration (min) to column C, and add a formatted summary section at the bottom showing total distance, total time, number of stops, and an estimated departure window based on a 9 AM start time
The departure window estimate saves the dispatcher a separate mental math step.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook with an ordered list of delivery stops — ask it to fetch Radar directions and write leg distances, durations, and totals directly into the workbook. For a full travel-time matrix across multiple origins and destinations, see building a driving-time matrix, or return to the Radar integration overview.