Almost every business I’ve worked with runs something important on a spreadsheet. Not because anyone decided to — it just happened. A quick tracker became the source of truth, then three people depended on it, and now it’s load-bearing.
Spreadsheets are fantastic. They’re also a database in disguise, and disguises slip. Here’s how to tell when yours has crossed the line.
The warning signs
- The “don’t touch this tab” tab. When a workbook has cells nobody dares edit because something downstream will break, it’s stopped being a spreadsheet and started being software — just without tests or version control.
- Copy-paste as a process. If your month-end involves duplicating last month’s file and pasting fresh data into the right place, every step is a chance for a silent error.
- Two people, one file. The moment more than one person needs to edit at the same time, you’re managing merge conflicts by hand and email.
- Formulas referencing formulas referencing formulas. Depth is fine until you need to find out why a number is wrong, and the trail runs ten cells deep across four tabs.
None of these mean the spreadsheet is bad. They mean it’s succeeding — it’s doing a real job — and the job has outgrown the tool.
What to do about it
You don’t have to leap to a custom application. The useful middle ground is to treat the data and the presentation as separate things.
- Get the data somewhere structured. Even a single well-formed table — one row per record, consistent columns, no merged cells — is most of the battle. That’s a database, conceptually, even if it still lives in a sheet.
- Keep formulas out of the data. Raw facts in one place, calculations in another. When inputs and logic are tangled, you can’t change either safely.
- Make the risky steps repeatable. The copy-paste ritual is exactly the thing worth automating first, because it’s where errors hide.
The honest take
I’m not anti-spreadsheet — I live in them. The point isn’t to abandon the grid; it’s to notice when it has quietly become your database and to give it the structure that a database would have demanded from day one. A spreadsheet that knows it’s a database is a much safer place to keep the numbers a business depends on.