Spreadsheets are genuinely the right tool early on — fast to set up, flexible, and free. The problem is that nothing ever tells you when that stops being true. Here are the signs I actually look for.
One tab has become load-bearing
There is usually one specific spreadsheet — everybody in the business knows which one — that half the operation quietly depends on. If it corrupted or vanished tomorrow, work would stop. That is the clearest sign a spreadsheet has become an application without anyone deciding to build one, minus the things a real application would give you: permissions, validation, and a backup that isn’t “hope nobody deletes the wrong row.”
Only one or two people can safely edit it
Formulas that took a long time to get right, held together by conventions that live in someone’s head rather than anywhere written down. If the business would be in genuine trouble should that person be on holiday when something needs updating, the spreadsheet has already outgrown being a spreadsheet.
The same number gets typed in more than once
Order details copied from an email into a tracking sheet, then into an invoicing tool, then into a reporting sheet. Each copy is a chance to introduce an error, and each one costs real time that nobody adds up because it happens in small pieces throughout the day rather than as one visible block.
Reports take longer to build than the work they describe
If producing Monday’s numbers takes longer than the work those numbers are reporting on, the reporting process itself has become a cost centre. This is one of the most common triggers for automation work, because the fix is usually mechanical rather than a redesign of how the business operates.
Nobody fully trusts the numbers
Two versions of the same figure, disagreeing, with nobody quite sure which one is right. Once that happens a few times, people start keeping their own shadow spreadsheet to be sure — which makes the reconciliation problem worse, not better, and is usually the moment trust in the whole system quietly breaks.
Growth is making it worse, not easier
A spreadsheet that worked fine for five customers a week does not scale linearly to fifty. The manual steps that were a minor inconvenience at low volume become the thing capping how fast the business can actually grow, well before anyone notices that is what’s happening.
The tell is not that the spreadsheet is messy. Messy spreadsheets are normal. The tell is that fixing the mess has stopped being worth anyone’s time, because the business has moved past what the tool was ever meant to hold.
What to do about it
None of this means replacing every spreadsheet in the business — most of them are still exactly the right tool for what they do. It means finding the one or two that have quietly become load-bearing, and being honest about what they are actually costing in time, errors and risk. That is precisely the exercise covered in mapping how your business actually works — usually the fastest way to find out is to write down, honestly, everywhere a number gets typed in more than once.
