Almost every company has one. It is called something like MASTER CONTROL 2026 final (2).xlsx and it lives on someone’s computer, or in a shared folder, or in both with different versions. At a distributor it tracks orders and collections. At a school, enrollments and payments. At a law or accounting firm, case files and their deadlines. At a construction company, what was bought for each job.
It works. That is why nobody touches it. And that is exactly what makes it dangerous: the day it fails, it fails quietly and at the worst possible moment.
This article is not against Excel. It is about knowing when a spreadsheet stopped being a spreadsheet and became your company’s system without anyone deciding it should.
Excel is not the problem
Excel is one of the best tools there is for analyzing data, testing an idea or keeping one person’s records. If your spreadsheet is used by the person who built it, for what they built it for, there is nothing to fix.
The trouble starts when the spreadsheet becomes the source of truth for several people: what it says is what gets billed, delivered or promised. A spreadsheet was not built for that, and everyone who works in it stretches it a little further.
Six signs it is already a system
1. Several people edit it and copies circulate. Someone emails it “for you to review,” someone downloads it to work offline, and by the end of the day there are three versions and nobody knows which one is right.
2. Only one person understands the formulas. There is a hidden column, a macro nobody dares to open and a “don’t touch that.” If that person leaves, you are in the same spot as with a system nobody documented, except this time the system is a file.
3. You do not know who changed what. Even if the file is in the cloud with version history, finding out who changed a customer’s price three weeks ago is detective work. And if an auditor or an upset customer asks, “we don’t know” is not an answer.
4. Data gets entered twice. From email to the spreadsheet, and from the spreadsheet to the invoicing system. Every time someone copies data from one place to another there is a chance to get it wrong, and the error surfaces weeks later, when nobody knows where it came from.
5. It holds data not everyone should see. Customer phone numbers, salaries, balances. A spreadsheet has no row-level permissions: you either open all of it or none of it. And anyone who opens it can copy it.
6. It is splitting apart. It takes a while to open, someone broke it into “January,” “February” and “March” so it would not freeze, and finding out how much you sold this year means stitching twelve tabs together by hand.
If you recognized two or three, the spreadsheet is already a system. It is just one with no rules, no permissions and no history.
What gets lost without a sound
A spreadsheet almost never crashes with an error message. It simply stops counting something.
The best-known example is from October 2020. England’s public health agency left 15,841 positive Covid cases from one week out of its reports. According to what was published afterward, lab results were being collected in the old Excel format, which only allows 65,536 rows per sheet. What did not fit was not loaded, and nobody noticed for days.
Modern Excel allows over a million rows, so your spreadsheet is unlikely to hit that limit. The point is not the number. It is that the spreadsheet does not warn you: it does not tell you that a record did not make it in, that a formula stopped covering the new rows or that someone pasted values over a calculation. A system can warn you, because you can ask it to.
Before building, try this
Not every file needs to become custom software. Before spending, there are three cheaper steps, and sometimes they are enough:
Clean up the spreadsheet. One table per subject, headers that do not change, drop-down lists instead of free text, protected formulas and one person responsible. It sounds basic and it solves more than you would expect.
Keep a single copy. One file in a shared location, with permissions, and the rule that nobody works on a copy. Microsoft 365 and Google Workspace already allow this, and you probably already pay for one of them.
Look for something that already exists. If what you track in the spreadsheet is invoicing, payroll, point of sale or accounting, there are products built for that which cost less than building. Buy what is the same at every company.
When a system does make sense
When the spreadsheet does not hold something generic but the way you work: the rules for approving a discount, the order in which an order is picked, the requirements to enroll a student, the steps of a case file. No off-the-shelf product brings that, and it is precisely what sets you apart.
And when at least one of these is also true:
- Several people with different roles are involved: someone enters, someone approves, someone only looks.
- You need to know who did what and when.
- It has to connect to another system, such as invoicing, your online store or the bank, instead of copying by hand.
- People use it from a phone, away from a computer.
Your spreadsheet is the best spec you will ever have
The most expensive mistake when moving from Excel to a system is throwing the spreadsheet away and starting from scratch with interviews. The spreadsheet already has almost everything written down:
- The columns are the data you need.
- The formulas are your business rules.
- The colors, comments and margin notes are the exceptions, which is where the real work hides.
A good vendor starts by reading your file, not a template. And they should be able to show you something working with your own data before you sign anything, because that is the only way to know they understood.
Migration has an order worth respecting:
- Import the history, cleaning up duplicates and data that does not add up. This is almost always where the surprises show up.
- Run both in parallel for a few weeks, comparing results.
- Freeze the spreadsheet: it becomes read-only, an archive, and nobody enters data there anymore.
And one thing not to take away: the ability to export to Excel. Your people will keep analyzing data in spreadsheets, and that is fine. The difference is that now the spreadsheet is a copy of the system, not the system.
What staying put costs you
We will not give you a number, because it depends on your operation. But you can work it out in an afternoon:
- Hours per week someone spends entering, copying or reconciling the spreadsheet, times what that hour costs you.
- Errors in the last year that came from the spreadsheet: a charge that never went out, an order shipped twice, an old price honored for a customer.
- What would happen if the person who understands it were not there tomorrow.
If the total is small, clean up the spreadsheet and keep using it. If not, you know how big the problem is before you talk to any vendor.
Where we come in
We build custom software for companies of every kind in Juárez and El Paso, and very often the starting point is a spreadsheet exactly like this one. We read it, show you a working prototype with your data and build it in parts. If you first want to know whether you really need a system, Chira asks the questions and tells you in writing what to fix first, even when the answer is “not yet.” And if you already know, book a call.
References
- Excel specifications and limits, Microsoft — the maximum size of a worksheet in current versions: 1,048,576 rows by 16,384 columns.
- PHE statement on delayed reporting of COVID-19 cases, UK government — Public Health England’s statement of October 4, 2020, on the 15,841 cases left out of the daily reports.
- Excel spreadsheet blunder blamed after England under-reports 16,000 COVID-19 cases, The Register — the published explanation of the cause: results were stored in the .XLS format, limited to 65,536 rows per sheet.