Spreadsheets run a lot of small businesses, and that’s fine until it isn’t. Signs you have outgrown one, and how to move without losing what works.
Almost every business has a spreadsheet that quietly runs something important: the stock count, the staff roster, the list of who still owes a form. It started small and sensible. Over time it gained tabs, colours, rules only one person understands and a file name ending in “FINAL v3”.
Spreadsheets are wonderful tools. They are also easy to outgrow.
Signs you have outgrown one
- Only one person really understands it, and things wobble when they are away.
- Two people edited it at once and something got overwritten.
- You keep a second sheet to track changes to the first.
- People phone or message to ask what it says.
- You can’t tell who changed a number, or when.
- Mistakes are found weeks later, if at all.
The spreadsheet is your best requirements document
Before replacing it, study it. The columns show what information really matters. The colours show the states things move through. The notes and side tabs show where the current process breaks. A new tool that ignores all that will feel worse, however modern it looks.
We sit with the people who maintain these files and ask what they check first each morning and which columns they would never give up.
What the next step usually looks like
- A simple app or form for entering information, so everyone adds it the same way.
- One shared record, with a history of who changed what.
- Views for each role: the coordinator sees their list, the manager sees the summary.
- Automatic reminders for things that are overdue.
- An export button, because sometimes a spreadsheet is still the right way to look at the numbers.
Keep what the spreadsheet got right. Replace only what it gets wrong.
Moving without disruption
Run the new tool alongside the spreadsheet for a few weeks. Compare the two. Let the team point out what is missing. Switch over only when the people who use it every day are ready.
From the DYOL blog. Photo by 1981 Digital on Unsplash.
Keep reading
All posts
Getting your tools to talk to each other
Most small businesses run on six to ten apps that don’t share anything. How integrations work, what they cost in effort, and where to start.

Online booking that fills the calendar instead of the inbox
Booking tools are easy to buy and easy to get wrong. The details that cut phone tag, no-shows and double bookings, for any business that runs on appointments.

Reading forms and documents with AI, without losing control
AI can now read scanned forms, IDs, receipts and letters well. Where that saves hours, and the checks that keep it safe.
A free 20-minute conversation, then an honest assessment. You’ll know what it costs and how long it takes, in writing, at a fixed price.
Or email lloyd.delacruz@outlook.com. We reply within 24 hours.
