Picture the owner of a five-truck HVAC company and his scheduling spreadsheet. Forty tabs. Color-coded in a system only he understands. He built it over six years, and it runs the whole business: who’s on what job, which parts got ordered, what got billed. He’s proud of it, and he should be. Then he says the thing owners say all the time. “I think I need an app. Everybody keeps telling me I’ve outgrown this.”
A lot of the time the honest answer is no. Not yet. A case like that needs two automations and a cleanup, maybe four grand of work, not a forty-thousand-dollar custom system. But people want permission to buy the big thing.
Here’s the part most owners don’t want to hear: the spreadsheet-versus-app question has a right answer for your specific situation, and it depends entirely on the job in front of you. The skill isn’t building the biggest thing. It’s building at the right height.
Think about how you’d reach something up high. To change a lightbulb you grab a step stool. For a second-story gutter you get the extension ladder out of the garage. To re-side the whole house you rent scaffolding, and you don’t think twice about the cost because you’re going to be up there for three weeks and falling off a ladder forty times a day is how people get hurt.
Nobody rents scaffolding to change a lightbulb. And nobody tries to redo the siding from a step stool, leaning out sideways, telling themselves it’s fine.
Software is the same. A spreadsheet is the step stool. It’s right there, it’s cheap, you already know how to use it, and for a huge number of jobs it’s genuinely the correct tool. An automation layer on top of the spreadsheet is the extension ladder, more reach, still familiar, gets you to most second-story problems. A full custom app is the scaffolding. It costs real money and it takes real time, and when the job is big enough, it’s the only safe way to work.
Most business owners get the height wrong in both directions. That’s the mistake, in one sentence. They stand on the step stool way too long, leaning further and further out, or they rent scaffolding to do something a ladder would’ve handled in an afternoon.
When the spreadsheet is still the right tool
I will defend the humble spreadsheet against almost anyone. It is the most underrated business software ever made, and a lot of “we need an app” conversations should end with “actually your sheet is fine, let’s make it a little smarter.”
You’re probably still in step-stool territory if:
- One or two people touch the file, and rarely at the same time.
- The volume is low. Dozens of rows a week, not thousands.
- The logic is simple enough that you could explain it to a new hire in ten minutes.
- You can live with a few manual steps. Copy this here, send that email, update the tab on Fridays.
- When something breaks, it’s annoying, not dangerous. Nobody misses a payment or a shift because a formula hiccuped.
If that’s you, a custom app is a waste of money and, worse, a maintenance burden you’ll resent. Software you own is a thing you have to keep alive. Every app needs occasional care the way a truck needs oil changes. If a spreadsheet does the job, paying to build and maintain an app is like buying a forklift to move one box a month. Impressive, and mostly in the way.
When you’ve outgrown it (and patching it again is the expensive mistake)
Then there’s the other side, and this is where the costly mistakes hide. Because outgrowing a spreadsheet doesn’t announce itself. There’s no alarm. It just gets a little worse every month until one day the file is running your business and you’re afraid of it.
Here are the signals I trust. Any two of these together, and it’s time to talk about real software:
- People step on each other. Two staff overwrite each other’s edits, or you’re emailing versions around with “final_v3_USE THIS ONE” in the name.
- The same errors keep coming back. You fix it, it returns. That’s not carelessness, that’s a structural limit. The tool can’t enforce the rule you need.
- You’re scared to touch it. When changing a column feels like defusing a bomb, the spreadsheet has become load-bearing and brittle at the same time.
- It holds money or schedules. If a broken formula means a missed invoice, a double-booked job, or a payroll error, you’re working off a step stool over concrete.
- Other people need to interact with it. The second your customers or your field staff need to put data in or get data out, a shared spreadsheet stops being a tool and starts being a liability.
- It breaks when one person is out. If the file only really works when Sharon’s at her desk, the business doesn’t own a system. It rents Sharon’s memory.
When several of those are true, patching the sheet one more time is the expensive choice, even though it has the smaller invoice. You’re paying to stay on the step stool. A real app, a client portal, a progressive web app your team can actually use on a phone in the field, that’s the scaffolding. It costs more up front and it’s the cheaper answer over three years.
The middle most people skip
Here’s what gets lost in the spreadsheet-or-app framing: there’s a lot of ground in the middle, and it’s where some of the best money gets spent.
You can keep the spreadsheet and bolt real automation onto it. The form that feeds it cleanly so nobody fat-fingers a row. The script that sends the follow-up email the second a status changes. The nightly job that reconciles two systems so Sharon doesn’t spend her Monday doing it by hand. That’s the extension ladder. You get most of the reach of an app without the cost or the upkeep of one, and for a real share of the businesses I talk to, it’s exactly the right altitude.
The honest version of this conversation sounds boring, and that’s how you know it’s honest. Sometimes the answer is “your sheet’s fine, here are two automations.” Sometimes it’s “you genuinely need to build the thing.” The trick is having someone in the room who’ll tell you which, and who isn’t paid more for talking you into the bigger one.
That last part matters more than the technology. If the person advising you only makes money when you build scaffolding, every problem is going to look like a re-siding job. I’d rather sell you a step stool that fits, have it work, and have you call me in two years when you’ve actually outgrown it. You will know when you’ve outgrown it. The signs above don’t lie.
If you’re staring at a file that’s started to feel load-bearing and you’re not sure whether it needs a couple of automations or a real app, that’s the conversation we like having. No pitch for the biggest thing, just an honest read on the right height for the job. You can grab a time at https://app.allenapptools.com/book.
