CRM & automation
Spreadsheet or CRM: when has a small business outgrown Excel?
Plenty of South African small businesses run well on Excel or Google Sheets for years. Others buy a CRM too early, find it slower than the sheet, and quietly drift back.
If you can't tell which group you're in, the warning signs below are the quickest test. After that come what a CRM adds, what POPIA expects either way, and how to move across without losing anyone.
When is a spreadsheet still the right tool?
When one person keeps it and the work it tracks is simple. If you can open the sheet with your morning coffee, scan it and know who to call, it's doing its job.
A spreadsheet has two things going for it. You already own one, and you can add a column the moment you need it. Early on, that flexibility counts for more than structure, because you're still learning how your own sales process runs. A CRM asks you to name your stages before you know what they are.
A kitchen fitter in Pretoria East with a few new jobs a month knows every customer by name. A sheet with one row per job, a status column and the date of the next step is plenty, and a CRM would mostly add another login.
Be honest about one thing before you switch. If the sheet is out of date because nobody updates it, a CRM will go out of date for the same reason. What fixes that is making the updates happen by themselves, which comes up again below.
What are the signs a spreadsheet has stopped working?
The clearest sign is that the sheet no longer tells you what to do next. You open it, then go hunting through chats and emails before you can act. The other signs tend to arrive together:
- There's more than one copy, and nobody is sure which is current.
- Follow-ups depend on memory. The sheet has a column for the next call, but nothing reminds anyone on the day, so quotes go quiet.
- The history lives somewhere else. The sheet holds a name and a cellphone number, while what was promised is spread across WhatsApp and email threads.
- Two people phone the same customer, or nobody does, because no row says whose customer it is.
- Simple questions, like how many quotes are still open, take an afternoon of filtering.
- You type the same details into the quote, the invoice and the diary, then back into the sheet.
- When someone leaves, what they knew leaves with them.
One of these is a reason to tidy the sheet. Several at once mean the sheet is doing a CRM's job.
Do you need a CRM yet, or will a tidier spreadsheet do?
If you only recognised one or two of those signs, try a tidier, shared spreadsheet first.
Start with the copies. Keep one file in the cloud and stop emailing it around. Microsoft's own guide to co-authoring in Excel explains that with a Microsoft 365 subscription and the workbook saved on OneDrive or in SharePoint Online, several people can work in the same file at once and see each other's changes quickly. A file saved there also keeps a version history, so a bad edit can be rolled back.
Then tidy the structure. Give every column one meaning, and use a drop-down list for status so quoted, quote sent and qtd stop counting as different things. Add an owner column and a next-action date, and sort by that date every morning.
What a shared sheet still can't do is come to you. A follow-up date in a cell only works if someone looks at it on the right day. The sheet holds one row per customer, not a timeline of every call and message. And anyone who can open the file sees every customer in it.
What does a CRM do that a spreadsheet can't?
A CRM turns a list of names into a record of each relationship, plus a to-do list that comes looking for you.
Each customer gets one record with a timeline: the first enquiry, the calls and messages since, each quote, and the latest notes. Tasks have owners and due dates, and the CRM reminds the owner. Jobs move through stages, so you can see what has stalled. Access can follow roles, so a sales assistant sees their own customers while you see everything.
The connections matter most. When your inbox, calendar, phone line and WhatsApp write into the CRM by themselves, the record stays current with far less typing. That's why automation that writes to the CRM for you matters as much as the CRM you pick. A WhatsApp AI chatbot can log each conversation against the customer who had it, and an AI receptionist can put a summary of each call on the customer's record.
A CRM costs things a spreadsheet doesn't: a second subscription that usually rises with every user, time to set it up, and the discipline of working from it every day. If it bills in US dollars, the exchange rate moves your bill too.
Does POPIA care whether customer details sit in a spreadsheet?
POPIA doesn't ban spreadsheets. It applies to personal information you keep electronically, a spreadsheet included, and it cares how you protect it. Copies everywhere make that harder.
Section 19 of the Protection of Personal Information Act requires the business responsible for personal information to take appropriate, reasonable technical and organisational measures to prevent its loss and any unlawful access to it. A customer list that travels as an email attachment is hard to keep under that kind of control.
Section 23 lets people ask whether you hold personal information about them, free of charge, and ask for a record or a description of it. If your customer list exists in five copies, answering properly means finding all five.
A CRM doesn't make you compliant on its own, but one system with individual logins is easier to secure and to search than a file copied across laptops. This is general information, not legal advice; if you hold sensitive records, speak to an attorney who works with POPIA. For consent when messaging customers, see our guide to POPIA and WhatsApp chatbots.
Should you buy an off-the-shelf CRM or build a custom one?
Buy, in most cases. A custom build makes sense only when your work has a shape no product can hold without constant workarounds.
Your spreadsheet can tell you which camp you're in. Look at the columns you've added over the years that no CRM would have out of the box. Say you service swimming pools around Durban North, and your sheet tracks each pool's pump model and last chemical reading. Take that list of columns to every CRM you try. If custom fields hold them comfortably, buy the product. If you'd be bending the product out of shape, a custom build is worth a conversation.
Our page on custom CRM development in South Africa sets out the full build-or-buy decision, including what drives the cost and who should own the code and the data.
How do you move from Excel to a CRM without losing anything?
Clean the sheet, move a small batch and check it, then move the rest on a fixed day and retire the old file:
- Give the sheet one row per customer and one meaning per column. Split cells that mix a name and a number.
- Merge duplicates and fix formats. The same company typed with (Pty) Ltd on one row and without it on another can arrive as two contacts.
- Drop the people you have no reason to keep. Section 14 of POPIA says personal information shouldn't be kept longer than the purpose needs, with exceptions such as records a law requires you to keep.
- Decide which columns become CRM fields and which become notes.
- Import a test batch and check a handful of records by eye.
- Pick a switch-over day, import the rest, then make the spreadsheet read-only so nobody keeps updating the old copy. Set a date to delete it, because it still holds the people you chose not to move.
Then connect the places new customers come from, so the CRM fills itself. Website enquiries are a common leak; our guide to automating follow-up after a website enquiry covers that step.
How does Cognexa help when the spreadsheet runs out?
Often by not building you a CRM at all. Most South African businesses are better served by an off-the-shelf CRM than a custom one, and if off-the-shelf is the better answer for you, we say so.
If you already run a CRM, or have just moved to one, we keep it and wire your phone line and WhatsApp into it, so nobody has to copy calls and chats across by hand. Where your workflow genuinely doesn't fit an off-the-shelf product, we build a custom CRM around your process instead.
What should you check in your own spreadsheet this week?
Pick three customers you dealt with last month and try to answer these from the sheet alone. When did they first get in touch? What did you quote or sell them? When did someone last speak to them, and what was said? What happens next, and who's doing it?
If the sheet answers all of it, keep it and tidy it. If you had to open WhatsApp, search your inbox or ask a colleague, your business is already being run from somewhere other than the sheet. That's the point to move, and the gaps you just found are the first fields your CRM needs.