Spreadsheets are excellent software. They are flexible, everyone knows them, and they cost nothing extra. Most businesses run on them far longer than consultants like to admit, and that is usually the right call.
But they fail in a particular way: not gradually, all at once, usually at the worst moment. Here is how to tell you are close.
Nine signs
1. There is a "master" copy and nobody fully trusts it
The moment someone says "let me check I have the latest version," you have a data integrity problem wearing a spreadsheet costume.
2. One person is the only one who understands it
The formulas are load-bearing, undocumented, and in one person's head. This is a business continuity risk, not a quirk. If they leave, the process leaves with them.
3. Fixing broken formulas is a recurring task
Someone sorts one column without the others, or pastes over a formula. If "repair the tracker" happens monthly, that is the real cost of the spreadsheet and nobody is counting it.
4. You cannot tell who changed what
A number is wrong and there is no way to know when it changed or who changed it. For anything touching money, compliance, or client commitments, that is a genuine problem.
5. Everyone can see everything
Salary data, client pricing, and margins in a file anyone with the link can open. Spreadsheets have essentially no row-level permissions, and workarounds are worse than the problem.
6. It takes hours to answer a simple question
"How many open jobs are past due?" requires exporting, pivoting, and cross-referencing. The data is there; the structure is not.
7. The same data is typed in more than once
Once in the spreadsheet, again in the accounting system, again in an email. Every retype is a chance to be wrong, and reconciliation becomes a job.
8. It has become a workflow, not a record
Colour-coded rows meaning "awaiting approval," a column of initials standing in for sign-off. When a spreadsheet is tracking state, it is impersonating an application and doing it badly.
9. It is slow, or it has crashed
Tens of thousands of rows with formulas across them will hit a wall. When people avoid opening the file because it takes a minute to load, adoption is already failing.
How many is too many?
One or two is normal — fix them and move on. Four or more, especially if they include #2, #4, or #5, means the spreadsheet has become a liability, and the cost of leaving it there is already being paid in reconciliation, errors, and key-person risk.
What to replace it with
Not necessarily custom software. In rough order of cost:
- A better-structured spreadsheet. Sometimes it is one sheet doing four jobs. Splitting it, locking formulas, and adding validation buys another two years for a day of work.
- An off-the-shelf product. There is probably a good product for your industry. Try hard to make one fit before building anything.
- A no-code database tool. Real fields, permissions, and history without an engineering project. Excellent middle ground; watch per-seat pricing at scale.
- A custom application. Right when the process genuinely is your differentiator, when integrations matter, or when compliance requires an audit trail no product provides.
Start at the top and work down. Most businesses stop at step two or three, and should.
Before you replace anything
Write down what the spreadsheet actually does — including the exceptions and the informal rules. That document is worth more than any tool selection, because every replacement, bought or built, needs it. It is also the fastest way to discover that two of the four "requirements" are habits nobody needs.
If the honest answer is a custom build, we start with exactly that documentation exercise under application development. If the answer is that your data is scattered across systems that should be talking to each other, that is data and analytics work first.
Describe the spreadsheet and we will tell you which of the four options fits.