When is my spreadsheet too much, and what should replace it?

By Ranjit Bhinge, founder of Blur Studio · Updated · 7 min read

Short answer: Your spreadsheet is too much when the business depends on it, a mistake in it costs real money, and more than one person has to touch it at the same time. Score five things from 0 to 3 each (dependence, error cost, handoffs, re-typing and hidden rules). At 0 to 4, keep the spreadsheet and tidy it. At 5 to 8, try a ready-made software subscription or a database-style tool. At 9 or more, or when no subscription fits how you work, build one small custom tool for one process first, not the whole business.

Ranjit Bhinge

You want a clear rule for when the spreadsheet has stopped helping, and a plain idea of what comes next and what it costs.

I'm Ranjit, and I run Blur Studio: 15+ years building software, 120 apps taken live, and clients who have gone on to raise $10M+. I build AI systems and processes that help businesses do a lot more with a lot less time. I also work differently from most of what else is out there, more on that further down this page. Say hello.

Spreadsheets are the right tool far longer than software vendors admit. They are also the cause of a lot of quiet damage when a business grows around them. This guide gives you a scored rule, a way to pilot a replacement on one process, and a plain look at cost against a software subscription (a tool you pay for monthly, often per user). Many software agencies will tell you to always build. I will not, and you will see why.

Signs a spreadsheet is the problem

These are the signs I look for. One or two is normal. Five or six means trouble.

  • One person "owns" the file and everyone is afraid of them being away.
  • Two people edit at once and one overwrites the other, or there are files called "final_v3_USE-THIS."
  • You re-type the same data in a second place, such as from a sheet into your invoicing tool. If the re-typing is contracts, generating them from a form or spreadsheet is a cheap first fix.
  • Your job or schedule sheet has become the whole operation, as in the field service spreadsheet that trades often run on.
  • Formulas nobody understands break when a row is added.
  • You cannot answer a simple question ("what is outstanding by customer?") without an hour of work.
  • A customer or staff member needs a view of the data, and you export and email it.
  • The file is slow to open, or you have started splitting it by year or by team.

What research says about spreadsheet errors

Raymond Panko, a researcher who has studied spreadsheet errors for decades, reports on 85 intensive inspection studies of real spreadsheets that took several days each. Collectively they found errors in 94 percent of the spreadsheets. That does not mean every error was serious, and those studies looked at business and tax spreadsheets, not yours. It does mean you should not trust a complex sheet because it looks fine, so I would treat the figure as a warning, not a forecast for your file.

Limits are a second risk. Microsoft's Excel specifications list a maximum of 1,048,576 rows and 16,384 columns per worksheet. Google Sheets allows up to 20 million cells per spreadsheet, according to Google's help page. Most small businesses never reach these. A famous case did. In 2020, Public Health England (the UK government health agency at the time) missed about 16,000 confirmed Covid cases from daily figures because lab results were passed through Excel templates in the old XLS format, which holds about 65,000 rows, roughly 1,400 cases per file, according to an analysis on The Conversation. The author's point was that routing data through spreadsheets added steps that a proper data system would not need. You are not a national health agency, but the lesson is the same: a spreadsheet fails silently.

The scored rule

Score each row from 0 to 3, for one process at a time (for example, "customer jobs" or "stock").

Question0123
Dependence: what happens if the file is lost or wrong for a day?NothingAnnoyingWork stops for someWork stops, money is lost
Error cost: what does one wrong number cost?Under $50$50 to $500$500 to $5,000More, or a legal or safety problem
Handoffs: how many people or systems touch it?Just me23 to 56 or more, or customers
Re-typing: how often is data copied elsewhere?NeverMonthlyWeeklyDaily
Rules: how many "if this, then that" steps live in people's heads?01 to 23 to 56 or more

Add up the five scores (maximum 15):

  • 0 to 4: keep the spreadsheet. Clean it up: one owner, locked formula cells, data validation (drop-down lists instead of free typing), a backup. My guide to turning a spreadsheet into a dashboard without coding may be all you need.
  • 5 to 8: move to a ready-made tool or a database-style tool. See the next sections.
  • 9 to 15: you have outgrown it. Look first for a subscription that fits. If none does, or your rules are unusual, plan a small custom build.

I made the bands from experience, not from a study, so adjust them. The value is in forcing yourself to rate error cost and dependence in dollars, which most people avoid.

The middle step most people skip

Between a sheet and custom software sits a database-style tool. Airtable, for example, is a tool that looks like a spreadsheet but stores linked records, with forms and views. Its pricing page lists a Team plan at $20 per user per month and a Business plan at $45 per user per month, both billed annually, plus a free plan. Prices change, so check the page. If you replace five sheets with linked records, my guide on replacing five spreadsheets with one customer database shows how, and Zapier and its alternatives covers the connectors that join your tools.

Cost: subscription versus custom (worked example, made-up figures)

A subscription is cheap to start and grows with headcount. A custom tool costs more at the start and nothing per user after. Here is the arithmetic for an invented business with 8 staff. The custom figure is a made-up quote for illustration, not a typical price, because real quotes depend on your rules.

Over 3 yearsSubscription, 8 usersCustom, one process
Team plan at $20 per user per month, annual billing8 x $20 x 36 = $5,760Not applicable
Business plan at $45 per user per month8 x $45 x 36 = $12,960Not applicable
Build quote (made-up)$0$12,000 one time
Hosting and upkeep (made-up)Included$100 per month = $3,600
Total$5,760 to $12,960$15,600

In this example the subscription wins on cost unless you double the team to 16 on the higher plan. That is the result in many cases: if a subscription fits, it is cheaper and faster. Custom wins when no subscription fits your process, when per-seat fees multiply across many users, or when you would pay for many features you never use. My guides on custom software development cost and buying versus building go further. Always ask who owns the code you pay for, which I cover in who owns custom software code you paid for.

Pilot one process, not the whole business

The most common way to waste money is to try to replace every sheet at once. Use this path instead:

  1. Pick the process with the highest score from the table above, usually the one where an error costs most.
  2. Write the rules down in plain English. Who enters what, what triggers what, who approves. If you cannot write them, no tool can follow them.
  3. Define "done" for the pilot. One example: "Jobs entered once, invoices created from them, no re-typing."
  4. Run both in parallel for 2 to 4 weeks. Keep the sheet as a check, and compare totals weekly.
  5. Retire the sheet for that process only when totals match for a full cycle, such as a month-end.
  6. Then move the next process. The first one teaches you what you forgot.

I do not give a fixed timeline because it depends on the rules. For ranges, see how long custom software takes to build.

What to ask any vendor or developer

  • Can I export all my data in a normal format at any time?
  • What happens to my data and my tool if you stop trading?
  • What is the price at 5, 10 and 25 users, and what is extra?
  • Who owns the code and the design, in writing?
  • How do I get a fixed price for the pilot, and what is outside it?

Red flags

  • "Replace everything" on day one.
  • No written rules before the build starts.
  • A quote with no end, only an hourly rate.
  • No way to keep your sheet running alongside during the pilot.

Who should not move yet

Keep the spreadsheet if only you use it, if the score is low, or if the process changes every month. A tool built on rules that keep changing is expensive to maintain. Also hold off if nobody in the business will own the new system. Software needs an owner, the same as a sheet does. If you are looking at where else to use technology, AI for small business is a good place to start.

How I'd approach this

I would do the scoring first, on paper, for your top three sheets. Then I would clean the one that scores lowest, because it costs almost nothing. For the highest scorer, I would look for a subscription for a week, with a short list of must-haves written beforehand. If one fits at a fair price, I would take it and not build.

If none fits, I would build only the pilot process, with a fixed price and an exit: you own the code and can take your data out. A small fix or finish on an existing tool starts around $1,500 with me, and a bespoke build costs more, with a fixed price agreed before I start. If a subscription is the right answer, I will tell you on the first call.

Questions people ask

How do I know my spreadsheet has become a problem?

Score it on dependence, error cost, handoffs, re-typing and hidden rules, 0 to 3 each. A total of 9 or more means you have likely outgrown it. Under 5, tidy the sheet instead. See the table above.

Are spreadsheet errors really that common?

Researcher Raymond Panko reports that 85 intensive inspection studies found errors in 94 percent of the spreadsheets examined. Not every error is serious, and the studies covered business and tax spreadsheets, so treat it as a warning, not a forecast for your file.

Is custom software cheaper than a subscription?

Sometimes. A subscription usually costs less to start and grows with the number of users. Custom costs more up front and nothing per user after. Compare a 3-year total, as in the worked example, and read custom software development cost.

What should I try before custom software?

Clean up the sheet, then a database-style tool or a ready-made subscription. Read how to replace five spreadsheets with one customer database.

How big does a spreadsheet get before it breaks?

Excel allows 1,048,576 rows and 16,384 columns per worksheet, and Google Sheets allows up to 20 million cells. Most small businesses hit trouble from errors and handoffs long before those limits.

Do I own custom software built for me?

Only if your contract states it. Ask for it in writing before work starts. Read who owns custom software code you paid for.

More in this topic: Problem solving: automating service business work (21 guides) →

Sources

Ready for the next step?

A 30 minute call. If you do not need me, I will tell you.

Ranjit Bhinge You talk to me, Ranjit. I reply within a few hours.

Not sure what you need? Tell me what is going on. I will point you the right way, even if it is not me.

Blur Studio · 30 minute call

Book a 30 minute call

You talk to me, Ranjit. If you do not need me, I will tell you.

  • We talk about your business and what is going on.
  • You leave with a clear next step, even if it is not me.
  • I reply to every message within a few hours.
Loading the calendar…