Home → Business Analysis

Why Excel Destroys Industrial Site Traceability

On French industrial sites, Excel and WhatsApp run 80% of projects under €50M. It has become a hallmark: you spot an experienced project manager by their 14 spreadsheet tabs and 200 lines of reserves color-coded green/orange/red. But this habit that seems robust is actually the silent enemy of traceability, audit trail, and final DOE value.

The Illusion of Excel Control

Why did Excel take over French industry? Because it's free, multi-format, requires no training, no subscription, and lets everyone structure their own columns however they want. That's precisely what makes it a trap on a project where multiple stakeholders must share the same source of truth.

The project manager has their master Excel. The client has theirs. The contractor has another. The engineer has yet another. Every Friday evening, someone merges it all by hand, copy-pastes dozens of rows, normalizes statuses (everyone writes "OK", "valid", "validated", "verified", "done" for the same thing). After 6 months on site, nobody knows who wrote what when.

The 6 Structural Flaws of Excel on an Industrial Site

1. No Audit Trail

When a cell changes from "open reserve" to "cleared", we don't know who made the change, when, from which workstation, with what justification. No digital signature, no cryptographic timestamp, no immutable log. Yet on a serious industrial project — especially on ICPE-classified sites — audit trail is required by control bureaus and inspectors. Excel produces none.

2. Fragile Versioning

The file reserves_v23_FINAL_DEF_OK_latest_changes.xlsx of which everyone has a variant isn't a true version. Divergences emerge at the weekly meeting: "you don't have my latest version". You can't easily compare two versions, can't revert to a previous one, can't tell who rolled back what.

3. Decoupled Photos

Contradictory photos arrive via WhatsApp or email, separate from the spreadsheet. When you need the photo of reserve #47 three months later, you find it in a WhatsApp chat from a site manager no longer in post. Nobody knows which photo goes with which reserve. Contradictory evidence is lost.

4. No Granular Permissions

You either have all rights to the file or none. Impossible to say "contractor X can see and modify only their own reserves, the client can validate everything, the engineer can view but not modify". Result: either you share the full file and anyone can break it, or you share nothing and everything goes through the project manager.

5. No Payment Integration

Excel doesn't calculate the AFNOR P 03-001 formula by cross-referencing progress, retention, and open blocking reserves. Calculation is manual, time-consuming, and shifts every time a reserve changes status. Contractors receive payment statements with 2–3 week delays, hurting cash flow and relationships.

6. Multilingual Impossible

On a mixed European site (Polish, Italian, German teams), Excel stays single-language. Field input from a Polish welder who can't read French becomes a human bottleneck: you need a translator, or he dictates to a site manager who writes it down, and accuracy is lost.

The Moment It Really Breaks

Excel becomes a problem when the site finishes. Excel traceability won't survive a serious audit, a payment dispute, staff turnover, or an ISO 9001/45001 quality drive. And those are precisely the moments you'd need it.

Moving Beyond Excel Without Breaking Habits

Leaving Excel doesn't mean losing flexibility. A well-designed industrial site tool keeps Excel's philosophy — a table, columns, colors, quick sorting — but adds what Excel cannot:

• Immutable audit trail: every change is logged (who, when, what, why), reversible if error, certified for audit.
• Automatic versioning: no more "v23_FINAL_DEF", the tool tracks versions.
• Photos linked to items, geolocated, timestamped, signed.
• Granular permissions by lot, by company, by role.
• Automatic payment calculation per AFNOR formula.
• Mobile and voice input in 6 languages, auto-translation.

Frequently asked questions