Nobody decides to run a business on a spreadsheet. It starts as a quick way to track quotes, or stock, or who is rostered on Saturday. It works, so it grows. Someone adds a tab. Someone else adds a macro. Five years later it has forty columns, three people who are allowed to edit it, and a cell near the bottom that must never be touched.
Spreadsheets fail slowly, which is why the moment they stop being a tool and start being the system is so hard to spot from the inside. If you have found yourself wondering whether your business has outgrown Excel, you are probably already past the point. Here are the signs we see most often, the fixes that buy time, and what replacing a spreadsheet actually involves when a fix is no longer enough.
Seven signs a spreadsheet has become the system
1. You have stopped trusting the number
Someone reads a figure out in a meeting and the room pauses. Is that from this month's file or last month's? Did the new rates go in? Was the formula copied down to the last row? When a spreadsheet is small you can scan it and know. Once it passes a certain size, nobody can, and every number comes with a quiet asterisk.
2. There are six copies and nobody knows which is right
Version numbers in filenames are the clearest symptom. Quotes_v14_FINAL.xlsx sitting next to Quotes_v14_FINAL_Jason_edits.xlsx. Files are emailed between teams, edited in parallel, and merged by hand on a Friday afternoon. Shared drives and OneDrive help a little, until two people open the same file at once and one of them loses their work.
3. One person understands the formulas
Every long-lived spreadsheet has a keeper. They know why column AG is hidden and what the macro from 2016 does. When they are on leave the process slows down. When they resign, the business discovers how much of its operation lived in one person's head and one unlocked workbook.
4. It gets re-keyed into everything else
The quote is built in the spreadsheet, then typed into Xero, then into an email, then onto a job sheet, then back into a report. Every copy is a chance for the numbers to drift, and someone is paid to do the copying. If you add up the hours spent moving the same data between a spreadsheet and the systems around it, the result is usually uncomfortable.
5. It is slow, or it breaks
Recalculation takes long enough to make a coffee. The file is forty megabytes. It crashes when a particular report runs, and everyone knows to save first. Excel is remarkably tolerant, so by the time a spreadsheet is visibly struggling it has usually been carrying far more than it should for years.
6. You cannot give someone part of it
A subcontractor needs to see their jobs but not everyone else's rates. A new starter should be able to add an entry but not change the price list. A spreadsheet gives you one blunt choice: the whole file or nothing. So either too many people can see too much, or the keeper becomes a bottleneck for every small update.
7. You cannot answer "who changed this, and when?"
A margin is wrong on an invoice. Was it the rate, the quantity, or a stray keystroke? When did it change? Spreadsheets have no memory. For anything a customer, an auditor or the tax office might ask about, that is a real exposure, not just an annoyance.
If you nodded at three or more of these, the spreadsheet is no longer a spreadsheet. It is your operating system, and it is being run on software built for personal calculations.
The fixes that buy time
Replacing a spreadsheet is not always the right answer, and it is rarely the first thing to try. A few changes will take the pressure off for months or years, and they are worth doing regardless.
- One file, one place. Move the master copy to SharePoint or OneDrive, turn on version history, and delete the emailed copies. Half the version problem disappears.
- Lock the rules. Use Excel's data validation on the columns that keep going wrong, protect the formula cells, and separate the data tabs from the calculation tabs so a stray keystroke cannot break the maths.
- Write down what the keeper knows. A one-page explanation of each tab and each macro. It is tedious and it is the cheapest insurance you will ever buy.
- Check whether a product already exists. If your spreadsheet is a job tracker, a stock list or a roster that looks much like everyone else's, there is probably an off-the-shelf tool that does it well. Try it before you build anything.
These help when the problem is discipline. They do not help when the problem is that the spreadsheet is doing a job a spreadsheet cannot do: many people editing live, rules that must be enforced rather than hoped for, data that needs to flow into accounting and out to a phone on site. That is the point where businesses start looking at a database, and many land on Microsoft Access as the next step. Access is a reasonable bridge, and we have moved a lot of Access databases to the web once they outgrow their job in turn. But if you are at the decision point now, it is worth skipping the bridge.
What replacing a spreadsheet actually involves
The phrase "custom software" puts people off, and fairly so. It sounds like a long, expensive project with a big switch-over at the end. Replacing a spreadsheet-based workflow does not look like that. It looks like this.
Map the spreadsheet. Every tab, every column, every formula and macro, and who touches each one. This is where the real business rules live, and most of them have never been written down anywhere else. Mapping is usually the bulk of the Discovery phase, and clients often find the map alone is worth having.
Prototype it. A clickable version of the new system goes in front of the people who use the spreadsheet today. They point out what is missing before anything is built, which is far cheaper than finding out afterwards.
Build it and import the history. The application is built, your existing data is imported, and the imported figures are checked against the original file. Where a column was used three different ways over the years, that gets sorted out deliberately rather than guessed at.
Run them side by side. The spreadsheet keeps working the whole way through. You switch when the new system has earned it, not on a date someone picked at the start.
What comes out the other end is a web application that the whole team can use from a browser or a phone, with the rules built in, permissions per person, a record of every change, and a direct connection to Xero or whatever else the data needs to reach. Excel does not go away. It stays as the analysis tool it is good at, with a clean export whenever someone wants to pivot the data.
What it looks like when it is done
Arrow Logistics moves bulk commodities for clients ranging from single farmers to multinational trading firms. When they came to us in 2016 the business ran on spreadsheets. Today it runs on a cloud platform with full Xero integration, and their drivers use iOS and Android apps for job details and access notes, including in rural areas with patchy reception. Clients request jobs through the system and watch their progress. You can read the full Arrow Logistics story on our site.
What it costs and how long it takes
Replacing one spreadsheet-based workflow is a focused build. In our experience it typically runs three to four months from Discovery to live, and lands somewhere between $40,000 and $150,000 depending on how many workflows, users and integrations are involved. The custom software cost guide breaks those ranges down, and a Discovery phase ends with a fixed estimate rather than a guess.
Against that, it is worth putting a number on the other side of the ledger: the hours spent re-keying, the pricing errors that reached customers, the afternoons lost merging versions, and what happens to the business the week the keeper hands in their notice.
Where to start
Pick the one spreadsheet the business would stop without. Not the biggest, the most load-bearing. Then try the quick fixes above for a month and see how much pressure they take off. If the answer is "not enough", you already know more about your requirements than most businesses do when they start a software project, because the spreadsheet is the requirements.
If you would like a second opinion, send us the spreadsheet, or just describe it. One of our strategists will tell you whether it needs replacing, what that would take, and whether something off the shelf would do the job instead.
