The spreadsheet gets a bad reputation. Business consultants love to tell you it's holding you back. Software vendors are even more enthusiastic about this opinion. But the honest truth is that a well-built spreadsheet is often exactly the right tool — flexible, cheap, and understood by everyone on the team.
The problem isn't using a spreadsheet. The problem is using one past the point where it makes sense. And that point is different for every business.
When a spreadsheet is the right answer
If you're a small team, your data doesn't change that often, and only one or two people need to access it — a spreadsheet is probably fine. It's fast to set up, easy to change, and requires no technical knowledge to maintain. A lot of businesses are more productive with a good spreadsheet than they would be with a complicated system nobody really knows how to use.
- You're tracking something simple: clients, orders, inventory
- One person owns it and keeps it updated
- The data doesn't need to connect to anything else
- You're not at a stage where mistakes are expensive
The signs it's starting to break down
The spreadsheet doesn't fail suddenly. It degrades slowly, until one day something goes wrong and you realise it's been fragile for a while.
- More than one person is editing it — and you've had a version conflict
- You're copying and pasting data between two or more spreadsheets regularly
- Someone has to "prepare" the spreadsheet before a meeting so it looks right
- You're scared to change the formulas because you're not sure what will break
- New people joining the team take weeks to understand it
- You've caught a mistake that went unnoticed for months
Any one of these is a signal. More than two or three at once, and you're already past the point where the spreadsheet is helping you.
The decision: spreadsheet, SaaS, or custom software?
When a spreadsheet starts failing, most businesses have two options before building anything custom.
The first is a SaaS tool — off-the-shelf software built for your type of problem. Booking systems, CRMs, project management, invoicing. These tools are faster to set up than custom software and cheaper to maintain. If your problem is common enough that someone has already built a product for it, start there.
The second is custom software — something built specifically for how your business works. This makes sense when your process is genuinely unusual, when you need multiple systems to talk to each other in ways no SaaS tool supports, or when you're at a scale where the cost of a custom tool is less than the cost of working around a generic one.
A simple decision test
Before you spend anything, answer these five questions:
- How many people are using this data, and how often? (1–2 people, occasionally → spreadsheet is fine. Many people, daily → you need something better)
- Does this data need to connect to other systems? (No → spreadsheet or simple SaaS. Yes → SaaS with integrations or custom)
- Is there an off-the-shelf tool that does 80% of what you need? (Yes → start there. No → consider custom)
- What's the cost of a mistake in this data? (Low → spreadsheet risk is acceptable. High → you need something with proper controls)
- How much time does your team spend managing this data every week? (Under 2 hours → not urgent. Over 5 hours → worth fixing properly)
The hidden cost people miss
When business owners think about switching from a spreadsheet, they think about the cost of building or buying something new. What they don't usually count is the cost of staying.
An employee on £28,000 costs roughly £18 to £22 an hour in real terms once employer NI, pension and overheads are included. If managing a spreadsheet takes them 5 hours a week, that's around £5,000 a year in staff time — every year, without fail. A £4,000 system that takes 30 minutes a week pays for itself in under a year and keeps saving after that.
The spreadsheet feels free because there's no invoice. But time has a cost too.
What I'd actually recommend
Start by fixing the spreadsheet. Before you spend anything, spend a day cleaning it up: remove the dead columns, document the formulas, put a clear owner on it. You might find the problem was always just the mess, not the tool itself.
If the problem persists after that, look at SaaS tools for one month before commissioning anything custom. Most of the time, something off the shelf solves it. Custom software is the right answer when it's the only answer — not the first one.
If you've been through both of those steps and you're still stuck, that's usually when it makes sense to talk to a developer. Not about building something big — about building something small that solves the specific thing causing the most pain.