Almost every business we speak to has one. The spreadsheet. It started as a simple list of customers or jobs, and over the years it grew tabs, colour codes, formulas nobody dares touch and a column called “notes 2 (use this one)”. At some point that business spreadsheet stops being a tool and starts being a risk.
Spreadsheets are brilliant. They’re flexible, cheap and everyone knows roughly how to use them. The trouble is that the same flexibility that makes them easy to start with makes them fragile once a business depends on them. There’s rarely a single moment when a spreadsheet breaks. It just gets slightly worse every month until one day it costs you a customer, a payment or a very long weekend.
January is a good time to take an honest look. Here are the warning signs, and a sensible way to decide what to do about them.
The warning signs of a failing business spreadsheet
You don’t need all of these to have a problem. Two or three is usually enough to justify a proper look.
- Only one person really understands it. If they’re off sick or they leave, the business slows down or stops. That’s a single point of failure dressed up as a file.
- There are several versions. “Jobs FINAL”, “Jobs FINAL v2” and a copy on someone’s laptop. Nobody is quite sure which one is right.
- People are overwriting each other. Two staff edit the same row, and one set of changes disappears without anyone noticing.
- You copy the same data into other places. Customer details typed into the spreadsheet, then again into the invoicing software, then again into an email. Every copy is a chance for a typo.
- It’s slow or it crashes. Large files with lots of lookups become sluggish, and people start avoiding it.
- You can’t answer simple questions quickly. “How many quotes did we send last quarter and how many turned into work?” shouldn’t take an afternoon.
- It holds personal data with no real controls. Customer names, addresses and phone numbers in a file that anyone can download, forward or leave on a train.
Why this matters more than it looks
The obvious cost is time. Staff spend hours checking, reconciling and fixing. But the less obvious costs are usually bigger.
Errors slip through. A formula gets dragged down one row too few and a batch of invoices goes out wrong. A follow-up date is in a column nobody filters on, so a warm lead goes cold. None of these are dramatic on their own, but they add up.
There’s also a data protection angle. Under UK GDPR you’re expected to keep personal data secure and to be able to find, correct or delete someone’s information if they ask. That’s much harder when the same person’s details live in four files and an inbox. We’re not lawyers, and if you hold sensitive data you should take proper advice, but it’s worth knowing that “it’s just a spreadsheet” isn’t a defence.
A spreadsheet isn’t the problem. A business spreadsheet doing the job of a system, without any of a system’s safeguards, is.
What to do before you replace anything
The instinct is to go shopping for software. Hold off for a couple of weeks and do some groundwork first. It’ll save you from buying the wrong thing.
- Write down what the business spreadsheet actually does. Not what it was meant to do. List every job it performs: tracking enquiries, scheduling work, calculating prices, chasing payments.
- List who uses it and why. Different people often use the same file for completely different purposes. That’s useful to know.
- Mark the pain points. Where do mistakes happen? Where do people waste time? Where are you nervous?
- Separate the data from the process. Some of what’s in there is information (customers, jobs, prices). Some is workflow (what happens next and who does it). A new system has to handle both.
- Back it up properly today. Whatever you decide, make sure there’s a dated copy stored somewhere safe, away from the working file.
Your options, roughly in order of effort
Not every spreadsheet needs to be replaced with custom software. Often the right move is smaller.
- Tidy it up. Move to a shared, cloud-based version with proper permissions and version history. Lock the formula cells. Delete old tabs. Sometimes that buys you another year or two.
- Move to an off-the-shelf tool. If your spreadsheet is essentially a CRM, a job tracker or a booking system, there’s probably a well-made product that does the same thing with fewer risks.
- Connect what you already have. If the main pain is retyping data, an integration between your existing tools might solve it without replacing anything.
- Build something specific. If your process is genuinely unusual and it’s central to how you make money, a custom system can make sense. It’s a bigger commitment, so it should come after the other options have been ruled out, not before.
A simple test to run this week
Ask the person who knows the business spreadsheet best to take a day off, and see what happens. If everyone else copes, you’re probably fine for now. If the phone starts ringing with questions, you’ve found your answer.
Less drastically, ask two members of staff to answer the same question from the spreadsheet separately. If they come back with different numbers, the file has stopped being a reliable source of truth.
Where we can help
If you’ve read this and recognised your own business, the next step is a conversation about what your business spreadsheet is really doing for you. Sometimes that ends with a tidy-up and a couple of automations. Sometimes it ends with a proper system. Our digital transformation work starts exactly there, with the process rather than the software, and if a bespoke tool is the right answer, we cover that through custom development.
