Seven signs a spreadsheet is now running your company
Spreadsheets are a fine way to start. Here is how to tell when one has quietly become your operating system, and what to do before it breaks.
4 min read Provecta Group
Nobody sets out to run a company on a spreadsheet. It starts as a list of jobs, or a stock count, or a tracker for who has paid. It works. People add a column, then a tab, then a colour code. A few years later the business depends on a file that one person understands, that three people edit, and that nobody is fully sure is correct.
We have nothing against spreadsheets. They are the right tool for a lot of work, and replacing one with software too early is its own mistake. But there is a point where the sheet stops being a tool and starts being the system, and it is easy to pass that point without noticing. These are the signs.
1. There is a tab called "DO NOT EDIT".
Or "MASTER", or "FINAL v3". The moment a sheet needs a warning label, people are already working around it. Somewhere there is a copy that someone downloaded, edited and never put back.
2. Only one person can explain the formulas.
Ask your team how the commission column is calculated. If the answer is "ask Grace", the sheet has a single point of failure, and it is on leave in August.
3. The same number lives in more than one place.
The job count on the sales tracker does not match the job count on the invoicing sheet, and both are "right" because they count different things. Meetings start with ten minutes of reconciling instead of deciding.
4. Colours mean things that are not written down.
Yellow means waiting for the client. Unless it was yellow before March, when it meant waiting for parts. New staff learn the code by getting it wrong.
5. Someone spends a day a month copying data between sheets.
Month-end, payroll, the stock reorder. If a person is moving numbers from one file to another by hand on a schedule, that person is doing the job software should do, and every copy is a chance for a typo.
6. You cannot tell who changed what.
A price was updated. A customer's terms changed from 30 days to 60. When? Who agreed it? The sheet records the new value and nothing about why.
7. You are now asking an AI to read it.
This one is new, and it is the reason we wrote this list. More owners are uploading their tracker to ChatGPT or a similar tool and asking questions. "How many jobs did we finish in May?" "Which customers are overdue?"
The AI will answer. It will read whatever tab it lands on, treat the colours as decoration, add up a column that includes a row someone typed "cancelled" into, and give you a confident number. It has no way to know that the "Old Jobs" tab is out of date, or that yellow meant something different before March. Everything that makes the sheet hard for a new hire makes it hard for the AI, and the AI does not ask.
What to do before replacing anything
The temptation at this point is to buy software. Sometimes that is right. Often the faster win is to make the existing sheet honest first, because whatever you move to later will inherit the same confusion unless you sort it out.
Start with a front tab, a plain page at the start of the file, that says:
- What this file is for, in one sentence.
- Which tab is the current one for each purpose, and which are archives.
- What each colour or status means, with the date that meaning started.
- Who owns the file and who is allowed to change which columns.
- When it was last checked against reality, and by whom.
That page does two jobs. It lets a new person use the sheet without asking anyone. And if you hand the file to an AI tool, it is the first thing to point it at, so its answers are based on your definitions instead of its guesses.
A small digression. Should you move everything into one big system at once? We tend to think the answer depends less on the software than on whether anyone has ever written down what the current process is. If nobody can describe it, a new system will just be a more expensive place to be confused.
Start with one file
Pick the one spreadsheet your business would struggle without. Add the front tab. Put a "last checked" date and an owner's name at the top of every other tab. Then ask two people on your team to explain one column each, separately, and see whether their answers match.
If they do not, you have found the next thing to write down.
Get a quick read on how much of your operation runs on files like this at pgco.world/tools/os-health.