How to Import Spreadsheet Data
- Step 1. Open Import → New Import and select target module (products, parties, opening balances, etc.).
- Step 2. Choose import mode: Insert, Update, or Upsert; upload CSV or Excel file.
- Step 3. Download sample file for the module if you need the expected column layout.
- Step 4. Map source columns to target fields — use Auto-map for name matches, then open Preview.
- Step 5. Fix validation errors, Execute import, and export error CSV for any failed rows.
Tips
- Upsert matches on key fields — ensure key columns are mapped for update mode.
- Long jobs poll status via the import API while Processing.
Related: Data Import module