Short answer: You’ve outgrown Excel when work slips through the gaps between files, not when the file gets big. Keep Excel for numbers: prices, costs, totals and budgets. It is very good at those. What spreadsheets do badly is follow-up, ownership and “who does what next”, because a cell can’t remind you, chase anyone or tell you which version is the real one. Replace the follow-up part first, and leave the numbers where they are.
Say you run a plumbing business. On a Monday, a homeowner asks you to quote for a new water heater. You note the follow-up in your spreadsheet. On Wednesday you work from a different copy of the same spreadsheet. Two weeks later the homeowner lets you know, politely, that they went with someone who called back.
There is a sheet for clients, a sheet for jobs, a sheet for quotes, and a sheet called “follow up FINAL v3” that nobody has opened since March. It works, mostly. The water heater follow-up is still sitting in v2.
Every business has one spreadsheet that everybody is afraid to sort.
Is it bad to run a small business on spreadsheets?
No. Plenty of good businesses run on spreadsheets for years. A spreadsheet is cheap, flexible and you already know how it works. The question isn’t whether Excel is good enough. It is which jobs you’re asking it to do.
Spreadsheets are good at calculating, listing and comparing. They are poor at reminding, assigning and following through. If your sheet is mostly numbers, it is probably fine. If it is mostly people and promises, that’s where things go missing.
Even the numbers need a second look now and then. In a well-known review of spreadsheet studies, researcher Raymond Panko reported that “51% of all spreadsheets contained errors” in the experiments he looked at, even though most were only 25 to 50 cells in size (Panko, Spreadsheet Errors: What We Know). That isn’t a reason to stop using Excel. It is a reason not to ask one file to be your memory as well.
What are the signs you’ve outgrown Excel?
Most owners don’t decide they’ve outgrown Excel. They notice it, usually after a customer has noticed first. Here are six signs to look for:
- You have more than one version of the same file, and you’re not sure which is current.
- A follow-up depends on you remembering to open the sheet.
- Two people updated the same row and one change disappeared.
- You keep a column called “notes” that has turned into a diary.
- Customers sometimes chase you before you chase them.
- You can’t answer “what is waiting on me right now?” without scrolling.
Two or more of these, and the spreadsheet is doing a job it was never built for. One sign on its own is usually a tidy-up job, not a new system.
If you’ve outgrown Excel, what should stay in it?
Anything that is mainly arithmetic: your price list, job costing, monthly totals, a simple budget, a stock count. If your bookkeeper or accountant works from it, keep it in the format they want. Moving numbers into a new system for the sake of it creates work and new mistakes.
A good test: if the main thing you do with a sheet is add it up, it can stay. If the main thing you do with it is remember to do something, it is a candidate to move.
What should move first once you’ve outgrown Excel?
Follow-ups. They are the most expensive thing to lose, because a forgotten follow-up is usually a forgotten customer. After that, move “who does what next”: the list of open jobs, who owns each one and what the next step is. Keep this somewhere that shows you the open items without searching for them.
You don’t have to move your history. Start with the open items only: the quotes still waiting for an answer, the jobs not yet finished and the customers you promised to call. Old, closed rows can stay in the spreadsheet as your archive.
Excel vs CRM: which does a small business need?
A CRM (customer relationship manager) is a tool for tracking customers, conversations and what happens next with each one. The honest comparison of Excel vs CRM for a small business looks like this:
- Excel is better for sums, lists you sort and filter, and anything your accountant needs. It is cheap and flexible, and it never nags.
- A CRM is better for reminders, shared customer history and seeing everything that is open in one place. It nags on purpose.
The catch with a CRM is that someone has to keep it updated, or it becomes another spreadsheet with a nicer font. Many small businesses end up using both: Excel for the numbers, something else for the follow-ups. That is not a failure to choose. It is each tool doing the job it is good at.
What is the best spreadsheet alternative for small business follow-ups?
There isn’t one best spreadsheet alternative for small business follow-ups. There are a few honest options, and the right one depends on how many people need to see the list:
- A shared task list or simple CRM. Good when several people need to see the same list and pick up each other’s work.
- Your calendar. Put each follow-up on a date. Simple, and it works well for one person.
- An AI assistant with a routine. If you already use ChatGPT or a similar assistant, it can turn your notes into a weekly list of follow-ups and draft the messages for you to check.
Most small businesses don’t need all three. Pick the one you’ll actually open every day. The best system is the one that is still in use in six months.
What can I do today without buying anything?
- Choose one master file. Rename every other version “OLD” and move it to an archive folder.
- Add three columns to your client or job sheet: Next step, Who, By when.
- Fill them in for every open item. Anything without a next step is either finished or forgotten. Decide which.
- Each Monday, filter by “By when” and copy that week’s follow-ups into your calendar.
- Keep the numbers sheets exactly as they are.
These five steps often solve most of the problem, and they show you clearly whether you have really outgrown Excel or just needed one tidy file.
Where Ankor fits
For a one-person business, the Essential Business Package is a set of instructions you add to the AI assistant you already pay for: ChatGPT, Claude or Gemini. It gives your week a shape: priorities first, one marketing action, one decision written down, and routines for things like inbox triage and getting invoices out. For a business with staff or contractors, Ankor Nexa does the same for a team, with who does what and what is waiting for your approval. If you run more than one location, our post on managing multiple business locations covers the owner’s side of that.
Neither replaces your spreadsheet for numbers or your accountant for the books. They handle the follow-up and next-step part that spreadsheets struggle with. Try it free for 7 days in ChatGPT or Claude. No card needed. After that, it’s once off or month to month. It drafts, you decide, and nothing is sent without your yes. If AI assistants are new to you, our guide on how to use AI in a small business starts from zero.
Questions owners ask
How do I know if I’ve outgrown Excel?
Look at follow-ups, not file size. The signs you’ve outgrown Excel are practical ones: if you have several versions of the same file, customers chase you before you chase them, or you can’t see what is waiting on you without scrolling, the spreadsheet is doing a job it wasn’t built for.
Will I have to move all my data into a new system?
Not necessarily. Keep your numbers in Excel. Only the follow-up and next-step information needs a new home, and you can start with open items only.
Is a CRM worth it for a one-person business?
Sometimes, but many solo owners do fine with a calendar and a weekly routine. Try the free steps first and see what is still slipping.
Can an AI assistant read my spreadsheet?
Most assistants can read a file you share with them in a chat. Check what it says against the original, and don’t share customer details you wouldn’t put in an email.
Should I stop using Excel altogether?
No. Excel is still one of the best tools for prices, costs and totals. Move the reminders and follow-ups out, and let Excel keep doing the arithmetic.
Your first step this week
Start with the three new columns. If “Next step” is blank on half your rows, you’ve found the leak, and you found it without buying anything. If you’re not sure what to do next, email admin@ankor.co.za and tell us what is slowing you down.
Ankor tips
Stay in the loop
Practical AI tips for small businesses and the odd product update. No spam, unsubscribe any time.