THE FLEETI BLOG
Fleet management: Excel, GPS alone or dedicated software, what does each option look like in practice?
Excel hits a wall at around 15 vehicles, a GPS alone ignores costs and maintenance. Dedicated software pays off from 30 vehicles or a mixed fleet.

Each of these three tools suits a specific situation. Excel holds up to around fifteen vehicles, a GPS tracker alone answers questions about position but not about cost, and a dedicated platform becomes worthwhile from around thirty vehicles, or as soon as the fleet mixes vehicles and machinery. What you manage today determines what you need, not the size of your company.
According to Francenum.gouv.fr, the French government portal for the digital transformation of businesses, fleet management software is worthwhile from 5 vehicles and generates substantial savings from 50 vehicles. These thresholds vary with the complexity of operations: a fleet of 20 vehicles with construction machinery, preventive maintenance obligations and rotating drivers reaches the complexity threshold well before a fleet of 20 company cars assigned to office-based sales reps.
Three tools, three management logics
None of these tools is a degraded version of another. Excel is a storage and calculation tool. A GPS tracker is a position sensor. Dedicated software is a centralisation and automation system. These are three levels of response to the same problem, and the boundary between the first two and the third comes down to a single question: can your tool alert you when something goes wrong, without you having to look for it yourself?
What Excel does well, and when it becomes a problem
Excel is an effective fleet management tool up to about 10 to 15 vehicles, provided that operations are stable, that entries are regular, and that a single manager is responsible for it.
What Excel handles very well
On a small fleet, Excel keeps the vehicle register properly (registrations, technical inspection dates, mileage), the expenses per vehicle and the maintenance schedules. The flexibility is real: you adapt your columns to your needs without depending on a software vendor. Free templates are plentiful, the learning curve is zero, and everyone in the company knows how to open an .xlsx file.
For a tradesman with 3 vans, a service provider with 8 service cars and predictable due dates, or a very small business starting out in fleet management, Excel is the right starting point.
Signs that Excel has reached its limit
Five concrete situations show that the spreadsheet no longer holds up:
You have several Excel files for the same fleet (one per vehicle, one per heading, one per month), and you spend time getting them to talk to each other.
You have missed a technical inspection or an oil change because the alert was conditional formatting that nobody checked.
You are looking for the total cost of a vehicle over 12 months and have to consolidate 4 different files to get there.
Several people edit the same file, and competing versions coexist on the server.
You have rotating drivers and vehicle assignments are up to date only if someone remembers to update them.
Excel’s limit comes down to three mechanisms: the absence of active alerts, dependence on manual entry, and the inability to cross-check several sources without human intervention. Excel cannot alert you automatically. It does not connect to your field data. It stores what you put into it.
The invisible cost of the spreadsheet: errors, delays, double entry
Research by Raymond R. Panko (University of Hawaii, "What We Know About Spreadsheet Errors", 1998, updated 2005) covering 13 audits of business spreadsheets established that 88% of operational spreadsheets contain at least one error. On maintenance or fleet cost data, an entry error can mean a missed technical inspection, wrong billing or an underestimated TCO. The most common source of error is not the formula, it is repeated manual entry.
On a fleet of 100 vehicles, an SME generates several thousand lines of annual data on costs, servicing, claims, assignments and fuel. According to Aficar, a firm specialising in SME fleet management, a manager spending 5 hours a week on administrative fleet tasks accumulates 260 hours a year of work that appears in no operating account.
What a GPS alone provides, and what it does not replace
A GPS tracker alone answers one precise question: where is the vehicle? It answers it in real time, with a trip history, zone alerts and sometimes an estimate of consumption. Within that scope, a good GPS device is irreplaceable.
GPS covers location, not management
What a GPS alone does not do: it does not track servicing due dates, it does not calculate TCO per vehicle, it does not centralise administrative documents, it does not manage driver assignments, it does not produce cost reports. This data does not exist in the device. It is in your accounts, in your emails with the garage, in your logbooks and in the lessor’s invoices.
A fleet manager who uses only a GPS has reliable position data and estimated mileage data. Everything else they manage elsewhere, often in Excel.
When a GPS alone is enough
Two profiles legitimately need a GPS alone with no additional software layer: companies whose only concern is asset security (tracking machinery on sites, trailer anti-theft) and those that already have fleet management software and simply want to add field data. In this second case, the GPS becomes a sensor serving the software, not a standalone tool.
The blind spots of a GPS without a software layer
Three points that a GPS alone does not cover and that create invisible costs:
First, maintenance. A GPS tells you the vehicle has covered 12,000 km since the last service. It does not alert you when the next service is due, it does not create a work order, it does not communicate with your garage. This link between field data and the maintenance action requires a dedicated software layer. Fleeti centralises this chain in automated servicing tracking.
Next, costs. Consumption estimated by a GPS relies on mileage and driving profiles. It does not include actual fill-ups, fuel anomalies, repair invoices. This cross-check, which alone makes it possible to detect theft and overconsumption, requires several sources to be combined.
Finally, administrative compliance (BIK, ANTAI designation, technical inspections) is entirely outside the scope of a GPS. These obligations exist independently of vehicle position.
What dedicated software changes, in practice
Fleet management software is not an improved Excel. The difference lies in one mechanism: data arrives automatically from devices, fuel suppliers, lessors and maintenance providers. You no longer enter anything: you receive alerts and you act.
Centralised data versus scattered across tools
On a medium-sized fleet, data is typically scattered across 5 to 8 sources: the manager’s spreadsheet, fuel card statements, the LLD lessor’s exports, garage invoices, the insurer’s emails, ANTAI notifications and, if there is one, the GPS platform. Dedicated software aggregates these flows. You get a view per vehicle that includes all its costs, its history of interventions, its assignments, its documents and its field data. Fleeti centralises this data in a single dashboard with no manual export. The process of switching from a spreadsheet is described in detail on the page on digitising the vehicle fleet.
Automation versus manual entry
Active alerts are what changes a manager’s daily life. Dedicated software sends you a notification when a technical inspection is approaching, when fuel consumption exceeds the vehicle’s norm, when a driver has not been designated on a fine notice, when an LLD contract deadline is 90 days away. Excel makes you go and look for this information. Software sends it to you.
From what threshold does ROI become visible
Francenum.gouv.fr cites 5 vehicles as the threshold of interest for dedicated software. In practice, ROI becomes quick from 30 vehicles, or as soon as the fleet is mixed (vehicles and machinery) and subject to preventive maintenance obligations. The gains come from three sources: reduced fuel costs (15 to 25% depending on the fleet, through anomaly detection and eco-driving), reduced unplanned downtime through preventive maintenance, and manager time saved on administrative tasks.
Schedule a Fleeti demo to see how the platform adapts to your type of fleet.
How do you choose based on your current situation?
The choice of tool depends on two variables: the size of the fleet and its operational complexity. Here is how to read your situation.
Fewer than 10 vehicles
Excel holds. Provided the vehicles are uniform (no machinery), that operations are stable and that a single person manages the data. If you already have a recurring problem (missed technical inspections, drivers not designated on fines) or if your business generates tax obligations (BIK calculation for company cars), move to dedicated software even under 10 vehicles. The problem does not come from the number of vehicles, it comes from complexity.
10 to 30 vehicles
This is the tension zone. Excel still holds on paper, but you spend increasing time maintaining it instead of analysing its data. A GPS alone does not solve administrative problems. The question to ask: how many hours a week does your manager spend on entry, consolidation and looking for information across several files? If the answer exceeds 5 hours, dedicated software generally pays for itself in under a year.
Beyond 30 vehicles, or a mixed fleet
Dedicated software is the only viable option. Data scattered across several tools creates errors, delays and blind spots that cost more than the software subscription. For a mixed fleet (service vehicles + construction machinery + equipment), the centralisation layer is necessary from the start: machines have no registration certificate, their maintenance data comes from engine hours and not kilometres, and tracking them requires IoT connections that neither Excel nor a standard GPS can handle.
Which signs indicate you need to change tool?
Six concrete situations signal that your current tool no longer holds up:
You have had a claim or a fine whose existence you discovered late.
You cannot say within 2 minutes what the total cost of a specific vehicle has been over the last 12 months.
You have rotating drivers and the assignment is never quite up to date.
You received a surcharge on a fine because ANTAI designation was not made in time.
Your manager spends more than a day a week consolidating data rather than analysing it.
Your fleet has passed 15 vehicles or now includes machinery in addition to road vehicles.
None of these signs is resolved by adding tabs to a spreadsheet.
What Fleeti puts in place for fleets moving away from Excel or a basic GPS
Fleeti centralises on a single platform the data from field telematics (geolocation, engine hours, fuel consumption, engine data) and administrative management data (contracts, claims, BIK, fines, maintenance, documents). Data arrives automatically from IoT devices, fuel suppliers and connected providers. Switching from a spreadsheet takes 30 days on a standard fleet, with import of existing data. The gains are concentrated in three areas: reduced fuel costs (15 to 25% through anomaly detection and eco-driving), reduced unplanned downtime through preventive maintenance, and removal of the entry and consolidation tasks that represent, on a medium-sized fleet managed manually, several hundred hours a year according to fleet managers themselves.
Fleeti covers mixed fleets (vehicles + machinery + equipment) in 13 countries, with local teams in France and Africa. For fleets with specific obligations (BIK, ANTAI, LOM law), the tax and compliance modules are built into the same platform.
Schedule a 30-minute demo to see the platform configured for your type of fleet.
