Skip to content
← All field notes

Thinking

Getting off spreadsheets won't fix this

The case against your spreadsheets is usually the wrong case. The data structure problem existed before the first cell was filled in, and it will survive the replacement if you build to the same brief.

5 min readBy Javier Bates · Founder
A spreadsheet open on a monitor, columns of data visible

The right complaint, the wrong diagnosis

When someone tells you to get off spreadsheets, they are usually right that something needs to change. They are usually wrong about what it is.

The spreadsheet is not the source of the problem. It is where the problem became visible. Your data is unstructured — it can be edited by anyone, in any format, in any order. Your logic is undocumented — it lives in formulas someone wrote eighteen months ago and in the head of the person who runs the process each week. And when something goes wrong — a mistyped entry, a formula referencing the wrong column, a row pasted into the wrong place — it does not announce itself. It propagates quietly until the output is wrong, and the person reviewing it catches it, if they catch it.

That is a real problem. But it is not a spreadsheet problem.

What the spreadsheet is actually doing

The spreadsheet works. That is worth acknowledging before anything else. It handles real data, supports real decisions, and has been doing so reliably enough that the business runs on it. The people who use it understand it. It is flexible, fast to modify, and requires no IT budget to keep running.

What it does not do is protect the data from the person using it. There is no validation at the point of entry — nothing that stops a number being entered where a date should go, or a row being deleted because it looked like a duplicate. The integrity of the data depends on the discipline of the person entering it. That is a fragile guarantee, not because people are careless, but because humans make small errors in repetitive work, every time, without exception.

The spreadsheet is also not legible to anyone who was not there when it was built. The logic is in the formulas, the column names are abbreviations that made sense in 2022, and the one person who knows how it all fits together is often the only person who runs it. That is not a spreadsheet problem. It is a documentation and ownership problem that the spreadsheet makes visible.

What the wrong replacement looks like

The wrong fix is to audit the spreadsheet and build a system that does the same thing.

Someone sits down with the spreadsheet, maps out what each column does, and builds an application that captures the same fields. It replicates the structure — the same inputs, the same outputs, the same sequence of steps — in a database-backed interface that looks more professional. The demo looks clean. The handover happens. The team moves in.

Three months later, the team is frustrated. The system does not fit how they actually work. There are steps in the workflow that the replacement handles in the wrong order, or handles in a way that adds friction to a part of the process that used to take thirty seconds. The human-judgement steps — the ones that genuinely require someone to look at something and decide — are buried behind form fields and validation rules that slow things down without improving the outcome.

They miss the spreadsheet. Not because the spreadsheet was better. Because the replacement was built to the shape of the spreadsheet, not to the shape of the work.

The replacement was built to the shape of the spreadsheet, not to the shape of the work.

The question that reframes it

Before any replacement is scoped, there is one question worth asking: can we do this work faster and better?

Not "is this more scalable." Not "is this enterprise-ready." Faster and better — for the people doing the work, in the specific steps where time and accuracy actually matter.

That question forces a different kind of investigation. You have to sit with the process, not just audit the spreadsheet. Which steps take the longest? Where does information get lost or need to be looked up from somewhere else? Where does someone have to make a call that requires their experience, and where are they doing something mechanical that a system could handle without them? Where do errors currently hide, and what would catch them earlier?

You also have to ask what the person doing the work actually needs to know at each step. Not what data the process generates — what the person needs to see to make a good decision. Those are different questions, and the gap between them is where most replacements go wrong.

What a good replacement actually solves

A system built from that investigation looks different from a system built from a spreadsheet audit.

It handles the mechanical steps automatically. It validates data at entry rather than hoping for accuracy down the line. It surfaces the right information when a person needs to make a decision, not everything the system holds. The steps that require judgement are supported rather than buried. Errors that used to propagate silently get caught before they compound.

That is not a modernisation. It is an improvement. The distinction matters, because one has a concrete answer — yes, this lets us do faster and better work — and the other has a homepage and a demo.

One question worth asking

The next time someone tells you to get off spreadsheets, ask them what specifically will be better when you do.

Not "more robust." Not "more scalable." Better how, for whom, and in which part of the process?

If they can answer that, there is probably a real conversation to have. If they cannot, they are solving for the tool, not the work — and the replacement will inherit the same problem with a different interface.