How to Migrate From Excel Spreadsheets to Apragya Without Losing a Single Row
For owners and office managers running the business on workbooks: turn sheets into records, clean them on the way in, and give each person the part they need.
Most Indian SMEs that migrate from Excel spreadsheets have run on them for years, and sensibly so. A workbook is flexible, free and familiar. It holds the customer list, the stock register, the attendance and often the outstanding report the owner reads every evening.
The trouble arrives with growth. Two people edit different copies, a formula breaks silently, nobody knows which file is current, and there is no record of who changed a rate.
This guide covers how to prepare the sheets, the import order, an illustrative move at a Nagpur agri inputs dealer, and what to keep in Excel.
How to migrate from Excel spreadsheets: prepare, import, stop
Prepare each sheet so it has one header row, one record per row, no merged cells, no subtotal rows, and dates and numbers stored as values rather than text. Remove duplicates and fill mandatory fields such as GSTIN, state and HSN.
Import in dependency order: customers and suppliers, then items, then employees, then opening stock and balances. Preview each file and map its columns before anything is written.
Then stop. Once a sheet is imported, the record in the system is the truth, and the workbook becomes history.
- One header row, one record per row.
- Fix dates, numbers and duplicates.
- Import parties, items and employees.
- Load opening stock and balances.
- Freeze the workbooks.
What running on workbooks costs
Versions
Several copies, and nobody sure which is right.
Broken formulas
One pasted row breaks a total without warning.
No access control
Everyone who has the file sees everything.
No trail
No record of who changed a price or a balance.
An illustrative move at a Nagpur agri inputs dealer
Take an illustrative dealer in seeds, fertiliser and crop protection with three counters and a workbook for each: customers with credit, stock with batches, and a sales register.
One workbook row, as it arrived
Stock row, before import
Two spellings found and merged.
Added before import so invoices carry it.
Carried into the opening stock.
Written as a date, not text.
Agreed to a physical count.
Matched to a warehouse.
The preview showed the date problem before anything was written, so the dealer fixed the column once instead of chasing errors later. Opening stock came in with batch and expiry, and the first sale picked the earliest-expiring lot.
How to move from spreadsheets to ERP, step by step
Step 1 of 5
Clean
One header row, one record per row, dates as dates.
- Clean: One header row, one record per row, dates as dates.
- Preview: Upload a CSV or Excel file and see headers and sample rows.
- Map: Match each column to an Apragya field.
- Import: Masters first, then opening stock and balances.
- Agree: Check totals against the workbook before switching.
Excel to ERP migration: what you gain
Excel is a good tool for analysis. It is a poor system of record once more than one person depends on it. Records in Apragya carry validation, access control and history.
Workbooks and Apragya
| Feature | Excel workbooks | Apragya |
|---|---|---|
| Current version | Whichever file was saved last | One record everyone reads |
| Validation | Whatever the formulas check | GSTIN, dates and required fields checked |
| Access | Whole file or nothing | Role-based down to sub-features |
| History | Not recorded | Audit log of user, action and time |
| Analysis | Excellent | Reports, plus export back to Excel |
Checked against public information on 16 September 2026.
After the workbooks
One record
Customer, item and employee shared by every app.
Checks on entry
Wrong GSTINs and dates caught at once.
Batches and expiry
Stock picked by expiry, not memory.
On the phone
A phone-friendly web app for the team.
Copilot
Ask about sales or stock in plain words.
Export still works
Reports download to Excel when you want them.
See batch tracking, products and cloud ERP for India.
Getting started
- Collect every workbook the business depends on.
- Pick one master copy of each and clean it.
- Import customers, suppliers and items first.
- Load opening stock and balances at a month start.
- Stop editing the workbooks and keep them as history.
Keep Excel for analysis. Stop using it as the place where the truth lives.
What it costs to start
Moving off Excel, answered
Which file formats can we import?
Our sheets have merged cells and totals. Is that a problem?
Can we still get data out to Excel?
How long does it take?
What does it cost to start?
Turn your workbooks into records
Clean one sheet, preview it, and import it today.