Back to the journal

The spreadsheet is not the problem

Before replacing a spreadsheet, understand the work it has been holding together. The problem is usually the handoff around it.

A spreadsheet is often the clearest record of what a business actually needs. Someone built it because the official system could not answer a practical question.

The trouble begins when that spreadsheet becomes the place where responsibility disappears. One person exports the data. Another corrects it. A third emails the result. Nobody can explain which copy the customer received.

Start with one handoff

Choose a recurring process: a quote becoming an order, an order becoming a delivery, or a delivery becoming an invoice. Follow a real record from beginning to end. Write down every system, every owner, and every time someone copies information by hand.

Ask three questions at each step:

  • Who owns the next action?
  • What information do they need to act?
  • How does the business know that the action happened?

If the answers change depending on who is in the room, buying another tool will not settle them.

Make the work explicit

Agree on the record that each system owns. Give every handoff a clear trigger and a visible status. Keep exceptions visible instead of forcing employees to work around them quietly.

Then decide what to build, what to connect, and what to leave alone. Duct tape becomes infrastructure when the business stops depending on people remembering what comes next.

Further reading.

All essays