Spreadsheets are not the problem

For a lot of what SMEs do, a good spreadsheet is the right tool. This is how to tell when yours has quietly become a liability.

Spreadsheets get a bad reputation they mostly do not deserve. For a huge amount of what small and medium businesses do, a well built spreadsheet is the right tool: it is cheap, everyone understands it, and it can be changed in seconds without asking anyone's permission.

We have talked plenty of businesses out of a new system they did not need. A quote tracker, a simple stock list, a booking sheet for a handful of vehicles: these often work perfectly well in a spreadsheet for years. The problem is not the spreadsheet. The problem is not noticing when it has quietly outgrown itself.

When a spreadsheet is genuinely fine

One person maintains it, or a very small team who sit close enough to talk. The numbers are not the kind that end anyone up in court if a formula is wrong. And the sheet is small enough that a person can eyeball it and tell when something looks off.

If that describes what you have, leave it alone. Replacing a working spreadsheet with software is a common way to spend money making a solved problem worse.

Sign one: more than one person needs it at the same time

The moment two people are editing the same file, you start getting versions. Someone emails a copy, someone else keeps working on the original, and by Thursday nobody is sure which sheet is real. Shared cloud spreadsheets soften this but do not remove it, because they still let anyone overwrite anything.

When you hear the phrase "which version are you looking at" more than once a week, the spreadsheet has become a coordination cost, not a coordination tool.

Sign two: the data feeds something important

A spreadsheet that one person reads is low risk. A spreadsheet that decides what you invoice, what you order, or what you report to a regulator is a different thing. A single mistyped cell or a formula that stopped copying down can now cost real money before anyone notices.

This is common in construction, trades and care providers, where a job-costing or rostering sheet grows year on year until the whole business quietly depends on a file one person understands.

Sign three: only one person can safely touch it

If there is a sheet in your business that everyone is a little afraid to edit, that is the clearest signal of all. It usually means the logic has grown complicated enough that a wrong move breaks something downstream, and nobody has documented what.

The risk here is not efficiency, it is continuity. When the person who built it is on leave, or leaves for good, the knowledge leaves with them.

What to do about it

You do not have to jump straight to custom software. Often the next step is a shared database or a simple business tool that keeps the parts a spreadsheet is bad at, many people editing at once, a permanent record, controlled access, and keeps the flexibility where you still want it. The trigger to move is not the size of the file. It is the size of what depends on it.