How-to guide
How does an SME move from Excel to a proper system?
By Pali (Wan Muhamad Fadzli), product builder, Penang.
Last updated
An SME in Malaysia moves from Excel to a proper system by picking one spreadsheet that causes the most rework, mapping who edits it and why, cleaning the data, and rebuilding that workflow with logins, roles and a single record per item. Run both side by side briefly, then retire the sheet. A custom web app starts from RM 4,500.
What are the steps?
- 01Pick the spreadsheet that hurts mostChoose the one sheet that staff copy, email or fix most often, such as orders, stock, bookings or customer follow-ups.
- 02Map who touches it and whyList every person who reads or edits the sheet, what they change, what they wait for and which decisions depend on it.
- 03Clean and structure the dataRemove duplicates, split merged cells and free-text columns into proper fields, and agree one identifier per customer, item or order.
- 04Decide buy or buildCheck whether an off-the-shelf tool already fits the workflow before commissioning a custom system for it.
- 05Rebuild the workflow with rolesGive each role a login, the screens it needs and only the actions it may take, with a history of who changed what.
- 06Run in parallel, then retire the sheetImport the cleaned data, run the system beside the sheet for a short agreed period, then lock the sheet as read-only.
When is it time to move off Excel?
It is time when the spreadsheet has become the live record for a team rather than a personal working file. The signs are usually operational, not technical.
- Several people edit the same file and overwrite each other
- Staff keep copies named “final”, “final 2” or by date
- Nobody can tell who changed a figure or when
- Data is copied by hand into WhatsApp, invoices or another sheet
- Some staff should not see every column, but the file has no roles
- Formulas break when someone inserts a row
One of these is a nuisance. Several together mean the business depends on a file that cannot protect its own data.
Which spreadsheet should I replace first?
Replace the one that creates the most rework or the most expensive mistakes, not the biggest one. A small sheet that drives orders or stock can cost more than a large reporting file nobody edits.
| Spreadsheet | Typical problem | What a system adds |
|---|---|---|
| Orders or sales tracker | Duplicate or missed orders across staff | One record per order with a status and owner |
| Stock or inventory list | Counts drift from what is on the shelf | Stock moves recorded per transaction |
| Booking or schedule sheet | Double bookings and manual reminders | Availability checks and automatic reminders |
| Customer follow-up list | Leads forgotten when a staff member is away | Assigned follow-ups with due dates |
| Staff claims or approvals | Approval by message with no trail | Approval steps with a history |
Start with one row of this table. Moving one workflow well teaches you more than moving five at once.
How do I prepare my spreadsheet data?
Clean the data before it moves, because a system stores whatever it is given. Messy data imported quickly becomes messy data that is harder to fix.
- Make a copy of the sheet and work only on the copy.
- Remove duplicate rows for the same customer, item or order.
- Split merged cells and columns that hold more than one value.
- Make each column one type: dates as dates, amounts as numbers.
- Agree one identifier per record, such as an order or customer number.
- Move free-text notes into a separate column instead of inside other fields.
- Mark rows that are inactive or historical so they can be archived.
Keep the original file untouched as a reference until the new system has run without issues.
Should I buy software or build a custom system?
Check off-the-shelf tools first. Building only makes sense when no standard product fits how the business actually works.
| Situation | Better route |
|---|---|
| A standard product covers the workflow with configuration | Buy and configure it |
| Staff copy data between two or more tools you already pay for | Connect or replace with one system |
| The workflow is specific to how your business operates | Build a custom web app |
| You need roles, approvals and history the sheet cannot give | Build, or a tool that supports them |
If you are unsure, the ERP cost guide explains when a broader system makes sense, and the website or app guide covers which format suits staff on the move.
How do I switch over without disrupting daily work?
Switch one workflow at a time, with a short overlap period and a clear cut-off date.
- Import the cleaned data and check totals against the original sheet.
- Train the staff who use that workflow on their own screens only.
- Run the system and the sheet side by side for an agreed short period.
- Compare results daily and fix differences in the system, not the sheet.
- Set the sheet to read-only on the cut-off date.
- Archive the sheet once nobody has needed it for a few weeks.
Name one person who owns the switch. Without an owner, staff quietly drift back to the spreadsheet.
How do I start moving my business off Excel?
Describe the spreadsheet, who uses it and what it should become in the project calculator for a price range. Then use the Discovery Sprint to map the workflow, clean the data plan and fix the scope before building.
See how custom web and mobile app projects work, or compare a ready-made option on the inventory system page if your main sheet tracks stock.