Maintenance
The Excel fleet maintenance template (and when it stops working)
A well-built spreadsheet beats a badly implemented system. Here are the columns that make it useful, the formula that keeps it alive, and the signals that your fleet has moved past it.
· 6 min read · Maintenance
Start with one sheet, not five
The classic mistake is one tab per vehicle. At fifteen vehicles nobody reviews them all, and there is no way to answer what is due this week without opening the same file fifteen times.
The structure that works is a single sheet where each row is a service item, pending or done, not a vehicle. The plate repeats, and that is the point: repetition is what lets you filter, sort by date and see the whole week at once.
The minimum columns
With less than this you cannot compute anything. With much more, nobody fills it in.
- Plate
- Service type (oil, brakes, tires, insurance, roadworthiness test)
- Trigger: target mileage or target date
- Current mileage and the date of that reading
- Status: pending, scheduled, done
- Owner (a person, not a department)
- Shop or supplier
- Actual cost
- Completion date and closing mileage
The only formula you need
A computed days-remaining column, with conditional formatting in red under 15 days and amber under 30. Nothing more sophisticated: that is what turns a dead list into a dashboard.
For mileage intervals the equivalent column is kilometers remaining, target minus current reading. The formula is not the problem; the current reading is, because it ages. If the number is three weeks old, the traffic light lies.
Always sort ascending by days remaining. What sits at the top is this week, and what is red already slipped and needs an explanation.
Signs you have outgrown it
When nobody has updated mileage in three months, when two versions of the file are circulating over WhatsApp, or when you found an expired insurance policy because a traffic officer stopped the vehicle and not because the sheet told you.
Also when the team grew: two or three people editing the same shared file end up overwriting each other, and the good copy is always on somebody else machine.
Migrating for fashion is a waste. Migrate when the cost of the deadlines you miss exceeds what the tool costs, which in a mid-size fleet is usually one late-payment fine per month.
Frequently asked questions
Where can I get a fleet maintenance template in Excel?
There are plenty of free ones, but almost all are laid out per vehicle instead of per service item, which is exactly what makes them useless past fifteen plates. Building your own with the columns above is faster than adapting someone else layout.
Is Google Sheets better than Excel for this?
For a fleet, yes, for one simple reason: several people edit the same version and there is a change history. It still does not warn anyone by itself, although a notification script can be attached if somebody on the team maintains it.
How many vehicles can a spreadsheet handle?
In practice, as many as one person can review every week without missing anything. In urban fleets with many recurring deadlines that usually breaks somewhere between 20 and 40 vehicles.
Keep reading
Still running your fleet on spreadsheets?
Ruvi opens a closed pilot in Colombia. Leave your email and we will tell you when spots open.
Request early access →