The short answer: replace it when it has stopped being a spreadsheet and become a system. The signs are consistent: several people depend on it, one person really understands it, its mistakes cost real money, and data gets copied into and out of it by hand every week. If two or more of those are true, the spreadsheet is running part of your business without any of the safeguards a system should have.

Almost every business we meet has one. A workbook that started as a convenience and now quotes jobs, tracks inventory or schedules people — held together by someone who knows which tabs not to touch.

Spreadsheets Are Not the Problem

Spreadsheets are one of the best tools ever made for figuring something out. The trouble starts when the figuring out is finished and the spreadsheet keeps running the result. At that point it is doing a system’s job with a calculator’s protections: anyone can overwrite a formula, nothing records who changed what, and the logic lives in cells nobody has read in years.

Five signs a spreadsheet has become a system:

  • One person is irreplaceable. If they are on holiday, the work waits.
  • Copy and paste is a weekly ritual. Data moves in and out by hand, from email, exports or other files.
  • There are “final_v3_REAL” copies. Nobody is sure which version is current.
  • Mistakes have cost money. A wrong price, a missed order, a double booking traced back to a cell.
  • More than one person edits it at once, and someone has lost work because of it.

Your Three Options

1. Tidy the spreadsheet. Often overlooked and often enough. Convert ranges into proper tables, add data validation so people cannot type nonsense, lock the formula cells, and keep one shared copy instead of emailed versions. This is cheap and buys real time.

2. Move to off-the-shelf software. If the spreadsheet does something common — job scheduling, inventory, a sales pipeline — there is probably software built for exactly that. The catch is fit: if your business does it differently, you will either change your process to match the software or start keeping a spreadsheet alongside it again.

3. Build a small custom tool. When the spreadsheet encodes how your business works and nothing off the shelf matches, a purpose-built tool can keep the same logic while removing the fragility: proper permissions, a history of changes, data that flows in automatically, and nobody able to break a formula by accident.

Have a spreadsheet everyone is afraid to touch?

Bring it to the free thirty-minute review below. We will tell you honestly which of the three options fits — and if tidying it up is enough, we will say so.

Book the free review or read what this kind of work costs

How To Replace One Without Breaking Anything

The risk in replacing a business-critical spreadsheet is not the new tool. It is the rules nobody wrote down. Over the years, the spreadsheet has picked up exceptions — a discount for one client, a rounding rule, a column someone checks by eye before sending. Miss one and the new system is confidently wrong.

Write down every rule first. Go through the spreadsheet with the person who knows it and list what each part does and why. This is often the most valuable step on its own: for the first time, the business has its process on paper.

Run both side by side. For a few weeks, use the new tool and the old spreadsheet together and compare the results. Every difference is either a bug in the new tool or a rule nobody mentioned.

Switch off the spreadsheet only when the numbers match. Then archive it, rather than deleting it, so the history is still there if anyone needs to check.

A spreadsheet becomes a liability the moment the business depends on it more than anyone understands it.

Want to know what yours would take?

Our projects start with a free thirty-minute call. We look at the spreadsheet and how it is used, and tell you what replacing it would involve — or why you should not bother yet.

Book the free 30-minute review