When your Excel workbook has quietly become a system
A spreadsheet that five people depend on is already software. Here is how to tell when it is time to replace it, and what to keep.
Published · 4 min read
Most business systems begin as a spreadsheet. That is not a mistake: it is the fastest way to find out what you actually need. The trouble starts when the workbook becomes load-bearing.
Signs the workbook has become a system
- Only one person understands the formulas, and everyone is nervous when they are on leave.
- Several copies circulate, and someone always asks which one is current.
- People re-type the same data into other tools, or paste figures into emails.
- Approvals happen over chat, and nobody can show who changed what.
- Finding last month's numbers means opening a folder of files named final, final2 and really-final.
What a small app changes
A small purpose-built application keeps the part of the spreadsheet people like, which is fast entry and a familiar table, and removes the fragile parts: one shared copy, entry rules that stop bad data, roles for who may edit or approve, and a history of changes.
It does not need to be an ERP. Often it is one screen for entering data, one for approving it, and one report. Starting there is cheaper, finishes sooner and teaches you what the bigger system should do.
What to keep
Keep the Excel import and export. Your accountant, your auditor and your own habits will still want a spreadsheet at the end of the month, and a good system makes that a button rather than a project.
A simple test
Ask what happens if the file is lost or the one expert leaves. If the answer is a pause in the business, the workbook is already a system, and it deserves the controls of one.