Plan Long-Distance EV Routes With Charging Stops From an Excel workbook

The Scenario

You're the fleet operations manager and you have 10 long-distance EV deliveries planned for next week. Each one has an origin, a destination, and a listed battery range — they're all in an Excel workbook. What you don't have yet is the route plan: which charging stations each vehicle should stop at, in what order, and what the estimated total journey time looks like with charging factored in. The drivers want that information before they leave. You need it before your planning call tomorrow morning.

The bad version:

• Open TomTom's EV route planner, enter the first origin and destination, set the battery parameters, step through the recommended charging stops, screenshot the result, and manually transcribe the stop names, addresses, and charging times into the workbook
• Do that for all 10 routes
• Realize trip 7 has a different vehicle battery spec so its parameters were wrong the whole time and you have to redo it

Your planning call is at 9 AM. There are 10 routes and you haven't started.

The Easy Way: One Prompt in SheetXAI

SheetXAI is an AI agent that lives inside your Excel workbook. It reads the origin-destination pairs and battery parameters, calls TomTom's long-distance EV routing endpoint for each trip, and writes the charging stop details and journey times back into the workbook.

Calculate the TomTom long-distance EV route for the trip from the origin in cell A1 to the destination in cell B1 with a full battery at the start. Write each recommended charging stop's name, address, and charging time into rows below.

What You Get

• One row per recommended charging stop
• Columns for station name, address, and estimated charging time in minutes
• Total journey time and stop count available if you include them in the prompt

What If the Data Is Not Quite Ready

Battery range varies by vehicle

For each row in this workbook, use the origin lat/lng in columns A and B, the destination lat/lng in columns C and D, and the battery range in km in column E to plan a TomTom long-distance EV route. Write the number of charging stops into column F and total journey time into column G.

Origin and destination are addresses, not coordinates

For each row in this workbook, geocode the origin address in column A and the destination address in column B using TomTom, then plan the long-distance EV route with a 300km battery range. Write the number of charging stops into column C and total journey time in hours and minutes into column D.

You want all 10 routes in one output

For each origin/destination lat/lng pair in columns A through D of this workbook, plan a long-distance EV route using TomTom with a battery range of 250km, and write the number of charging stops and total journey time into columns E and F

Full pre-trip brief for all 10 routes

For each trip in this workbook with origin lat/lng in columns A-B and destination lat/lng in columns C-D, plan the TomTom EV route assuming 250km battery range. Write stop count into column E, total journey time into column F, and the name and estimated charging time of each stop into columns G onward. Flag any route where TomTom recommends more than 3 charging stops in column H.

One prompt builds the complete trip brief for all 10 routes.

Try It

Get the 7-day free trial of SheetXAI and open the Excel workbook with your EV delivery routes, then ask it to plan each trip using TomTom. For checking real-time plug availability at the stations along the routes, see the EV charging availability spoke.