5 signs your business has outgrown spreadsheets
Spreadsheets are genuinely good software, and most businesses leave them too late rather than too early. Here are the five signals that actually mean it is time.
I want to start by defending spreadsheets, because most articles like this do not. Excel and Google Sheets are extraordinary pieces of software. They are flexible, universally understood, cost almost nothing, and require no developer. A very large number of successful businesses run on them for years, correctly.
The problem is not that spreadsheets are bad. It is that the moment they stop being the right tool is quiet. Nothing breaks. There is no error message. The cost just starts accumulating somewhere you are not looking, usually in your team's time and in decisions made from numbers that were slightly wrong.
These are the five signals that the moment has passed.
1. Someone has become the spreadsheet
There is a person in your business who knows why column M is highlighted amber, which tab is the real one, and what to do when the pivot breaks. Nothing happens without them. When they are on holiday, work waits.
This is the clearest signal of all, because it is a business continuity risk dressed up as competence. That knowledge should live in a system, not a head. Ask yourself honestly what happens to your operations if that person leaves next month.
2. You reconcile before you trust
Watch what happens before a management meeting. If someone spends an afternoon cross-checking the sales sheet against the accounting system against the stock file, and finds discrepancies every time, you no longer have a source of truth. You have three sources and a negotiation.
The tell is the phrase "let me just check that number." If it is said routinely, your reporting is not reporting. It is archaeology.
3. Version control is a naming convention
If your filenames end in _final, _final_v2, or _FINAL_use_this, that is version control implemented by hope. Sooner or later two people edit different copies on the same afternoon and one set of changes quietly disappears.
Shared cloud sheets solve part of this and are a genuine improvement. But they do not solve the deeper issue: a spreadsheet has no concept of who is allowed to change what. Which leads directly to the next signal.
4. Everyone can see and change everything
Spreadsheets have essentially no permissions model. If a junior team member needs to update today's bookings, they typically get access to the whole file, including pricing, margins, and personal data about clients.
For most businesses this is uncomfortable. If you handle health records, financial data, or anything covered by UK GDPR, it is a compliance problem. Data minimisation means people should only access what their role requires, and a shared sheet cannot enforce that. Our practical guide to GDPR for small business software covers what that obligation actually looks like day to day.
5. Your process now lives in the gaps
This one is subtle and it is usually the most expensive. The spreadsheet holds the data, but the actual process lives elsewhere: in a WhatsApp group, in someone's inbox, in a verbal handover at the start of a shift.
The sheet says a job is booked. Whether the parts were ordered is in a text message. Whether the customer confirmed is in an email. Nobody can answer "what is the status of this job?" without asking two people. Work does not fall through the cracks because anyone was careless; it falls through because the cracks are where the process lives.
When the data is in one place and the process is in another, the gap between them is where things go missing.
What to do about it, without a big project
The instinct is to replace everything at once. Resist it. Replacing a working spreadsheet with a half-finished system is worse than leaving it alone.
- Pick the single worst workflow. Not the biggest, the one causing the most rework and the most anxiety.
- Write down how it actually works, including the WhatsApp messages and the verbal steps. This document is valuable on its own.
- Replace only that one workflow, and keep the other spreadsheets exactly as they are.
- Measure the hours you get back, then use that to decide whether a second phase is worth funding.
Plenty of businesses do one phase, get the hours back, and sensibly stop there. That is a good outcome. The goal is not to eliminate spreadsheets. It is to stop paying a tax you had not noticed you were paying.
If you recognise three or more of these five, it is probably worth a conversation. If you recognise one, you are likely fine for now.
Frequently asked questions
Row count is rarely the real limit. Modern spreadsheets handle hundreds of thousands of rows. The practical limits are concurrency (several people editing at once), permissions (everyone sees everything), and process (the workflow living outside the file). Businesses usually hit those long before they hit a size limit.
For collaboration, yes: real-time editing and a single shared copy remove a whole class of version-control problems. But Sheets still has no meaningful permissions model within a file and still cannot enforce a process, so it addresses two of the five signals rather than all of them.
Often that is the best first step. Replacing the single worst workflow while leaving the rest in place limits cost and risk, and lets you measure the benefit before committing further. Many businesses stop after one phase, which is a perfectly good outcome.