Skip to main content
Apragya AIFree quotation builderQuotation builderQuote builderno signup
Migration guide

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.

A shop manager moving a bundle of sheets into a tidy box in an agri inputs shop

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.

  1. One header row, one record per row.
  2. Fix dates, numbers and duplicates.
  3. Import parties, items and employees.
  4. Load opening stock and balances.
  5. 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

  1. Two spellings found and merged.

  2. Added before import so invoices carry it.

  3. Carried into the opening stock.

  4. Written as a date, not text.

  5. Agreed to a physical count.

  6. Matched to a warehouse.

Every stock row needed a date format fix and an HSN code before it could come in.

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.

Hands arranging seed packets so the amber-tagged ones sit in front
With batch and expiry imported, the earliest-expiring lot moved to the front of the shelf.

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.

  1. Clean: One header row, one record per row, dates as dates.
  2. Preview: Upload a CSV or Excel file and see headers and sample rows.
  3. Map: Match each column to an Apragya field.
  4. Import: Masters first, then opening stock and balances.
  5. 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

FeatureExcel workbooksApragya
Current versionWhichever file was saved lastOne record everyone reads
ValidationWhatever the formulas checkGSTIN, dates and required fields checked
AccessWhole file or nothingRole-based down to sub-features
HistoryNot recordedAudit log of user, action and time
AnalysisExcellentReports, 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

  1. Collect every workbook the business depends on.
  2. Pick one master copy of each and clean it.
  3. Import customers, suppliers and items first.
  4. Load opening stock and balances at a month start.
  5. 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

Free
Up to 3 users
CRM, HR and Vendor Onboarding
INR 3,999
Starter, a month
Up to 10 users, CRM and HR plus a choice of apps
INR 7,999
Pro, a month
Up to 25 users and every enterprise app

Moving off Excel, answered

Which file formats can we import?
CSV and Excel files, with a preview of headers and sample rows before import.
Our sheets have merged cells and totals. Is that a problem?
Remove them first. Imports expect one header row and one record per row.
Can we still get data out to Excel?
Yes. Reports and lists export to CSV or Excel.
How long does it take?
For a small business with clean sheets, a few days of preparation is typical. Cleaning takes longest.
What does it cost to start?
The free plan covers up to 3 users with CRM, HR and Vendor Onboarding and 1,000 AI Credits a month. Starter is INR 3,999 a month for up to 10 users, with CRM and HR plus a choice of apps such as Sales and POS, Inventory, Payroll, Purchase and Payables, Support and Manufacturing. Pro is INR 7,999 a month for up to 25 users with every enterprise app, including Finance and Accounting, plus 5,000 AI Credits, single sign-on and audit logs.

Turn your workbooks into records

Clean one sheet, preview it, and import it today.