Free Vehicle Inspection Checklist for Excel
A daily checklist the driver fills in before the first trip, plus the log and register behind it: a vehicle with a reported defect stays OUT OF SERVICE until the repair is entered, and services and annual inspections show OVERDUE or DUE SOON. Works in Microsoft Excel and Google Sheets.

What a vehicle inspection checklist covers
A daily vehicle inspection is the driver's check before the first trip: a walk-around with the engine off, a look under the hood, then the cab and controls with the engine running. For commercial vehicles the law requires it: the driver checks the vehicle is safe before driving, reported defects are repaired before it runs again, and each vehicle gets an annual inspection. Company cars and vans outside those rules follow the same routine because it is how flat tires and failed brakes get caught in the yard rather than on the road.
The Daily Checklist prints one sheet per vehicle per week, a column per day:
- Walk-around (engine off): tire inflation and tread, wheels and lug nuts, all lights, windshield and mirrors, wipers and washer fluid, body and load area, leaks under the vehicle.
- Engine bay: engine oil, coolant and brake fluid levels.
- Cab and controls (engine on): service and parking brakes, steering play, horn, seat belts, dashboard warning lights, the fire extinguisher, warning triangles and first-aid kit, and the documents on board.
A sheet records that someone looked; it cannot keep a van with a worn tire in the yard tomorrow. So the workbook keeps the record behind it:
Inspection Log. One row per defect report, service, annual inspection or repair, with PASS or FAIL. A FAIL stays an OPEN DEFECT until the repair date is entered.
Vehicle Register. One row per vehicle, with type, location, make and model and plate. It reads the log, shows OUT OF SERVICE while a defect is open, and runs two clocks: the service interval per type from the Vehicle Types tab (six months for cars and pickups, four for cargo vans, three for box trucks and tractors, all editable) and the 12-month annual inspection, which also counts as a service. Status reads OVERDUE when either clock runs out, DUE SOON two weeks before a service or a month before the annual, and IN SERVICE otherwise.
For trailers, use the trailer inspection checklist; the maintenance log template keeps the full service history of each vehicle.
Who uses a vehicle inspection checklist
Drivers do the daily check. The fleet manager and the shop need the rest.
Delivery and courier fleets
Cargo vans that run every day and change drivers between shifts.
Field service companies
Service trucks and pickups that technicians take home and drive to jobs.
Construction contractors
Pickups and box trucks moving crews and equipment between sites.
Company car pools
Pool cars and SUVs booked by different employees each week.
Municipal and utility fleets
Mixed fleets of cars, trucks and service bodies with their own inspection schedules.
Fleet maintenance shops
Defect reports to repair, services and annual inspections across the fleet.
Before you fill it in
The van with the bad tire went out again this morning.
Try UNIO24 to automate vehicle inspections.
Try UNIO24 FreeA spreadsheet goes out of date within days, and keeping it current takes someone's time every day. UNIO24 automates that work: each inspection, defect and repair updates the vehicle's record as it happens.


| Capability | Free Template | UNIO24 FreeRecommended for growing fleets |
|---|---|---|
| Inspections | ||
| Daily vehicle checklistThe template prints a weekly sheet per vehicle. UNIO24 runs a ready-made pre-trip template on the driver's phone. | Partial | Yes |
| Photos of the damageThe cracked mirror or the worn tire, attached to the inspection. | No | Yes |
| Defects and due dates | ||
| Keep a vehicle with a defect off the roadThe register shows OUT OF SERVICE from the log. UNIO24 records the defect and can turn it into a repair work order. | Partial | Yes |
| Service and annual inspection datesBoth track them. UNIO24 also schedules the next inspection. | Partial | Yes |
| Data & reliability | ||
| Many drivers and depots at onceA shared file gets overwritten. UNIO24 handles simultaneous users. | Partial | Yes |
| Full history per vehicleEvery inspection, defect, repair and service kept on the vehicle | Partial | Yes |
| Full support | 0/ 6 | 6/ 6 |
Frequently Asked Questions
About vehicle inspections and the template
Is the vehicle inspection checklist free?
Yes. No cost, no subscription, no card. Enter your name and email and the Excel file downloads straight away.
Is a daily vehicle inspection required by law?
For commercial vehicles, yes: the law requires the driver to check the vehicle is safe before driving, and reported defects to be repaired before the vehicle runs again. For company cars and light vans it is usually a company policy rather than a legal duty. Check the rules that apply to your vehicles.
How often should fleet vehicles be serviced?
Follow the manufacturer's interval by miles or months, whichever comes first, and shorten it for hard use. The template defaults to six months for cars and pickups, four for cargo vans and three for box trucks, tractors and service trucks. Change it on the Vehicle Types tab.
What should a daily vehicle inspection include?
Tires and wheels, all lights, windshield, mirrors and wipers, fluid levels and leaks, brakes, steering, horn, seat belts, dashboard warning lights, the safety kit and the documents on board. The checklist in this file groups them into a walk-around with the engine off, the engine bay, and the cab with the engine running.
What is a DVIR?
A driver vehicle inspection report lists the defects a driver found on the vehicle. For commercial vehicles, reported defects must be repaired before the vehicle is operated again. In this file, a report with defects is logged as a FAIL and keeps the vehicle OUT OF SERVICE until the repair date is entered.
Does it work for trailers?
Trailers have their own checks: coupling, landing gear, air lines and glad hands. Use the trailer inspection checklist for them.


