How to move from spreadsheets to an ERP
To move from spreadsheets to an ERP, list every sheet the shop depends on, pick the three that cause the most rework, export them as CSV, clean them into one row per item, customer, vendor and BOM line, import them, and go live with stock and work orders first. Run the old sheets in parallel for one month, reconcile, then stop updating them.
By Arunkumar V, CTO · 03 November 2026 · 2 min read
- replace Excel with ERP
- migrate spreadsheets to ERP
- moving from Excel to inventory software
- spreadsheet to ERP migration
Start with an inventory of the sheets
Most shops run on more spreadsheets than the owner knows about: the stock sheet, the order tracker, a BOM per product, a price list, a vendor list, a job costing sheet somebody built once, and the planner's private file. Walk the office and the floor and list them all with who updates each and how often. Then pick the three that cause the most rework or arguments. Those are the first to move. The rest can stay until the ERP has earned trust.
Clean before you import
Spreadsheets tolerate what an ERP will not: merged cells, two item codes for one part, a quantity typed as text, a BOM with a note where a number should be. Cleaning is the real work, and the person who knows the parts has to do it.
- One row per record, one header row, no merged cells or subtotals
- One code per physical item, with obsolete items marked and left out
- One unit of measure per item, with conversion noted if purchasing differs
- BOMs as flat lines: parent, component, quantity, unit, scrap percentage
Go live in the right order
Go live with the stock ledger and work orders first, because the floor needs them every day and they prove the item master is right. Load opening stock from a physical count, not from the sheet's running balance, which has usually drifted. Add purchasing in week two so receipts post stock properly. Bring accounting across at a month end, once the operational data is trusted. Keep customisation to custom fields and a few workflow rules until the standard process has run for a month.
Retire the sheets deliberately
The failure mode is a shop that runs both for a year. Set a date to stop updating each sheet, reconcile stock and open orders once before that date, and make the sheet read-only. Announce the date to the whole team a month ahead. Keep the old files in a dated folder for reference. If someone keeps a private sheet after go-live, it means a report or field is missing in the ERP; add the field or the export rather than tolerating the sheet.
How to move from spreadsheets to an ERP
- Step 1
List every spreadsheet the shop depends on and pick the three that cause the most rework.
- Step 2
Export items, BOMs, customers and vendors as CSV and clean codes, units, duplicates and number formats.
- Step 3
Import the clean files and run three real orders end to end to find gaps.
- Step 4
Count stock, load opening balances and go live with stock and work orders, then purchasing and accounting.
- Step 5
Reconcile once, then make the old sheets read-only on a fixed date.
Where ZMOS fits
ZMOS imports items, customers and vendors from CSV and exports items, customers, vendors and transactions at any time, so a 10 to 50 person shop can move its three worst spreadsheets first. The stock ledger keeps live balances per warehouse and records corrections as new movements rather than edits, which is the main habit that changes when you leave spreadsheets. Custom fields carry the columns your sheets had. It is not the fit if you only need accounting, where a bookkeeping product is simpler.
People also ask
Short answers, each one complete on its own.
Related answers
- Do I need an ERP or a spreadsheet?
- How does ERP data migration work for a small shop?
- What should be on an ERP implementation checklist for a small manufacturer?
- What is an immutable stock ledger?
- Why do ERP implementations fail?
- What should I look for in an ERP demo?
- What questions should I ask an ERP vendor?
- All 54 answers
Inside ZMOS
Which spreadsheet should move to the ERP first?
The stock sheet, because every other process depends on knowing what is on hand, and it is the one that drifts furthest from reality. Work orders come next, then purchasing. Price lists and quotes follow once the item master is trusted.
Can I keep some spreadsheets after moving to an ERP?
Yes, for analysis and one-off calculations fed by exports from the ERP. The rule is that no spreadsheet is the master record of stock, orders or costs. If a sheet is still updated by hand after go-live, something is missing in the setup.
How do I load opening stock?
From a physical count done on the weekend before go-live, entered as an opening movement per item and warehouse. Do not import the spreadsheet's running balance; it usually differs from the shelf, and the ERP would start wrong on day one.
What if the ERP lacks a column my spreadsheet had?
Most systems for small shops allow custom fields on items, orders and customers. Add the field before import so the data is not lost. If the column drives a calculation, check whether the ERP can do it with a rule.
See it on your own stock and jobs
ZMOS is free for six months for startups and registered partners, no card. Or ask an engineer anything on WhatsApp; we reply within 6 hours in working hours.