How to replace spreadsheets with custom software (without stopping the business)

Signs a spreadsheet has become a system

• —More than one person edits it, and they keep separate copies.
• —Decisions about money, stock or customers are made from it.
• —It has formulas only one person understands.
• —Data is copied into it from other systems, and out of it into others.
• —Someone has lost a morning to a broken link or an overwritten cell.

Step 1: document what the sheet really does

Sit with the people who use it. Write down every column, formula, colour code and habit, such as “we mark red when the customer has called twice”. Those unwritten rules are the real requirements, and they are what a rushed replacement forgets.

Step 2: build the same job first, better second

The first version of the tool should do what the spreadsheet does, with the obvious fixes: one shared record instead of copies, validation instead of free text, a log of who changed what. Resist redesigning the whole process on day one; trust comes from familiarity.

Step 3: run both side by side

For a short, agreed period, work in the new tool and compare its results with the sheet. Differences reveal rules nobody mentioned. Fix them, and stop the parallel run once the two agree for a full cycle, such as a week of orders or a month-end.

Step 4: move the data and retire the sheet

• —Import historical data once both versions agree, and check totals against the original.
• —Make the spreadsheet read-only, then archive it.
• —Keep a one-click export from the new tool, so the data is never trapped.

Then improve the process

With the tool trusted, connect it to the systems around it so data stops being copied in and out, automate the repetitive steps, and give managers the live view the spreadsheet never could. This is where most of the time savings appear.