Instead of Excel
Planning deliveries in Excel? Here is the same day in Routehive
Many delivery companies start with a spreadsheet: a sheet of addresses in Excel or Google Sheets, and a phone for the driver. For a while, that is enough. Here we compare the two task by task, and also say when switching is not worth it.
A delivery day, task by task
| Task | With a spreadsheet | With Routehive |
|---|---|---|
| The address list | With a spreadsheetIt lives in a spreadsheet, and you add to it by hand every morning. | With RoutehiveLoad the same sheet from Excel, CSV or Google Sheets: it recognises the address, name, phone, cash on delivery and crate columns on its own. Regular addresses are saved once as customers. |
| Stop order | With a spreadsheetWorked out in your head next to a map, and started again whenever a new address comes in. | With RoutehiveOrders the addresses on the real road network, up to 500 in one route. Locked stops stay where they are; the rest arrange around them. |
| Several drivers | With a spreadsheetYou split the addresses by hand and hope everything fits in the vans. | With RoutehiveSplits the day's addresses in one click by vehicle capacity, shift and delivery time windows. Whatever does not fit is listed separately. |
| Recurring routes | With a spreadsheetYou copy last week's sheet and change what is different. | With RoutehiveWeekly routes live as templates: they create themselves on the chosen days, as drafts, and never twice for the same day. |
| Sending the route to the driver | With a spreadsheetYou print it, or send a screenshot in a chat. | With RoutehiveThe driver gets it on their phone with nothing to install, and only ever sees the next stop. One tap opens Google Maps or Waze, one tap makes the call. |
| Where is the route at? | With a spreadsheetYou call the driver, if they are not behind the wheel. | With RoutehiveEvery stop closed shows up for the dispatcher straight away, with the time: what is done, what failed and, according to the driver, why. |
| Proof of delivery | With a spreadsheetA signed paper, if it makes it back to the office. | With RoutehiveUp to five photos per stop and the recipient's signature on the phone, with a name. The proof stays in the delivery log, with the time. |
| Cash on delivery and crates | With a spreadsheetThe driver writes it in a notebook, and you add it up in the evening. | With RoutehiveA stop with payment due can only be closed once payment is marked, and the driver records returned crates as a number. In the evening you see the cash per driver and the crates out per customer, with an Excel export. |
When is a spreadsheet enough, and when is it not?
Stay with the spreadsheet
- You have one driver who visits roughly the same addresses every day.
- You do not collect cash on delivery, and no crates come back.
- Nobody asks for proof of delivery.
It is worth switching
- You split addresses between two or more drivers.
- The addresses change daily, and working out the order takes a long time every morning.
- You collect cash on delivery, or bring back crates.
- Your customers ask for a photo or a signature as proof of delivery.
How to start
Sign up
Free, with no card and nothing to install: it all runs in the browser.
Load your current spreadsheet
It recognises the columns on its own. If in doubt, download the sample file when importing.
Send out your first route
Optimise it, add the driver, and they log in from their phone's browser. After the first day you will see what works differently from the spreadsheet.
Frequently asked questions
- Do I keep my Excel sheet?
- Yes. Routehive loads the same sheet, and at the end of the day it exports the delivery log and cash on delivery to Excel. The spreadsheet can stay your input and output; planning and delivery move into the app.
- Does the driver need to install anything?
- No. The driver app opens in the browser on Android and iPhone, and can be added to the home screen.
- How much does it cost?
- It is free to try. Paid plans are priced by the number of stops per month, not by drivers: you can add unlimited drivers, and every plan includes every feature.
All featuresA delivery day, step by stepCase study: a delivery company in numbersFree Excel template for your delivery address list
Plan tomorrow morning's routes this way
Sign up, add your drivers, load your addresses. Free for 15 stops in total, in 2 routes, no credit card.