Let me say this first: I love spreadsheets. Excel and Google Sheets are the most successful business software ever made, and any consultant who sneers at them has forgotten what they are good at. Flexible, free or cheap, and every admin staff member in Indonesia already knows how to use them.
But there is a specific moment in a company's growth when the spreadsheet quietly changes jobs. It stops being a calculation tool and becomes the database, the workflow system, and the reporting layer all at once. That is the moment a business has outgrown spreadsheets, and most owners only notice a year or two after it happened, usually when something breaks expensively.
Here are the seven signs I look for when a company asks me whether it is time. For each one, I have included the cheapest sensible next step, because the answer is almost never "buy a big system".
The seven signs
1. Nobody knows which file is the real one
You have Stok_Jan_FINAL.xlsx, Stok_Jan_FINAL_revisi.xlsx, and Stok_Jan_FINAL_revisi_pakai_ini.xlsx, and two of them are attached to emails making decisions right now. Version chaos is the earliest and most common symptom. The spreadsheet was designed for one author, and you now have five.
Cheapest fix: move the file to Google Sheets or a shared OneDrive file with a single canonical location. One URL, no attachments, edit history included. Costs nothing, takes an afternoon, eliminates an entire category of errors.
2. One person is the priesthood
There is a file, usually pricing, payroll, or production planning, that only Ibu Dewi truly understands. When she is on leave, questions wait. When she resigns, and someday she will, you lose not just data but the logic: why row 400 is highlighted yellow, which columns are manual, which formula was patched in 2021.
Cheapest fix: before anything else, have her record a 30-minute screen recording walking through the file, and write one page of notes. This is insurance, not transformation, and it costs one afternoon.
3. The same data is typed more than once
An order arrives via WhatsApp, gets typed into the sales sheet, retyped into the delivery sheet, and retyped again into the invoice template. Every retype is a chance for a typo, and reconciling the three versions at month-end becomes a real job. One distributor I worked with had a staff member spending roughly two full days a month just aligning numbers between sheets, call it Rp5 million a year of salary spent producing nothing.
Cheapest fix: restructure so data lives in one sheet and other sheets reference it, using lookups or Google Sheets' IMPORTRANGE. If that is beyond the team, this is the first place a proper tool pays for itself.
4. Formulas break silently and nobody trusts the totals
Someone inserts a row and a SUM range does not stretch. Someone sorts a filtered range and half the columns shift. The scary part is not the breakage, it is that spreadsheets fail silently. The famous cases are large, JPMorgan's London Whale loss involved a spreadsheet error measured in billions, but the SME version is quieter: a margin report that overstated profit for six months.
Cheapest fix: add cross-check cells, totals computed two different ways that must match, and protect formula ranges from editing. If people have stopped trusting the numbers anyway, that trust rarely returns, and it is a strong signal to move that specific workflow off spreadsheets.
5. The file is your customer database
Customer names, phone numbers, purchase history, and complaints, all in a sheet that has been emailed around and copied to personal laptops. Beyond the operational mess, this is a genuine liability. You cannot control who has a copy, and you cannot delete data you cannot find. As data protection rules tighten in Indonesia, "our customer data is in seventeen unmanaged Excel copies" becomes a legal problem, not just an IT one. I cover that side in Data Privacy Compliance for Indonesian Businesses.
Cheapest fix: move customer data specifically into a low-cost CRM. Even a basic one gives you access control, edit history, and one copy of the truth.
6. You are running workflows through cell colors
Yellow means waiting for payment, green means shipped, red means problem, and the meaning lives only in people's heads. Spreadsheets have no concept of "whose turn is it now", so status updates depend on people remembering to recolor cells, and things fall through precisely when you are busiest.
Cheapest fix: workflow is the job spreadsheets are worst at. Tools like Trello or a simple shared task board handle "what stage is this in and who owns it" natively, and the free tiers cover most SMEs. Move the workflow, keep the numbers in sheets if you like.
7. Reports take days and answer last month's questions
The owner asks "which branch is dead stock accumulating in?" and the answer requires three people, two days, and a merged monster file that is obsolete on arrival. When the cost of asking a question is that high, people stop asking, and the business runs on feel. I watched a retail chain fix exactly this, and I will publish that story later this week as a case study: How a Retail Chain Stopped Guessing Its Inventory.
Cheapest fix: before buying a BI tool, fix the input side. Reports are slow because the underlying data is scattered and inconsistent. One source of truth first, dashboards second.
How many signs did you count?
A rough scoring guide from experience:
| Signs present | What it usually means |
|---|---|
| 0 to 1 | Spreadsheets are fine. Spend your budget elsewhere. |
| 2 to 3 | Fix hygiene now: one canonical file, documented logic, protected formulas. |
| 4 or more | At least one core workflow needs a real system this year. Pick the one bleeding the most money. |
Note the phrasing: one workflow, not "digital transformation". The most common failure I see is a company jumping from spreadsheet chaos straight to a full ERP, an eighteen-month project that stalls because the team that could not maintain sheet discipline is now expected to feed a far stricter system. Migrate the single most painful workflow, prove the habit change, then take the next one.
The takeaway
Spreadsheets do not fail loudly. They accumulate small risks, a broken formula here, a lost file there, one indispensable employee everywhere, until a bad week makes the accumulated cost visible all at once.
This week, count your signs against the seven above, honestly. If you scored two or three, the fixes are cheap and mostly free, do them this month. If you scored four or more, choose the one workflow that costs you the most, whether in hours, errors, or sleep, and plan its migration properly rather than reflexively opening a new spreadsheet. Fewer files, one source of truth, and a team that trusts the totals again. That is the real goal, and it is very reachable.