How do you know you have outgrown your spreadsheets?

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

Short answer: You have outgrown spreadsheets when people spend real hours each week copying, checking or chasing data, or when one wrong cell can cost you a customer or a payment. Score yourself on the eight signs below. Zero to two means tidy your sheet. Three to five means try a ready-made software subscription. Six or more, or one sign that costs real money, means a small custom tool is worth pricing. Spreadsheets here means Excel (Microsoft's spreadsheet program) and Google Sheets (Google's free online version).

Ranjit Bhinge

You suspect your spreadsheets are holding the business back, and you want a simple way to find out and a sensible next step that is not a giant rebuild.

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.

The quick answer

A spreadsheet is a great tool for one person doing one job. It starts to fail when many people, many files and many rules pile onto it. The test is not how big the file is. The test is how much time and risk it adds to your week. If the score says custom, see when to move from spreadsheets to custom software.

Below is a score sheet you can fill in over a coffee. After that comes the hours math, the real limits of Excel and Google Sheets, the three ways forward, and the smallest first step.

Eight signs you have outgrown your spreadsheets

Give yourself one point for each sign that is true today. Be strict. "Sometimes" is a half point.

  1. The same data lives in more than one file. A customer's phone number is in the sales sheet, the job sheet and the invoice sheet. When it changes, someone has to fix three places.
  2. Someone copies and pastes between sheets every day. If a person's job includes moving numbers from one tab to another, that is a task software should do.
  3. Nobody is sure which version is right. You have files called "final", "final 2" and "final USE THIS ONE".
  4. Two people cannot work at once without a clash. Someone overwrites someone else, or has to wait for the file.
  5. One person holds the whole thing together. If they went on holiday for two weeks, work would stall. Their formulas are a mystery to everyone else.
  6. The file is slow or crashes. It takes a minute to open, or freezes when you filter.
  7. You cannot control who sees what. A sheet shared for one reason shows pay rates, margins or customer details to people who should not see them. Google notes that protecting a sheet or range should not be used as a security measure, because people can still copy or export the data.
  8. A mistake has already cost money. A wrong price quoted, a missed follow-up, a double booking, an invoice never sent.

Your score: 0 to 2 is normal. 3 to 5 means the sheet is starting to cost you. 6 to 8 means it is costing you now.

One exception. If sign 8 is true and the mistake was large, treat that as enough on its own. One missed payment of $4,000 is a bigger signal than three small annoyances.

The hours math

Signs are useful, but money decides. Here is a simple way to put a number on it.

Count the hours each week spent on: re-typing data, fixing errors, hunting for the right file, chasing people for updates, and building the same report by hand. Multiply by what an hour of that person's time costs you, then by 52.

Worked example (made-up figures for illustration): A 12-person cleaning company runs jobs, staff and invoices in four linked Google Sheets.

TaskHours a weekCost per hourCost a year
Copying new jobs into the schedule sheet4$25$5,200
Fixing mismatched customer details2$25$2,600
Building the weekly report by hand3$35$5,460
Chasing people for job status3$35$5,460
Total12$18,720

Those numbers are invented, but the method is real. If your total is under about $2,000 a year, a new system is hard to justify. If it is above $10,000 a year, you have room to fix it properly. Add the cost of any mistakes on top: missed invoices, jobs lost to a slow reply, double bookings.

The real limits of Excel and Google Sheets

Most small businesses never hit the hard limits. But it helps to know them.

  • An Excel worksheet holds up to 1,048,576 rows and 16,384 columns, and a shared workbook can be open for up to 256 users at once, according to Microsoft's published limits.
  • Google says a Google Sheets file can hold up to 20 million cells, or 100MB for files created in or converted to Sheets.

So if you have 20,000 customers in a sheet, size is not your problem. Your problem is almost always the process around the sheet: no rules, no history, no permissions, no automatic steps.

The limits that matter in practice are softer. Excel's data validation feature can block bad entries and create dropdown lists, which Microsoft documents, but few teams set it up. A file with many formulas and lookups gets slow long before it hits a hard cap. And a spreadsheet does not stop a person typing text in a number column or deleting a row.

There is also a famous case. In 2020, nearly 16,000 coronavirus cases went unreported in England because the data was moved through Excel files in an older format that could handle only about 65,000 rows, as the BBC reported. The extra cases were simply left off. The lesson is that spreadsheets fail quietly.

Looks like outgrown, but is not

Before you spend money, rule out these look-alikes. They feel like "the spreadsheet is too small" but are cheaper to fix.

  • A messy layout. One giant tab with merged cells and colours as data. Splitting it into clean tabs, one table per tab, often fixes the slowness.
  • No owner. Nobody is in charge of the file, so it drifts. Naming one owner and one rule set fixes a lot.
  • Missing training. Your team does not know filters, data validation (dropdown lists that block bad entries) or shared views.
  • A one-time cleanup need. You inherited a mess. Clean it once and see if the pain returns.

If the pain comes back within a month of a cleanup, that is the real sign. See also my guide to turning a spreadsheet into a dashboard without coding for a middle step.

Three ways forward

PathBest whenCost shapeWatch out for
1. Tidy the spreadsheetScore 0 to 2, or the pain is mostly messA few hours of your timePain returns in a month
2. Buy a software subscriptionScore 3 to 5 and your process is standard for your tradeMonthly fee per userFees grow with every hire; you adapt to its way of working
3. Build a small custom toolScore 6 or more, an unusual process, or many people paying per seatOne-time build plus modest hostingNeeds an owner on your side to make decisions

For a field service business, a trade-specific subscription often exists already. My piece on the field service spreadsheet shows when a job tool beats a sheet. For the wider question of renting versus owning, read build or buy software.

When your sheets are really a customer list in disguise, the fastest win is one shared record. I wrote a step-by-step on how to replace five spreadsheets with one customer database. If one specific workbook runs your business, see turning an Excel file into a web app. For small in-house tools in general, see internal tools.

When custom is not the answer

Do not build if:

  • You have one person using the sheet and it works for them.
  • Your process changes every few weeks. Software set in stone will annoy you.
  • A ready-made tool for your trade covers 90 percent of what you do.
  • Nobody on your side can spend an hour a week making decisions during a build.

Plenty of businesses should stay on spreadsheets for years. A good sheet with an owner and a few rules is a fine system. If your old system is Access rather than Excel, see replacing an Access database with a web app.

The smallest first step

Do not start with a big rebuild. Try this in one week:

  1. Day 1: Fill in the eight-sign score. Ask one other person to score it too, because they will see things you do not.
  2. Day 2: Do the hours math for the single most painful task.
  3. Day 3: Write down the one workflow that hurts most, in plain words: what goes in, what comes out, who touches it.
  4. Day 4: Tidy that part of the sheet. One table per tab, one owner, dropdowns for fixed choices.
  5. Day 5: Decide: tidy only, subscription, or get a quote for a small custom tool for that one workflow.

Moving one workflow first, not the whole business, keeps the cost and the risk small. It also gives you a real result before you commit more. Many small tasks around the sheet can also be handled by automation. See business process automation and AI for small business for ideas that do not need a rebuild.

How I'd approach this

Do not leave spreadsheets because they feel old. Leave when you can point at a number: hours lost, or money lost.

My order is always the same. Tidy first, because it is free and it shows you what the real process is. Buy second, if your trade has a decent tool, because a ready-made product is cheaper than anything built. Build third, and only for the one workflow where the other two failed. When I scope a small build, I start with the single process that costs the most, price that alone, and leave the rest for later.

If you want a second opinion on your own score, bring your numbers to a call and I will tell you which of the three paths I would take, including when the answer is to change nothing.

Questions people ask

How many rows or users can a spreadsheet handle before it breaks?

Microsoft lists 1,048,576 rows and 16,384 columns per Excel worksheet, and up to 256 users on a shared workbook. Google lists up to 20 million cells for a Google Sheets file. Most small businesses hit slowness and mistakes long before those caps, so use the eight-sign score instead.

Is it time to replace Excel if it is slow?

Not always. Slowness is often caused by a messy layout, too many lookups or a very large single tab. Try splitting the data into clean tabs first. If it stays slow and people still copy data by hand, read build or buy software.

What can I use instead of spreadsheets for a small business?

For a standard process, a ready-made software subscription for your trade. For one shared customer list, a single database, as in my guide to replacing five spreadsheets with one customer database. For an unusual process, a small custom tool.

How much does it cost to replace a spreadsheet with custom software?

It depends on how many workflows and users you have. I explain the cost drivers in custom software development cost. A good habit is to price one workflow first and compare it to your yearly hours cost.

Can I keep my spreadsheet and add something around it?

Yes. A common middle path is to keep the sheet as the source of data and add a simple dashboard or form on top. See how to turn your spreadsheet into a dashboard.

Should I tidy my spreadsheet before I move to new software?

Yes. Clean data and a clear list of what each tab does make any move cheaper, whether you buy or build. A tidy sheet is also the best brief you can give a developer.

More in this topic: Problem solving: custom software (22 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…