Walk into almost any small business that runs on regular customers, a yoga studio, a tutoring center, a coworking space, a small clinic, and ask how they keep track of everyone. There's a good chance someone will turn a laptop around and show you a spreadsheet.
It will have a tab for this month and a tab for last month. A column of names, a column of phone numbers, a column with dates typed in three different formats. Some cells will be highlighted yellow for reasons only one person remembers. Next to the laptop, there might be a paper logbook for the days the laptop wasn't open.
It's easy to look at that and think: this business needs to modernize. There are thousands of software products built for exactly this.
But that reaction misses something. That spreadsheet isn't a failure to adopt software. It's software. It's just the first version.
Spreadsheets run more of the world than we admit
Excel isn't only a small-business tool. It quietly holds up large parts of the economy, and occasionally that shows.
In 2013, graduate students trying to reproduce a widely cited economics paper by Carmen Reinhart and Kenneth Rogoff found a spreadsheet error: a formula that left out several countries' data. The paper had been cited in debates about government spending.
In 2020, Public Health England lost track of nearly 16,000 COVID-19 cases because data was being moved through an old Excel file format with a row limit. Cases past the limit were simply cut off.
In 2012, JPMorgan Chase lost around US$6 billion in what became known as the "London Whale" trades. The bank's own internal review later found that a risk model involved copying and pasting data between spreadsheets by hand, and that a formula error had made the risk look smaller than it was.
Even science isn't immune. Excel automatically converts some text into dates, which turned gene names like SEPT2 and MARCH1 into "2-Sep" and "1-Mar". A 2016 study in Genome Biology found this error in roughly a fifth of published papers that included gene lists in supplementary spreadsheets. The problem was so persistent that in 2020 the scientific committee that names human genes renamed several of them to stop Excel from mangling them.
These are organizations with analysts, budgets and IT departments. If spreadsheets are that load-bearing for them, it's no surprise they're the backbone of a five-person business.
How common are spreadsheet errors?
Raymond Panko, a researcher at the University of Hawaii, spent years studying how often spreadsheets contain mistakes. Across the audits he reviewed, the large majority of real-world spreadsheets, often cited as close to nine in ten, contained at least one error. Many of those errors were small. Some weren't.
The reason isn't that people are careless. It's that spreadsheets make every cell equally editable and give almost no warning when something goes wrong. A typo in a formula looks exactly like a correct one.
Why small businesses stay
From watching how businesses actually adopt tools, three reasons come up again and again. None of them is stubbornness.
The right software is hard to find. It often exists, but people don't find it when they look. It might describe itself with words they don't use, or market itself in places they never go. An owner searching "how to track members" might never land on a product that calls itself a "membership management platform".
Excel is the closest thing. It's already on the computer. Everyone knows the basics. There's nothing to sign up for, nothing to pay, nobody to call.
It's the default thought. Picture someone opening a small studio. The question "how will I keep track of members?" comes up on day one, and the answer is almost automatic: "Fine, a spreadsheet for now." Nobody decides to build their operations on Excel. It just happens, one tab at a time.
It's flexible in a way software rarely is. This one is underrated. A spreadsheet never says no. Need a new column for a discount you just invented? Add it. Want to track something only for three customers? Highlight them yellow. Software built for thousands of businesses has to make choices, and some of those choices won't match yours. The spreadsheet adapts to the owner instead of the other way round.
That flexibility is why spreadsheets have lasted so long. VisiCalc, the first electronic spreadsheet, came out in 1979 and was one of the main reasons businesses bought personal computers at all. More than four decades later, spreadsheets are still one of the most widely used tools in business. It's arguably the most successful piece of software ever made for non-programmers.
Your spreadsheet is the first draft of your system
This is the idea worth holding on to. A spreadsheet that has been used for a year isn't chaos. It's a record of how the business actually works, written by the people who do the work.
Every column that survived earned its place. Every tab that's opened daily is a core task. The more someone works with their data, the more they learn what matters and what doesn't. They repeat the same steps so many times that the steps become a system, without anyone ever calling it one.
A typical membership spreadsheet, for example, tends to grow columns like these:
Name | Phone | Plan | Start date | End date | Paid? | Notes |
|---|---|---|---|---|---|---|
Rina | 0812... | Monthly | 1 Sep | 30 Sep | Yes | Wants to pause in Oct |
Budi | 0813... | 3 months | 15 Jul | 14 Oct | Partial | Owes the second half |
Look at that and you can already see the system hiding inside. Plans and dates mean the business needs expiry tracking. "Paid?" with the answer "Partial" means it needs installment tracking. "Wants to pause" in the notes column means it needs a pause feature that doesn't exist yet. The notes column, in particular, is where every missing feature quietly lives.
So before moving to any software, read your spreadsheet like a brief:
Which columns do you fill in every time? That's your real data.
Which tabs do you open every day? That's your core workflow.
What do you calculate by hand? That's what should be automated first.
What keeps ending up in the notes column? That's what your current system can't handle.
What do you double-check before trusting? That's where errors cost you.
Powerful, but rigid
Excel is genuinely powerful. The problem isn't what it can do. It's how easily it breaks when people, not spreadsheet experts, use it every day.
Move a tab and a formula that pointed to it stops working. Copy a table into another sheet and the references go wrong. Sort one column without the others and every name is matched to the wrong phone number. Someone types "Sept 1" instead of "01/09" and the expiry calculation silently skips them.
At a small scale, someone notices. As the business grows, nobody does, until a customer is charged twice or a membership that expired three months ago is still being honored.
Paper has its own version of this. It never crashes and never needs charging, and it's easy for anyone to use. But it can't remind anyone of anything, it can't be searched, and it can't be in two places at once. A paper log tells you what happened. It can't tell you what's about to happen.
Signs you've outgrown it
There's rarely one moment. It builds up:
The data keeps growing, and the file gets slower, heavier and harder to trust.
Nothing connects. Payments, reminders and attendance each live somewhere else, and a person is the integration between them.
You hit its limits. You want something to happen automatically, like a reminder three days before a membership ends, and Excel can't do it without someone opening the file.
More than one person edits it, and nobody is sure which version is the real one.
Underneath all of these is something basic: controlling how the data changes. In a spreadsheet, a membership's status is whatever someone last typed. In a proper system, statuses change according to rules, and every change is recorded and counted. That's the real upgrade. Not a nicer screen, but data that can be trusted without being rechecked.
A week, before and after
It helps to picture what actually changes in a normal week.
Before, on a spreadsheet: - Monday morning, someone scrolls the sheet to find memberships that end this week. - They message each person individually to remind them. - Payments arrive by transfer. Someone checks the bank app and updates the "Paid?" column by hand. - A member says they already paid. Nobody can find it. Someone digs through chat history. - At the end of the month, someone spends an afternoon building a report of who joined, who left and how much came in.
After, on a system built for it: - Memberships nearing their end are listed automatically. - Reminders go out on schedule without anyone sending them. - Payments are recorded against the right person, and their status updates by itself. - Every change has a history, so "I already paid" takes seconds to check. - The monthly report is already there.
Setup is usually quicker than people expect, too. The hard part was never the software. It was the months of manual habits the spreadsheet had quietly created.
Moving shouldn't mean starting over
The biggest fear about switching is re-entering everything. It shouldn't have to be like that.
Good software meets the spreadsheet where it is. It should import the columns you already have, and accept data in a minimal form. A name and a phone number should be enough to start, with the rest filled in as the business uses the system. For example, Memverr, the member management platform we built, lets businesses start with just that and complete member details over time. The spreadsheet doesn't have to be perfect before you move. It only has to exist.
The other good sign is setup. If moving to a new tool takes weeks of configuration before it's useful, the tool has the same problem the spreadsheet had: it asks the business to adapt to it.
If you're not ready yet
Staying on a spreadsheet is a perfectly reasonable choice, as long as it's a choice. If you stay, keep it healthy:
Check your formulas regularly, especially after moving or copying anything.
Double-check the results that matter, like totals, due dates and balances, instead of trusting them because they were right last month.
Keep one version of the truth. Copies of copies are where mistakes breed.
Use one date format, everywhere, always.
Treat the notes column as a to-do list for your next system.
And keep listening to what the spreadsheet is telling you. When the time comes, it will be the most honest brief you could write for whatever replaces it.
Layerice is a software design and development studio for businesses. We often start a new system by reading the spreadsheet a business already runs on.