← All insights

Almost every small business I look at has a spreadsheet somewhere near the centre of it. It started as a sensible solution to a real problem. Someone needed to track something, Excel was already open, and it worked.

Then somebody added a tab. Then formulas. Then colour coding that means something to two people. Then a second version, because one person needed to work on it while somebody else had it open. Nobody decided any of this. It accumulated, the way processes do.

The spreadsheet did not fail. It succeeded so thoroughly that the business quietly started depending on it.

Seven signs you have outgrown it

1. There is more than one version

Someone keeps a local copy. Someone emails an updated one round. Somebody has a version with their own extra column. The moment two copies exist, they begin to diverge, and from then on you do not have a record. You have competing claims.

2. The same information is entered more than once

A customer detail goes into the spreadsheet and also into your accounts package, or your email, or a second sheet. The typing is the cheap part. The expensive part arrives when one copy is updated and the other is not.

3. Reports take hours to assemble

If somebody spends half a day each month filtering, copying and reformatting to produce the same numbers as last month, you are paying for that repeatedly. Reporting is the clearest signal because the cost is so easy to measure.

4. One person understands how it works

Ask what happens if that person is unreachable for two weeks. If the honest answer involves things waiting, the spreadsheet is not a business system. It is one employee's knowledge with a file extension.

5. Formulas break and nobody notices immediately

A row gets inserted in the wrong place, a range shifts, and the total is quietly wrong for a fortnight. Spreadsheets have no concept of validation and no audit trail, so errors are silent by design.

6. You cannot tell who changed what

When a number looks wrong, the investigation is a conversation rather than a lookup. In a business of two people that is manageable. At ten it is a recurring tax on everyone's week.

7. People have built workarounds around it

Someone keeps a notebook because the sheet does not have a field for the thing they need. Someone rings ahead because the sheet does not notify anyone. Those workarounds are the clearest evidence that the tool no longer fits the job.

What to do instead

The instinct is to go looking for software. Resist that for one more step, because the most useful question comes first.

Separate what it does from what people think it does

Most business spreadsheets are quietly doing three or four unrelated jobs at once: storing records, tracking status, calculating something, and producing a report. Those need different answers. Written down separately, the requirement usually shrinks considerably.

Fix the free things first

A single agreed authoritative copy, stored somewhere shared rather than emailed. One named owner. Deleting the tab nobody has opened in a year. None of that costs anything and it often removes a third of the pain.

Then match the tool to the job

Sometimes the answer is a database-style tool where each record is a row with proper fields. Sometimes it is configuring something you already pay for and do not fully use. Sometimes it is a small custom workflow. The point is that you now know what you are asking for, which turns a vague evaluation into a specific one.

When Excel is still the right answer

This matters, because replacing a spreadsheet that was working is a good way to spend money and make things worse.

• One-off analysis. Nothing beats it for pulling data apart to answer a question once.
• Modelling and forecasting. Scenarios, projections, anything where the structure changes as you think.
• One person, one job, no handovers. If nobody else needs it and nothing depends on it, leave it alone.
• Genuinely temporary. A tracker for a project ending in six weeks does not need a system.

The distinction is not spreadsheet versus software. It is whether the file has quietly become the system of record for a process involving several people. That is the point at which Excel is being asked to do something it was never designed for.

How to decide

Count the instances and put rough numbers on them. How many times a week does someone reconcile versions, and for how long? How long does the monthly report take? How often does a mistake reach a customer?

Multiply by 46 working weeks and a loaded hourly cost of somewhere between €25 and €55, which is realistic for most Irish SMEs once employer costs and overhead are counted. That figure is what you are comparing against the cost of changing something. Crude arithmetic is fine. Precision does not change the decision.