The spreadsheet did its job — that’s not the problem
Most small businesses start on a spreadsheet, and that’s a sensible way to start. It’s cheap, it’s flexible, and you don’t need anyone’s permission to change a column. A landscaping business tracking jobs in a shared sheet, a clinic booking appointments in a colour-coded grid, a tradie quoting off a template with a few formulas built in — all of that is a completely reasonable way to run a business doing twenty or thirty jobs a week.
The problem isn’t that you used a spreadsheet. It’s that the same tool that made the first year easy quietly stops working as the business gets more complicated — and because a spreadsheet never crashes or throws an error, nobody ever declares the moment it stopped being enough. It just gets slower, riskier and more annoying to use, a little at a time, until one day someone asks “why do we still do it this way?” and nobody has a good answer.
It isn’t about the size of the file
The instinct is to measure this by row count — “we’ll deal with it once it gets too big.” That’s the wrong test. A spreadsheet with eight hundred rows can work fine if one person owns it and nothing downstream depends on it being right in real time. A spreadsheet with sixty rows can already be a liability if three people need to update it at once, or if a customer’s next step depends on it being accurate the moment they ask.
The real question isn’t how big the file is. It’s how much coordination the business now needs that the file was never built to handle.
One person becomes the whole system
In a lot of small businesses, there’s one person — often the office manager, the bookkeeper, or the owner themselves — who understands how the master spreadsheet actually works. They know which tab feeds which formula, which cells you’re not allowed to touch, and why last Tuesday’s version is more trustworthy than the one from this morning. Everyone else works around them.
That’s manageable while the business is small enough for one person to be the bottleneck without anyone noticing. It stops being manageable the day that person takes leave or leaves the business altogether, and a formula breaks or a tab goes missing with nobody else able to fix it. At that point the spreadsheet isn’t a tool anymore — it’s a dependency on one person’s memory.
The same numbers get typed in twice
This is one of the clearest tells. A quote gets built in a spreadsheet, then retyped into the accounting software to raise an invoice. A booking gets written into a scheduling sheet, then repeated in a text message to the tradie doing the job. Stock levels get counted on paper, then updated in one spreadsheet for ordering and another for the website.
Every one of those handoffs is a place where a number can quietly change on the way through — a transposed digit, a missed row, a version that didn’t get updated before someone read it. None of these mistakes are dramatic on their own. They add up to hours a week of re-entry, and to a business where nobody is fully confident the numbers in front of them are current.
”Let me check and get back to you” becomes permanent
Watch for how often someone has to say this to a customer. Can we fit you in Thursday? Is that part still in stock? What did we quote the Hendersons last time? If the honest answer requires opening a spreadsheet that lives on one laptop, checking with whoever’s not at their desk, or cross-referencing two tabs that don’t quite agree, that’s a business system problem wearing a customer service costume.
Field-based businesses feel this hardest. A spreadsheet that lives on an office computer is close to useless to someone standing in a client’s driveway trying to confirm a price or check a job history on their phone.
Mistakes get caught by the customer, not by you
This is the sign worth taking most seriously, because it’s the one with a cost attached. A job gets double-booked because two people were updating the same sheet from different tabs. A customer gets quoted last year’s price because the pricing tab wasn’t the one that got updated. An invoice goes out for the wrong amount because someone copied the wrong row.
Individually these look like one-off mistakes. Together, they’re evidence the system has no way of catching errors before they reach a customer — no validation, no single source of truth, no record of who changed what. In a spreadsheet, everyone is trusted to get it right every time. In a growing business, that stops being a safe bet.
What “outgrown” actually looks like
None of this means the spreadsheet was a bad decision, and it doesn’t mean the next step has to be a complicated one. Outgrowing a spreadsheet usually isn’t one big moment — it’s several of the signs above showing up in the same few months, each one a bit more expensive than the last. The businesses that handle this well are the ones that notice the pattern and ask what a simpler, shared, accurate system would need to do — rather than adding another tab, another colour code, or another workaround to a tool that was never built to carry this much.