How do you know you have outgrown your spreadsheets?
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).
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.
- 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.
- 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.
- Nobody is sure which version is right. You have files called "final", "final 2" and "final USE THIS ONE".
- Two people cannot work at once without a clash. Someone overwrites someone else, or has to wait for the file.
- 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.
- The file is slow or crashes. It takes a minute to open, or freezes when you filter.
- 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.
- 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.
| Task | Hours a week | Cost per hour | Cost a year |
|---|---|---|---|
| Copying new jobs into the schedule sheet | 4 | $25 | $5,200 |
| Fixing mismatched customer details | 2 | $25 | $2,600 |
| Building the weekly report by hand | 3 | $35 | $5,460 |
| Chasing people for job status | 3 | $35 | $5,460 |
| Total | 12 | $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
| Path | Best when | Cost shape | Watch out for |
|---|---|---|---|
| 1. Tidy the spreadsheet | Score 0 to 2, or the pain is mostly mess | A few hours of your time | Pain returns in a month |
| 2. Buy a software subscription | Score 3 to 5 and your process is standard for your trade | Monthly fee per user | Fees grow with every hire; you adapt to its way of working |
| 3. Build a small custom tool | Score 6 or more, an unusual process, or many people paying per seat | One-time build plus modest hosting | Needs 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:
- Day 1: Fill in the eight-sign score. Ask one other person to score it too, because they will see things you do not.
- Day 2: Do the hours math for the single most painful task.
- Day 3: Write down the one workflow that hurts most, in plain words: what goes in, what comes out, who touches it.
- Day 4: Tidy that part of the sheet. One table per tab, one owner, dropdowns for fixed choices.
- 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
- Microsoft Support: Excel specifications and limits
- Google Docs Editors Help: Files you can store in Google Drive (Sheets limits)
- BBC News: Excel, why using Microsoft's tool caused Covid-19 results to be lost
- Microsoft Support: Apply data validation to cells
- Google Docs Editors Help: Protect, hide and edit sheets