The spreadsheet that runs your business (and when to worry)

Every business I’ve ever worked with has one: the spreadsheet. Not a spreadsheet — the one. The one that quotes the jobs, or schedules the crew, or tracks every order since 2019. The one that only Sandra really understands.

I want to be fair to spreadsheets, because they’re genuinely great, and half the industry writes this article as a scare piece to sell software. So let’s do both halves honestly: when the spreadsheet is fine, and the five signs it has quietly become a problem.

When the spreadsheet is fine

If one person updates it, a handful of people read it, nothing else depends on it, and losing an afternoon’s work to a bad paste would be annoying rather than catastrophic — keep the spreadsheet. Sincerely. A spreadsheet you understand beats software you don’t, and nobody should pay to replace a thing that works.

The five signs it’s not fine anymore

1. It has an owner instead of users. When one person is the only one who can safely touch it, you don’t have a spreadsheet, you have a single point of failure with a vacation schedule. Ask what happens the week that person is away. If the answer involves the word “wait,” that’s your answer.

2. There are copies. quotes_2026_FINAL_v3_use_this_one.xlsx is a joke until two people quote the same customer different prices from different versions. Version sprawl means the spreadsheet is being asked to do multi-user work, and that’s the one thing it fundamentally can’t.

3. Someone re-types data that already exists. Orders copied from email into the sheet, then from the sheet into the accounting package. Every hop is somebody’s time plus a chance to fat-finger a number. This is usually the single most automatable task in the whole business — the practical AI post and half my custom software work are aimed at exactly it.

4. It broke once, and everyone remembers. A deleted column, a sort that scrambled rows, a formula quietly wrong for a month. If a spreadsheet accident has ever cost you real money or a real customer, you already know the risk — you’ve just been hoping it’s rare.

5. You’ve started wishing for permissions. The moment you want the crew to see the schedule but not edit the prices, you’re describing software with user roles. The spreadsheet can’t hear you.

What replacing one actually looks like

Smaller than you’d think. The replacement for the quoting sheet isn’t “an ERP” — it’s a quoting tool. It does what the sheet did, minus the copies, the re-typing, and the fear of sorting. Your data comes with you. This is the classic small first project: weeks, not months, and low thousands, not enterprise money — the tier that only recently became viable for small businesses at all.

Count the signs on your worst spreadsheet. Zero or one: carry on, honestly. Two or more: tell me what the sheet does, and I’ll tell you what replacing it would actually involve — or whether you’re in the keep-it camp after all.