Skip to main content
Import Module

Migrate CSV & Excel Spreadsheets Into Live ERP Data

Self-service data migration across inventory, HRMS, accounting, and real estate — 22 import targets, auto column mapping, upsert modes, and exportable error reports. No DBA scripts required.

30 days free on every planNo credit card neededTry the demo account

Auto Mapping Error CSV Export Sample Templates

What Is Data Import Software in ERP?

Data import software migrates spreadsheet data into live ERP records without custom scripts. Biznsbook guides you through upload, column mapping, validation preview, and execution — with upsert support and row-level error reports for transparent, self-service migration.

  • ✓22 import targets — Parties, items, employees, chart of accounts, finance vouchers, opening balances, and real estate modules.
  • ✓Guided workflow — Upload → map columns → preview validation → execute import with progress tracking.
  • ✓Upsert modes — Insert new records, update existing ones, or both in a single job with auto column mapping.

Migrate inventory from Excel → · Payroll migration guide → · All migration guides

Biznsbook Data Import at a glance

Best for
Teams moving products, parties and balances from spreadsheets or a legacy system
Works with
Inventory, Accounting, Integrations, OCR Data Entry and the rest of Biznsbook
Free trial
30 days free on every plan, no credit card. See plans and pricing
Access
Cloud software in any modern browser, on desktop, tablet or phone

Everything You Need for ERP Data Migration

22 import targets, auto mapping, validation preview, upsert modes, sample templates, and exportable error CSV — all self-service.

22 Import Targets

Import master data, finance vouchers, and real estate records across the full ERP — parties, items, employees, COA, warehouses, journals, cash/cheque, and opening balances.

  • ✓ Inventory & HRMS
  • ✓ Accounting & finance
  • ✓ Real estate (REMS)
  • ✓ System setup data

Guided Workflow

Four-step pipeline: upload your file, map columns to ERP fields, preview validation results, then execute the import with real-time progress tracking.

  • ✓ Upload → Map → Preview
  • ✓ Execute with progress %
  • ✓ Resume from any step
  • ✓ Job dashboard history

Upsert Modes

Choose Insert for new data only, Update to modify existing records by key field, or Upsert to insert new rows and update matches in one pass.

  • ✓ Insert mode
  • ✓ Update mode
  • ✓ Upsert mode
  • ✓ Key field per target

Auto Column Mapping

Normalized header matching maps spreadsheet columns to ERP fields automatically. Override any mapping manually and skip unneeded columns.

  • ✓ Header normalization
  • ✓ Manual overrides
  • ✓ Required field metadata
  • ✓ Regex validation rules

Error CSV Export

Row-level error capture with field and message details. Failed rows do not block successful ones — export errors as CSV to fix and re-import.

  • ✓ Partial success
  • ✓ Row + field + message
  • ✓ Downloadable error CSV
  • ✓ Re-run after fixes

Sample Templates

Download sample CSV and Excel templates per import target with comments on required fields, key fields, and max lengths — format data correctly the first time.

  • ✓ CSV templates
  • ✓ Excel templates
  • ✓ Field comments
  • ✓ 10 MB file limit

Move from QuickBooks or Xero

A guided five-step move from another system, with ready-made column presets for QuickBooks and Xero exports.

  • ✓ Steps tick off from your real data
  • ✓ QuickBooks and Xero presets
  • ✓ Header counts match the rows you see

How Does Biznsbook Data Import Work?

From spreadsheet to live ERP records in four guided steps — with validation before anything commits.

1

Upload File

Pick an import target, choose Insert/Update/Upsert mode, and upload your CSV or Excel file — up to 10 MB with blob storage.

2

Map Columns

Auto-mapping matches headers to ERP fields. Override manually, skip columns, and review required field metadata before saving.

3

Preview & Validate

See parsed data in a grid with errors highlighted. Re-run validation after mapping changes — fix issues before committing.

4

Execute Import

Run the import with progress tracking. Successful rows persist; failures export to error CSV for quick correction and re-import.

Data Import Is Part of Your Biznsbook ERP

Migrate parties, items, employees, vouchers, and opening balances — no per-row fees, no DBA scripts, no separate migration tool.

30 days free on every planNo credit card neededTry the demo account

Data Import — Frequently Asked Questions

Quick answers about import targets, file formats, upsert modes, and error handling.

What is Biznsbook Data Import?

A self-service ERP module that migrates CSV and Excel spreadsheets into live business data. It supports 22 import targets with a guided upload → map → preview → execute workflow, auto column mapping, and exportable error reports — no custom database scripts required.

What can I import?

22 registered targets: Parties, Items, Employees, Chart of Accounts, Product Groups, Warehouses, Departments, Cash Payments, Cash Receipts, Journal Vouchers, Cheque Payments, Cheque Receipts, Cash In Bank, Banks, Countries, Currencies, Real Estate Projects, Units, Phases, Leads, Customers, and Opening Balances.

What file formats are supported?

CSV and Excel (.xlsx, .xls) up to 10 MB. Each target includes downloadable sample CSV and Excel templates with comments on required fields, key fields, and validation rules to help you format data correctly.

What is upsert mode?

Upsert combines insert and update in one job. New rows are created; existing rows matching the key field are updated. Use Insert for brand-new data, Update to modify existing records only, or Upsert when migrating a mix of new and existing records.

What happens when rows fail?

Failed rows are captured individually — successful rows still import. Export a CSV showing row number, field name, and error message. Fix the problem rows in your spreadsheet and re-import without re-processing successful records.

How much does Data Import cost?

Data Import is a licensed Biznsbook module included in enterprise bundles. No per-row fees — activate the module and run imports at your own pace. View pricing →

Can I move my data from QuickBooks or Xero?

Yes. The Move from another system guide walks you through five steps and has column presets for QuickBooks and Xero exports.

Is there a free trial of Biznsbook Data Import?

Yes. Every Biznsbook plan starts with a 30-day free trial, no credit card needed. Start your free trial and pick a plan on the pricing page whenever you are ready. Prefer a guided tour first? Book a demo and we will walk you through Data Import.

Try Biznsbook Data Import free for 30 days

Start a 30-day free trial on any plan and run Data Import together with the rest of your business: one platform, one login.

30 days free on every planNo credit card neededTry the demo account

Start free trialBook a demo