When it makes sense to stop using Excel in your business
I've been seeing the same scene for more than twenty years; only the actors change. A company that bills several million a year, with real employees, customers and suppliers, and at the centre of it all an Excel file that someone created years ago "to get by" and that never went away. Nobody designed it to withstand what it withstands today. It simply grew, column by column, until it became the place where the whole company lives, without anyone ever deciding it should.
And I want to make one thing clear before going on: I have nothing against Excel. It is one of the best-designed tools ever made for what it was meant for — one-off calculations, quick analyses, a list you put together in ten minutes that solves the day. The tool is never the problem. The problem appears when that spreadsheet stops being an occasional aid and becomes, almost without anyone noticing, the system holding up a critical part of the business: stock control, order tracking, payroll calculation, customer management. At that point you are no longer using Excel as a calculator. You are using it as a database, as an ERP, as a CRM — things it was not designed for, and which it supports in a way that works until it stops working, usually at the worst possible moment.
Signs that you have already crossed that line
Over the years I've learned to recognise the moment almost by instinct, but it can be summed up in a few very concrete signs. If several of these sound familiar, you are probably already on the other side of the line:
- Several people edit the same file and, sooner or later, two different versions of "the truth" appear — and nobody knows which one is right.
- There are formulas that "break everything if you touch them", and only one person in the company can explain why, even if they haven't looked at them for months.
- The file takes several seconds to open or save, and that delay is already part of someone's daily routine.
- Every new business case — a different customer, a special rate, a new process — forces you to add one more column, sheet or macro on top of the ones already there.
- Mistakes have already cost money or time in a direct, measurable way — not as a vague suspicion but as a fact that someone had to explain in a meeting.
None of these signs alone is a reason to throw everything away and migrate in a rush. I've seen them coexist for years in companies that do well. But when several appear at once — and especially when they start repeating every month instead of every year — it almost always turns out cheaper, in the medium term, to build a tool designed for that process than to keep patching the Excel. The trap is that the cost of continuing to patch doesn't show up all at once: it is paid little by little, in lost hours and in stress at every month-end close, until one day someone adds up all that time and realises what it really costs.
What usually replaces that Excel
This is where I see the most misunderstandings. When someone thinks about "replacing the company's Excel", they tend to imagine an enormous project: months of development, a system that controls everything, a radical change in how people work. It is almost never like that, and honestly I prefer that it isn't. You don't always need a huge application, and it isn't advisable to build one even if the budget allows it.
In most of the real cases I've worked on, replacing an Excel means building a small, very focused tool: a form with the validations the Excel never had, a truly shared database (instead of a file sent around by email), and one or two simple screens to view and edit what's needed, and not one more. No "digitalising the entire company at once". You start with the process that hurts most today — the one that takes the most time or causes the most errors — and continue from there, calmly, seeing what's missing as it is used for real.
That way of moving forward, step by step and on what actually bothers you, is the least risky and the one that best fits how a small business really works: no room to stop the business while something new is built, and no budget to bet everything on a project that takes a year to deliver results.
If you recognise any of these signs in your company, tell me about your case. You don't need to know which solution you need — that's what we talk about first — and we'll calmly see whether the change is really worth it or whether, honestly, your Excel still has some life left in it.