Fleet management in Excel: free 2026 template, guide and limits

An Excel fleet management spreadsheet is enough to track a dozen vehicles: registrations, drivers, servicing, costs and deadlines fit into five tabs and a few formulas. Beyond 20 to 30 vehicles, the limits — multi-user, alerts, telematics, GDPR — justify dedicated software.

Excel remains the most widely used tool for starting fleet management: it is already installed, everyone can open it, and it costs nothing extra. This guide gives a structured template, the formulas that genuinely save time, then the eight limits you will hit sooner or later, with an indicative threshold for deciding when to change tools.

Download the free Excel fleet management template — five tabs, formulas included, no macros, from our template library.

What is a fleet tracking spreadsheet for?

A fleet tracking spreadsheet answers four questions every fleet manager asks each week:

1. Which vehicles do we have, and who drives them? Inventory, assignment, mileage.

2. What is falling due? Technical inspection, insurance, contract end, servicing, driving licence.

3. What does each vehicle cost? Lease payments, fuel, servicing, tyres, fines, insurance — the total cost of ownership.

4. Are we compliant? Documents up to date, drivers designated after an offence, personal data protected.

These are not theoretical questions. The technical inspection of a light vehicle is mandatory in the six months before its fourth anniversary, then every two years; light commercial vehicles add an annual emissions visit under article R. 323-22 of the French highway code. Missing one costs €135 and, after an accident, difficult conversations with the insurer.

How to structure an Excel fleet template

The template rests on five tabs linked by the registration number, which serves as the unique identifier. That is the most important rule: one registration, one row in the Vehicles tab, and every other sheet refers to it.

Tab 1: Vehicles

Column	Content	Format
A. Registration	Unique identifier	Text
B. Make / model	Make, model, trim	Text
C. Category	Car, van, HGV, two-wheeler	Drop-down list
D. Energy	Petrol, diesel, hybrid, plug-in hybrid, electric	Drop-down list
E. WLTP CO2 (g/km)	Box V.7 of the registration document	Number
F. First registration	Box B of the registration document	Date
G. Fleet entry	Delivery or purchase	Date
H. Ownership type	Purchase, long-term lease, lease-purchase	Drop-down list
I. Lessor / financier	Provider name	Text
J. Contract end	Planned return	Date
K. Contractual mileage	Total over the term	Number
L. Current mileage	Latest reading	Number
M. Date of last reading	—	Date
N. Assigned driver	Reference to the Drivers tab	List
O. Site / branch	—	Text
P. Status	In service, off the road, awaiting return, disposed of	List

Tab 2: Drivers

Surname, first name, department, licence number, validity date, assigned vehicle, assignment date, associated fuel card, work phone. Add an "Geolocation notice" column if you ever fit telematics units: the CNIL, the French data protection authority, requires employees to be informed individually and prohibits using geolocation to monitor break times.

Tab 3: Servicing and work

Registration, date, mileage at the intervention, type, provider, amount excluding and including tax, next intervention planned, invoice number, comment. This is the tab that feeds the servicing history demanded when a leased vehicle is returned.

Tab 4: Costs

One record per expense: registration, date, category, amount excluding tax, VAT, amount including tax, source, driver. On fines, the employer must designate the driver within 45 days of the notice, under article L. 121-6 of the French highway code; a "Designation made on" column avoids the non-designation penalty.

Tab 5: Deadlines

Registration, type of deadline, date, days remaining (calculated), status, owner. This is the daily dashboard: sorted by days remaining, coloured by conditional formatting.

Which free Excel templates can you use to manage a fleet?

Dadycar offers seven free Excel templates for managing a vehicle fleet: the fleet tracking workbook, plus six workbooks dedicated to budgeting, total cost of ownership, roadworthiness tests, condition reports, software selection and vehicle allocation. All of them download as XLSX files from our template library, after a thirty-second form filled in once for the whole library.

Template	What it is for	Link
Fleet tracking workbook	Keep registrations, drivers, servicing, costs and due dates (technical inspection, service, insurance, tyres) in a single workbook, with the alerts calculated for you	Download the tracking workbook
Annual fleet budget	Build the year's budget item by item — lease payments, fuel, servicing, insurance, tyres —, track planned against actual every month and project the year end	Download the annual budget
Total cost of ownership calculator	Work out what a vehicle really costs over its life, French taxation included (benefit in kind, annual CO2 emissions tax and pollutant tax, 2026 scales), and compare two vehicles, combustion or electric	Download the TCO calculator
Roadworthiness test calendar	Apply the statutory intervals per category — cars, vans, heavy goods vehicles, trailers — and calculate the next test date from the last one, with a countdown per vehicle	Download the calendar
Vehicle condition report	Record handover and return: bodywork with a damage diagram, equipment and on-board documents, mileage, fuel level, photographs and both signatures	Download the condition report
Software evaluation grid	Compare fleet management solutions on 20 weighted criteria, with an automatic score and ranking, and 11 questions to ask during a demo	Download the grid
Vehicle allocation policy	Set who is entitled to which vehicle: recipient categories, rules on private use, fuel and return, and a handover appendix to be signed	Download the allocation policy
Template library	Find all seven templates, sorted by theme: tracking and steering, choosing software, compliance and due dates, costs and budget, HR and drivers	See all 7 templates

Which formulas to use

Three formulas turn an inventory into a management tool. French Excel syntax, semicolon separator.

Cost per kilometre by vehicle

=SIERREUR(SOMME.SI.ENS(Coûts!E:E;Coûts!A:A;A2)/(L2-Q2);0)

where Coûts!E:E holds amounts excluding tax, Coûts!A:A the registrations, L2 the current mileage and Q2 the mileage on fleet entry. SIERREUR avoids division by zero on a new vehicle.

Simplified TCO over the contract term

=(Monthly_payment*Term_months + Annual_insurance*Term_months/12 + Estimated_servicing + Estimated_tyres + Estimated_fuel - Resale_value) / Contractual_mileage

For a purchased vehicle, replace the payment with (purchase price − resale value) and add the annual taxes on vehicle use where they apply. The result is a cost per kilometre comparable across energies; the TCO calculator does the same online.

Deadline alert at 30 days

D2 : =SI(C2="";"";C2-AUJOURDHUI())

E2 : =SI(D2="";"";SI(D2<0;"OVERDUE";SI(D2<=30;"To plan";"OK")))

Add conditional formatting: red if D2<0, amber if D2<=30, green otherwise. To calculate the next technical inspection date from first registration:

=SI(AUJOURDHUI()<MOIS.DECALER(F2;48);MOIS.DECALER(F2;48);MOIS.DECALER(F2;48+24*ENT((AUJOURDHUI()-MOIS.DECALER(F2;48))/730)+24))

The formula returns the first deadline at 4 years, then every 2 years on the anniversary date. If an inspection was carried out early, the next deadline runs from its date: use =MOIS.DECALER(date_of_last_inspection;24) instead, which matches the deadline printed on the inspection report. For vans, add the emissions visit, due within the two months before the first anniversary of each periodic inspection.

Two more useful formulas

• Average consumption: =SIERREUR(SOMME.SI.ENS(Carburant!F:F;Carburant!A:A;A2)/(L2-Q2)*100;""), with litres in column F.

• Contractual mileage overrun: =SI(L2>K2*(AUJOURDHUI()-G2)/(J2-G2);"Above pro rata";"Within pro rata"), which compares actual mileage with the theoretical figure to anticipate long-term lease return penalties.

The 8 limits of Excel for fleet management

The template above works, and works very well as long as one person keeps it current. The limits appear with growth, the number of users and regulatory requirements.

Limit	What actually happens	Impact
1. Multi-user	Two people edit the file, one version overwrites the other; no access rights by site or role	Data lost, accountability blurred
2. Alerts	Excel warns nobody: the alert exists only if someone opens the file and reads the right row	Missed inspections and returns
3. Telematics	No mileage or journey data arrives automatically; everything is keyed in by hand	Wrong cost per km, overruns spotted too late
4. GDPR	Names, licences, phone numbers and sometimes geolocation circulate as attachments, with no access log or retention period (GDPR, article 5)	Legal risk and regulatory sanction
5. History	No record of who changed what and when; an incomplete servicing history devalues the vehicle at resale	Financial loss, disputes with the lessor
6. Data-entry errors	A mistyped registration, a wrong date format, an overwritten formula: the file becomes wrong without anyone noticing	Decisions made on false data
7. Reporting	Every management or sustainability report is rebuilt by hand; the fleet carbon footprint becomes an annual project	Several days a month of reprocessing
8. Mobile	The driver in the field cannot log mileage, complete a photo condition report or report a breakdown	Information lost between the field and the office

A recent regulatory constraint compounds these eight: companies with at least 100 light vehicles must calculate their share of low-emission vehicles each year for the annual incentive tax. The calculation rests on entry dates, category and emissions for each vehicle over a multi-year window. It can be done in Excel, but it is fragile — we cover the scheme in our article on the LOM law and fleet greening.

When to move from Excel to software

There is no legal threshold, but a practical one emerges:

Fleet size	Suitable tool	Why
1 to 10 vehicles	Excel or an online spreadsheet	One person, few deadlines, no cost
10 to 30 vehicles	Structured Excel with disciplined weekly entry	Deadlines multiply, errors start to cost
More than 30 vehicles, several sites or several users	Fleet management software	Automatic alerts, access rights, mobile app, integrations
Vehicles fitted with telematics units or connected	Software with telematics	Excel cannot receive a continuous data feed

Three signals say the moment has come, whatever the size: you have already missed a deadline with financial consequences; more than one person needs to read or edit the file; you have to produce regular reporting. The move is prepared with that same file: serious software imports your Vehicles, Drivers and Contracts tabs in minutes. The ROI simulator gives an order of magnitude.

How Dadycar helps

Dadycar follows the logic of this Excel template, without its limits. Importing your file creates the vehicles, drivers, contracts and deadlines; deadline alerts then go out by email and notification without anyone opening a spreadsheet. Mileage arrives from telematics units or connected vehicles, expenses from fuel cards, fines are designated through the ANTAI integration. Data is hosted in France by OVHcloud, with role-based access rights and a complete audit trail.

Full fleet management, deadline alerts included, costs €6 excl. VAT per vehicle per month, with a 15-day free trial, and €16 excl. VAT with telematics, with no minimum term (see pricing). Explore fleet management or request a demonstration.

Frequently asked questions

Is there a free Excel fleet management template?

Yes. The template offered in our library has five tabs — vehicles, drivers, servicing, costs, deadlines —, drop-down lists, and formulas for cost per kilometre, simplified TCO and a 30-day deadline alert, with no macros. It works on Excel 2016 and later, and on compatible spreadsheet applications.

How do you build a company vehicle tracking spreadsheet in Excel?

Create one tab per object and use the registration number as the unique identifier in every sheet. Lock the calculated columns, use drop-down lists for categories and conditional formatting on deadlines. Set a weekly entry routine and one person responsible for the file.

Which formula calculates a vehicle's cost per kilometre?

Divide the sum of the vehicle's expenses by the kilometres driven since it joined the fleet: =SIERREUR(SOMME.SI.ENS(Coûts!E:E;Coûts!A:A;A2)/(L2-Q2);0). Expenses include lease payments or depreciation, fuel, servicing, tyres, insurance and fines.

How do you create a technical inspection alert in Excel?

Calculate the deadline — 4 years after first registration, then 2 years after each inspection —, then in a "days remaining" column enter =C2-AUJOURDHUI(). Conditional formatting turns the row amber below 30 days and red once negative. Excel sends no notification: open the file weekly, or move to a tool that sends the alerts.

Is an Excel fleet file GDPR-compliant?

It can be, provided you limit the data collected to what is necessary, inform employees, define a retention period, restrict access and protect it with a password. In practice, a file emailed around or shared on a common server with no access log makes those obligations hard to demonstrate.

From how many vehicles is software needed?

The indicative threshold sits around 20 to 30 vehicles, earlier if several people manage the fleet, if vehicles are spread across several sites, if you use telematics units or if you must produce regular reporting. Software pays for itself as soon as the cost of one missed deadline exceeds its annual subscription.