On this page
When should you turn your Excel into a web app? When several people work in the same file at once, when mistakes cost money or customers, or when customers and staff need to view or enter data themselves. Start with the task that costs most time, move your existing data with an import that reports what did and did not come over, run both side by side for a while, and drop Excel only when the new platform has proven itself. A first phase usually costs a few tens of thousands of euros and pays for itself in hours and mistakes.
How we build such platforms: custom software and web application development.
Why Excel lasts so long
Excel is fast, flexible and everyone can use it. A schedule, a booking system, customer files, even transport planning: it can all be done. You build it yourself, change it whenever you want and it costs nothing extra. A worksheet holds over a million rows (1,048,576); size is rarely the problem.
The problem is that the file grows with your business, but was never built to run one. It knows no users, no permissions, no rules and no history of who changed what. Scheduling is usually the first thing to pinch; see Excel scheduling or planning software.
Signs you are outgrowing Excel
- Several people work in the same file and overwrite each other.
- Only one person understands how the file works, and they are about to go on leave.
- You copy data from one tab or file to another.
- A broken formula is only noticed weeks later.
- Customers or staff call or email for information that sits in your file.
- You send sensitive data, such as national ID numbers or salaries, around as attachments.
Rows that become modules
One file, everything mixed
The platform
- 309EmployersEvery file in one place.
- 971EmployeesWith their file and documents.
- Work permitsThe platform warns before they expire.
- Meal and eco vouchersNo longer in a separate tab.
- Portal for clients
- Log of who did what
- Two-factor login
We tested the import on Business Centrum's real file: 309 employers and 971 employees, with a report of what did and did not come over.
What is in your Excel, and what it becomes in a platform
| In your Excel | In your own platform | What you gain |
|---|---|---|
| A tab per kind of data | A module per subject: customers, employees, trips, stock | Everything in one place, linked |
| Colours and notes as rules | Rules in the software, with warnings | A work permit about to expire is flagged before you notice |
| A shared folder of attachments | Documents per file, with permissions | Who may see what is fixed |
| "Who has the file open?" | Everyone works at once, with an audit log | No more versions by email |
| Customers calling for information | A portal where customers see their own file | Fewer questions, more trust |
| A report you build by hand | An export or report in one click | Hours a month back |
Five steps from spreadsheet to platform
- Write down what you do every weekFor one week, every task you do in or around your Excel. That list is the basis of your platform, and of an honest price.
- Start with the biggest time sinkDo not build everything at once. Start with the task that costs most time or causes most mistakes.
- Migrate your data with a checkAn import that reads your Excel and reports what did and did not come over, so nothing quietly disappears.
- Run both for a whileWork in both for a short period until you are sure the platform is right. Agree the day Excel stops in advance.
- Let go of Excel and keep buildingThen come the next tasks: a portal for customers, an app for staff, reports.
What a first phase costs, and what it returns
An example: an office with four staff keeping files in Excel. They retype data, search for documents and answer customer calls. We count 40 euros wage cost per hour and an example rate of 85 euros an hour for the build, inside the Belgian market range. Put in your own wage cost and rate: the sum works the same way. Before VAT.
| Today in Excel | After phase 1 | |
|---|---|---|
| Retyping and searching | 4 x 4 hours a week = 16 hours | 4 hours a week |
| Calls and emails for information | 6 hours a week | 2 hours a week (less with a client portal in phase 2) |
| Fixing mistakes | 2 hours a week | 0.5 hours a week |
| Hours per year (46 weeks) | 1,104 hours, 44,160 euros | 299 hours, 11,960 euros |
| Phase 1 build | about 280 hours, 23,800 euros | |
| Hosting and upkeep | about 1,800 euros a year |
In this example phase 1 saves about 32,000 euros of hours a year and pays for itself in under a year. The hours are an example; count your own for a week. What software costs and what drives the price: custom software development cost.
How long does the switch take?
A first phase around one task takes weeks, not months: a few weeks to build, a few weeks running both, and then you drop Excel for that task. Later phases stack on top while the first already works. At DA Logistics, planning board, fleet and a driver app were added this way within a few months. What decides the duration is less the building than the decisions on your side: which rules apply, who may see what, and how clean your current data is.
What your own platform does better
Everyone works in the same data
No more versions by email, no more "who has the file open?". Every change is visible to everyone at once, with a log of who did what.
Permissions per person
A driver sees his own trips, a customer their own file, an accountant the figures they need. In Excel everyone sees everything, or you split files. A client portal lets customers see and upload their own documents.
Rules that do not break
In a platform your company's rules sit in the code: a work permit expiring, a scheduling conflict, stock running low. The platform warns you, instead of you having to spot it.
Secure, with a backup
Sensitive data does not belong in an attachment. The GDPR requires appropriate security for personal data; a platform with two-factor login, encryption and a daily backup is safer than a shared folder.
How Business Centrum left Excel behind.
Business Centrum, a payroll and HR office in Ghent, managed employers, employees, work permits and vouchers in Excel. We built a management tool with a portal for their clients, two-factor login and encrypted sensitive data.
We tested the Excel import on their real file, with 309 employers and 971 employees, and a report of what did and did not come over.
A package or your own platform?
For standard work, such as invoicing or a simple CRM, a package is cheaper and faster. Your own platform pays off when your work has its own rules, when customers or staff must work in the system themselves, or when you now run three packages with a spreadsheet in between. How to weigh that: Odoo or custom software and build vs buy software. The difference between a CRM and an ERP helps you name what you are really after.
Mistakes when switching
- Everything at onceA full platform in one phase is expensive and risky. Start with one task.
- Underestimating the importMessy spreadsheets with duplicate customers and free text need cleaning. Plan it in.
- Never letting go of ExcelTwo versions of the truth are worse than one.
- Leaving your team outHave the people who work in Excel every day test the design.
- No ownerSomeone on your side decides what the platform must do, and has time for it.
Ready for a quote in four steps
- For one week, write down what you do in and around your Excel, and how long it takes.
- Mark the task that costs most hours or the most expensive mistakes.
- Make a copy of your Excel without sensitive data, as an example for a developer.
- Fill in our software requirements template and ask for a price for phase 1.
Questions about moving from Excel to a web app
When is Excel no longer enough?
When several people work in the same file at once, when mistakes cost money or customers, or when customers and staff need to view or enter data themselves. Size is rarely the problem: a worksheet holds over a million rows.
Can I move my data from Excel into a platform?
Yes. A good import reads your Excel and shows a report of what did and did not come over. Test that import on your real file, not a cleaned-up copy: you see straight away which rows need cleaning.
How much does it cost to turn Excel into a web app?
A first phase around one task usually costs a few tens of thousands of euros. In our example about 24,000 euros, earned back in under a year of saved hours. It depends on tasks, users and integrations.
Do I have to replace everything at once?
No. Start with the task that costs most time, run both for a while, then keep building: a portal for customers, an app for staff, reports.
Is a platform safer than Excel?
Usually. You can set permissions per person, log in with two-factor authentication, encrypt sensitive data and back up daily. An Excel attachment cannot do that.
Can I keep using Excel next to the platform?
For analysis, yes: an export to Excel stays handy. But the data itself belongs in one place. Agree that the platform is the source and Excel only a temporary copy.