There is a very specific life cycle to a business spreadsheet. Week one: pristine, colour-coded, a thing of beauty. Month six: eleven tabs, three of which are called "old," a formula that only one person understands, and a cell that's been manually overtyped so many times it no longer calculates anything at all. This is spreadsheet rot, and almost every growing business has a live case of it somewhere.
How it happens
Spreadsheets are brilliant at the thing they were built for: quick, flexible number-crunching for one person. The trouble starts when they quietly get promoted to "the system" - the place where customer data, job statuses, and pricing all live, edited by five people on three different devices, none of whom fully trust the others' changes.
The tell-tale signs
- A tab named after a date, containing what everyone insists is "the real one"
- At least one column with a name nobody can explain
- A formula that breaks if you insert a row in the wrong place
- Someone keeping a "backup" version on their own laptop, just in case
Why it's not really your fault
Spreadsheets scale brilliantly for data and terribly for people. They were never designed for multiple simultaneous users with different jobs to do, which is exactly what most growing businesses need. The Office for National Statistics has noted the steady rise in UK small business digital tool adoption over the past decade - largely because the alternative stops working at a fairly predictable size (ons.gov.uk).
What actually helps
The fix isn't necessarily "buy expensive software." Sometimes it's just agreeing on one source of truth and being ruthless about it. Other times the business has genuinely outgrown what a grid of cells can safely hold, and that's when a proper system - even a fairly simple bespoke one - starts to look less like an indulgence and more like basic hygiene. Our own case studies are mostly stories of exactly this moment, if you want to see what it looks like from the other side.
The verdict
If your spreadsheet has a tab called "misc2 (final)," it has already told you everything you need to know.