Spreadsheet or Software? When a Simple File Beats a SaaS Subscription

A practical framework for deciding whether to build it in a spreadsheet or buy the software — including the four situations where a spreadsheet is the wrong answer.

Published 2026-07-20 · 3 min read

There is a reflex in small business that says spreadsheets are what you use before you can afford real software. Get serious, buy the platform, graduate from Excel.

Sometimes that is right. Often it is expensive nonsense. This article is a framework for telling which.

The two costs nobody compares properly

When people compare a spreadsheet to software, they compare zero dollars against the subscription price. That is not the real comparison.

A spreadsheet costs time. Time to build, time to maintain, time to fix when a formula breaks. If building takes six hours and you value your time at fifty dollars an hour, that is three hundred dollars — plus perhaps an hour a month keeping it working.

Software costs money and flexibility. The subscription, plus onboarding time, plus the ongoing cost of working the way the software wants you to work rather than the way your business actually works.

The honest comparison is time plus constraint against money plus constraint. Not free against paid.

Four questions that decide it

How many records will this hold?

Under a thousand, a spreadsheet is comfortable. One to ten thousand, it works but gets slow and fragile. Above ten thousand, use a database or software built on one. Spreadsheets are not designed for that volume and will eventually corrupt or crawl.

How many people need to edit at once?

One person, spreadsheet wins easily. Two or three, Google Sheets handles it. Four or more editing simultaneously, buy software — simultaneous editing in a spreadsheet produces conflicts and lost work.

Does anything need to happen automatically?

Recording what you enter is a spreadsheet job. Sending an email when a status changes, syncing with your accounting system, alerting someone at 2am — those need software. Automation is the clearest dividing line.

How often will the process change?

Frequently changing processes favour spreadsheets, because you can restructure a sheet in twenty minutes. Software takes a support ticket, a feature request, or an admin who knows the system.

Where a spreadsheet is genuinely the better tool

Anything involving calculation you want to see. Pricing models, margin analysis, quotes with variable components, forecasts. Software hides the formula behind an interface. A spreadsheet shows the working, which matters when you need to justify a number.

Processes unique to your business. The reason no software fits is usually that your process is genuinely unusual. A spreadsheet bends to that. Software makes you bend instead.

Anything you need to hand to someone else. A spreadsheet opens anywhere. Access to your project management platform does not.

Low-frequency, high-value work. If something happens six times a year but each instance matters enormously, a subscription is poor value. Build it once.

Where a spreadsheet is the wrong answer

Anything with a compliance requirement. Payroll, tax records, regulated client data. You need audit trails, permissions and backups that survive a laptop failure. Do not build that yourself.

Anything customer-facing. A booking system, a client portal, an online form. Customers should never be sent a spreadsheet.

Anything requiring real-time sync across locations. Multiple sites updating shared stock levels, for instance. Spreadsheets will fight you and you will lose data.

Anything where an error is catastrophic. A wrong formula in a pricing sheet costs you margin on a job. A wrong formula in a medication schedule is a different category of problem entirely.

The hybrid most businesses end up with

In practice the answer is rarely all one thing.

Buy software for accounting — the compliance requirement settles it. Buy software for anything customers touch. Buy software for payroll.

Build spreadsheets for pricing models, for project tracking, for stock, for planning, for anything where you need to see the calculation, and for anything specific to how you work.

That split costs a fraction of subscribing to a platform for every function, and you keep control where control matters.

A test worth applying

Before buying software, describe exactly what you need it to do in one paragraph. Then ask: could this be a well-built spreadsheet?

If you cannot answer confidently, you probably do not understand the requirement well enough to buy software yet. Build the spreadsheet version first. Use it for two months. You will then know precisely what the software needs to do, which makes you a far better buyer.

That two months costs you almost nothing and often reveals that the spreadsheet was sufficient. When it does not, you upgrade knowing exactly why — which is a much stronger position than subscribing hopefully.