Anyone who has planned a delivery round knows the moment the plan falls apart. You have twelve stops, each with a window, and the list looks fine until stop four, where the customer is only home between 10 and 11 and your route puts you there at 11:40. Now you are reordering stops in your head while the driver is already on the road.
The usual fix is a spreadsheet and a lot of guessing. Sort by window start, hope the geography cooperates, and find out at 3pm that it did not. A time window is a promise to a customer, and a route that ignores it turns into missed deliveries and a second trip tomorrow. The second trip costs more than the first one did, because now you are paying for the same road twice and the customer is annoyed before you even ring the bell.
I use a free tool for this now, the Delivery Stop Sequence Planner. You enter the stops with their time windows, and it gives you back an ordered route with arrival times for each stop, plus a flag on any stop that would run late. It is browser-based, no account, nothing to install. The flags are the part I actually rely on, because they tell me which stop is the problem before the driver leaves, not after.
A worked example with real stops
The tool has a built-in example, and it is worth running because it shows the exact mistake the list order makes. Press Load example and it fills in six stops whose windows overlap. They are deliberately listed out of order, the way a driver's list often arrives.
Riverside Clinic, window 08:00 to 09:00, 10 minutes of service. Harbour View Office, 08:30 to 09:00, 5 minutes. North Street Bakery, 09:00 to 10:00, 15 minutes. Maple Avenue Flats, 09:30 to 11:00, 20 minutes. Elm Grove House, 10:30 to 12:30, 25 minutes. Station Road Cafe, 11:00 to 12:00, 10 minutes.
In list order, the Harbour View Office would be visited fourth and arrive at 09:25, which is twenty-five minutes after its 08:30 to 09:00 window closed, so it lands LATE. Re-sequenced by window start, the same six stops all land on time. Riverside Clinic first, arriving 08:10, service 10 minutes, departing 08:20. Harbour View Office second, arriving 08:30, service 5, departing 08:35. North Street Bakery third, arriving 08:45, service 15, departing 09:00. Maple Avenue Flats fourth, arriving 09:10, service 20, departing 09:30. Elm Grove House fifth, arriving 09:40, service 25, departing 10:05. Station Road Cafe sixth, arriving 10:15, service 10, departing 10:25. Total route time is 145 minutes, finish time is 10:25, and late stops are zero.
The Harbour View Office is late in list order but on time once re-sequenced, and that contrast is the whole point of the tool. Nothing changed except the order. The stops are the same, the windows are the same, the travel is the same. The list was made for reading, not for routing, and sorting by time-window start puts the tightest windows first, before they close.
How the ordering actually works
Every stop gets an arrival time from its time window and the travel minutes before it. A stop is flagged LATE when the arrival falls after its window closes, so the problem stops stand out before the run starts. You set the route start time and the travel minutes between stops, and ten minutes is the default, applied between every pair of consecutive stops. The tool adds service minutes to every arrival and departure, so the finish time stays truthful.
The ordering rule is simple and it is always the same. Stops are ordered by time-window start, earliest first. If two windows start together, the one that ends earlier goes first. If both match, stops are ordered by name, so the result is always the same. Run the same list twice and you get the same sequence twice, which is what you want when the driver is reading it off a printed sheet.
Forgetting service minutes is the mistake I see most often, and it is the one that quietly breaks a plan. Travel is not the only cost. Ten minutes at each door across fifteen stops is two and a half hours of service time, and a plan that ignores it will promise a finish time it cannot keep. Enter the minutes honestly and the planner counts them, so the finish time is a time you can actually meet.
Paste a list instead of typing rows
If your stops already live in a list, use the paste box above the rows. One stop per line with the name, window start, window end and service minutes if you have them, separated by commas or tabs. A name can contain commas, times work as 09:00 or 9:00 AM, and up to 500 stops can be built at once. Bad lines are skipped with a note instead of breaking the plan, so a typo in one row does not cost you the other forty-nine.
Once the sequence is planned, the Download CSV button in the results saves the whole table, sequence, windows, arrivals, service, departures and status, as a file you can open in a spreadsheet. Copy the result or print it and hand it to the driver. Rows below stay unlimited, so a long round is no problem.
Picture a small bakery doing Saturday deliveries. Eight orders, windows like 9 to 10, 10:30 to 11:30, and one awkward 8 to 9 on the other side of town. Type them in, get the sequence, and you can see straight away that the 8 to 9 has to go first or it goes late. Move it, re-check, and the whole round fits. That is a five-minute job with the tool and a forty-minute argument with a spreadsheet without it.
It works the same for a courier with twenty drops, a florist on Valentine's week, or a technician visiting clients who each gave a two-hour slot. The input is simple, stops and windows, and the output is a route you can hand to someone and trust. Arrival times matter because they let the driver call ahead when a stop is tight, instead of turning up to a locked door.
What it is not, and why that is fine
This tool does not optimise a route or draw one on a map. It takes the stops you already have and puts them in the best order for their time windows, with arrival times and late flags, so you can see whether the day's plan works. It never asks for your location, it only needs the times you type in, and everything runs in your browser with nothing sent anywhere.
I like that honesty. A map would be nice, but a map is not what breaks a delivery day. What breaks it is a window that closed twenty-five minutes before you arrived, and a plan that never told you. Fix the order first. The map can wait.
Questions I get asked
How are my stops ordered? By time-window start, earliest first. If two windows start together, the one that ends earlier goes first. If both match, stops are ordered by name, so the result is always the same.
What does LATE mean? It means you would arrive after the stop's window end. The planner marks the stop LATE and adds a note saying its window had already passed at your arrival time, so you can phone ahead or re-plan.
Can I paste a list of stops instead of typing them one by one? Yes. Paste the list with each stop's time window and the planner reads it in one go, then orders the stops and shows the arrival time and late flag for each. Bad lines are skipped with a note instead of breaking the plan.
Route planning is not really about maps. It is about keeping promises in the right order. When the windows drive the sequence instead of the other way round, the day runs smoother and fewer customers get the sorry we missed you note. Try it on your next round.
Top comments (0)