Still Running Your Business on Excel? When It’s Time to Build a Custom App
Excel is brilliant — until it becomes your operating system. Here are the signs your spreadsheets have outgrown themselves, and what replacing them looks like.
Nearly every South African business runs on Excel somewhere. Job sheets, stock counts, timesheets, quotes, safety registers, sales pipelines. There is nothing wrong with that — until the spreadsheet stops being a tool and starts being the system the business depends on.
Signs you have outgrown your spreadsheets
- Files named "FINAL v3 (Johan edits)" are being emailed around.
- Only one person really understands how the main workbook works.
- Month-end reporting takes days of copying and checking.
- Two people overwrite each other’s changes.
- Nobody can see who changed a number, or when.
- Staff in the field send photos or WhatsApps that someone types into Excel later.
The hidden cost of spreadsheet-run operations
The licence cost of Excel is tiny. The real cost is time and risk: hours spent re-capturing data, decisions made on yesterday’s numbers, errors that nobody spots, and key-person dependency when the person who built the workbook goes on leave or resigns.
What replacing Excel actually looks like
A custom business app keeps what works about your spreadsheet — the columns, the logic, the way your team thinks — and puts it into a proper system: one database, proper user logins, forms that validate input, automatic calculations, an audit trail and live dashboards.
| In Excel | In a business app |
|---|---|
| Emailed versions | One live system everyone uses |
| Anyone can edit any cell | Roles and permissions |
| No history | Full audit trail |
| Manual month-end reports | Live dashboards |
| Typed in later from WhatsApp | Captured on a phone at the source |
A sensible way to make the move
- Pick the one spreadsheet that causes the most pain.
- Walk through how it is really used — not how it was designed.
- Build a first version that replaces it, and import the existing data.
- Run both side by side briefly, then switch off the spreadsheet.
- Add the next process to the same system.
Often the spreadsheet is only half the story — the rest happens in WhatsApp and on paper. See how to replace Excel, WhatsApp and paperwork with one system, or look at the custom business software we build.
Questions
Can we keep exporting to Excel?
Yes. Most business apps include Excel or CSV export, so finance and management can still work with the data they are used to.
Will we lose our historical data?
No. Existing spreadsheet data is normally imported into the new system as part of the switch-over.
About the author
Juan Kotzee
Founder & Managing Director — Drivatic
Juan Kotzee is the Founder and Managing Director of Drivatic, a South African software company specialising in custom business applications, analytics, automation and AI.
What is slowing your business down?
If your team is working around spreadsheets, manual processes or software that does not fit, show us how you work.
We’ll show you what a custom business app could look like.
Related insights
How to Replace Excel, WhatsApp and Paperwork With One Business System
Spreadsheets for tracking, WhatsApp for approvals, paper for the field. Here is how to bring it all into one system without disrupting the business.
Read articleWhat Is a Custom Business Web App — and What Can It Replace?
A plain-English explanation of custom business web apps, how they work, and the spreadsheets, paper forms and subscription tools they typically replace.
Read articleBusiness Process Automation in South Africa: Where to Start
Automation is not about robots. It is about removing the copying, chasing and checking that eats your team’s week. Here is where to begin.
Read article