You know the meeting. Someone from finance says revenue was a certain figure. Someone from sales says no, it was higher. Operations has a third number on their own tab. Twenty minutes later nobody has discussed the actual business, because the whole room is arguing about which spreadsheet is right. Nothing gets decided, because nobody can agree on what is even true.
When every department keeps its own version of the numbers, you do not have data. You have a collection of opinions, each one formatted to look like a fact.
We see spreadsheet sprawl in almost every business that has grown faster than its systems. It is not a sign of carelessness. It is what happens when capable people solve their own problems with the most flexible tool on earth, and then keep doing it for years. Nobody decides to run the company off two hundred disconnected files. It accumulates one quick fix at a time, and by the time it hurts, unpicking it feels like a project nobody has the appetite for.
Why it happens, and why it eventually breaks
Spreadsheets earn their place honestly. They are quick, they are free, and they bend to whatever shape you need in the moment. When the finance lead needs a view nobody else has, a spreadsheet gives it to them in five minutes. That is genuinely useful, and it is why the sprawl starts.
The trouble is what happens next. The same flexibility that made it quick is exactly what makes it fragile at scale:
- Rival versions. One file gets emailed around, edited by four people, and now there are four files that disagree, all named something like "final_v3".
- No audit trail. A number changes and nobody can say who changed it, when, or why. The history is gone.
- Data trapped in silos. The sales numbers live on one laptop, stock lives on another, and the two never meet, so nobody can see the whole picture.
- Quiet errors. A formula gets dragged one row too far, a filter is left on, and a wrong total travels into a board pack without anyone noticing.
A spreadsheet is a brilliant tool for one person solving one problem. It becomes a liability the moment it turns into the official record three departments depend on.
What a single source of truth really means
The phrase gets thrown around, so it is worth being plain about it. A single source of truth does not mean one giant file that holds everything. It means that for any given fact, there is one agreed place that owns it, and everyone draws from that place instead of keeping a private copy.
Customer details live in one system. Stock levels live in one system. Sales sit in one system. When you need a number, you go to its owner, not to whichever spreadsheet you happen to trust. The fact has one home, and one home only.
The path to get there
You do not fix this by banning spreadsheets overnight. That just sends everyone back to their private files in secret, which is worse. You move deliberately, in an order that builds trust as you go, so each step earns its keep before you take the next one.
Four steps, in order
- Agree the definitions. Before anything technical, get the room to agree what "revenue" or "an active customer" actually means. Most disagreements are about definitions, not data.
- Pick a system of record per data type. Decide which system owns customers, which owns stock, which owns sales. One owner each, no exceptions.
- Integrate. Connect those systems so data flows between them automatically, instead of being copied by hand into a spreadsheet at month end.
- Report from one place. Build your dashboards and reports on top of those agreed sources, so everyone is finally reading off the same page.
Start with the number you argue about most
You do not have to fix everything at once. Pick the single figure that causes the most meeting-room arguments, agree its definition, give it one owner, and report it from there. The relief of that one number being settled usually convinces everyone the rest is worth doing.
Spreadsheets are still fine at the edges
None of this means spreadsheets are the enemy. They are still the right tool for a quick once-off calculation, a rough model, a personal working view. The line we draw is simple: a spreadsheet is great for thinking, and dangerous as the official record. Use it to explore an idea, not to be the place the whole business depends on for a number that has to be right.
The quiet relief at the end
The best part of getting here is not the technology. It is the change in how meetings feel. Nobody opens their laptop to defend their version. The number on the screen is the number, everyone trusts it, and the conversation moves straight to what to actually do about it. That quiet, where the arguing used to be, is the whole point. It is the sound of a business that finally agrees on what is true, and can get on with the real work.
