How to turn a spreadsheet into real software

Almost every business I have worked in runs on at least one spreadsheet that has outgrown itself. It started as a list. It is now the system of record, and one person is quietly afraid of it.

The signs it has stopped being a spreadsheet

Three or more of those, and it is no longer a spreadsheet. It is software with no safety rails, maintained by someone whose job is something else.

• Only one person can safely edit it, and everyone knows who
• It has rules that are not written anywhere — "column H stays empty unless it is a renewal"
• Two versions exist, both edited, and merging them is somebody's afternoon
• You keep a copy before making changes, because you have been burned
• Somebody asks "how are we doing" and the answer takes an afternoon to assemble
• A mistake in it would cost real money, and nothing stops that mistake

What changes when it becomes an application

• The rules are enforced instead of remembered — the form will not accept the impossible thing
• Several people can work at once without a merge
• History: what changed, when, and who changed it
• Access levels, so not everyone can see or edit everything
• The questions you ask constantly become a screen instead of an afternoon
• And it still exports to a spreadsheet, because sometimes that genuinely is the right answer

Do not start by rebuilding it

The instinct is to recreate every column. That is how these projects get expensive and get abandoned.

Start with the part that hurts — usually one process, one report, one recurring mistake. Build that. Let the spreadsheet keep doing everything else until it is obvious what should move next.

I have watched more of these fail from scope than from technology.

When to leave it alone

If one person edits it, the rules live in their head and that works, and a mistake would be annoying rather than expensive — leave it. A spreadsheet that works is not a problem waiting to be solved.

The moment it needs a second editor, or a rule nobody can enforce, or the mistake would cost real money, it has crossed a line.