Anna Totterdell
Projects Director
There is a system running your business right now that has no documentation, no version control, no access management, no audit trail, and no backup strategy. It was built by someone who may no longer work for you. It is maintained by someone who learned it through trial and error. And if it breaks, a significant part of your operation stops.
That system is a spreadsheet. Probably several.
Every mid-market business I have ever worked with runs critical processes on spreadsheets. Pricing models. Resource allocation. Order tracking. Financial reconciliation. Reporting. Forecasting. Commission calculations. Things that matter. Things that, if they go wrong, cost real money.
And nobody talks about it. Because spreadsheets are not a technology decision. They are the absence of one.
How you got here
Nobody sets out to build a business on spreadsheets. It happens gradually, and for entirely rational reasons. Someone needed to solve a problem. The ERP could not do it. IT and process strategy was either absent or backlogged. So they built a spreadsheet. It worked. It got shared. It got extended. Other people started depending on it. And now, five years later, it is load-bearing infrastructure that nobody fully understands and everyone is afraid to touch.
This is not a failure of the people involved. It is a failure of the systems they were given. Spreadsheets fill the gaps that enterprise software leaves behind. They are the shadow IT that nobody calls shadow IT, because everyone does it and nobody wants to admit how much of the business depends on them.
The real cost of spreadsheet operations
Let me quantify this for you, because the cost is rarely visible until you measure it.
How many hours per week does your finance team spend on manual data entry, reconciliation, and report building? How many decisions are delayed because someone needs to "update the spreadsheet" before the numbers are available? How many errors have you caught - and how many have you not caught - because a formula broke or a row was deleted or someone was working from yesterday's version?
Now multiply that across every department. Operations. Sales. HR. Procurement. Every function has its own spreadsheets, its own workarounds, its own fragile processes that keep the lights on.
The total cost is not just the hours. It is the decisions that are made too late, with incomplete data, by people who do not trust the numbers they are looking at. It is the margin you are leaking because nobody can see it in real time. It is the talent you are burning by asking skilled people to do data entry.
Spreadsheets are a symptom. The disease is disconnected systems.
Here is the part that most technology vendors will not tell you: the spreadsheet is not the problem. The spreadsheet is a perfectly rational response to a real problem, which is that your systems do not talk to each other and your processes have gaps. It is a data and systems integration failure showing up as a file on someone's desktop.
If your ERP cannot produce the report your COO needs, someone builds a spreadsheet. If your CRM and your finance system disagree on revenue numbers, someone builds a reconciliation spreadsheet. If your order process has a manual step between two systems, someone builds a tracking spreadsheet.
The spreadsheet exists because the operation demands it. Removing the spreadsheet without addressing the underlying gap just creates a new gap.
What actually fixes this
The answer is not "buy better software." You have tried that, and the spreadsheets persisted because the new software had its own gaps.
The answer is integration and business automation at the process level. Connect the systems so that data flows between them without manual intervention. Automate the handoffs that currently require someone to copy data from one place to another. Build reporting layers that pull from live, connected data instead of static exports.
This is not a massive transformation programme. It is targeted, practical work that addresses specific pain points:
Identify the five most critical spreadsheets in your business. For each one, map the data sources, the process it supports, and the decisions it informs. Then replace each one with an automated workflow that does the same thing - faster, with fewer errors, and without depending on a specific person.
You will not eliminate spreadsheets entirely. Nor should you - they are excellent tools for ad hoc analysis and exploration. But they should not be infrastructure. They should not be the thing standing between your business and reliable, timely information.
The competitive gap
Here is what makes this urgent: your competitors are doing this work. Not all of them, and not all at once, but the ones that are pulling ahead are the ones that have moved their operations off spreadsheets and onto structured, automated, connected systems.
They are making faster decisions because they have real-time data. They are making better decisions because they trust the numbers. They are running leaner because they are not paying skilled people to do data entry. And they are ready for AI - because their data is actually structured enough to use it.
You are not behind because you lack technology. You are behind because your operations still run on files that live on someone's desktop.
Fix the spreadsheet problem. Everything else follows.


