Data Import Mapper & Vali
Map any CSV/Excel column to any model field, validate, dry-run and get an error report
The native importer fails silently on bad data and offers no reusable mapping or custom validation. This module turns messy spreadsheets into clean records in any Odoo model through a saved, repeatable pipeline — with validation that runs before a single record is created and a persistent error log for every run.
Key Features
Reusable import templates
Save a target model, file type, delimiter, encoding and header settings as a template you can reuse for every recurring import.
Auto column detection
Upload a sample file and the template detects its columns automatically, ready for you to map.
Flexible field mapping
Map each source column to a target field or skip it, set default values for gaps, and resolve relations by a chosen search field.
Per-field validation rules
Required, numeric, email, regex, min/max length, value-in-set and unique — checked row by row with a custom error message.
Safe dry-run
Parse, map and validate every row and get a full line-by-line error report — with nothing written to the database.
Create or update modes
Insert new records or match-and-update existing ones by a key field; invalid rows are skipped, reported and exportable as a CSV error report.
No more silent failures
Every rejected row is captured with the exact reason, so you fix the source data instead of guessing what broke.
Repeatable, not one-off
Saved mappings and validation rules turn a painful one-time migration into a reliable, repeatable data-onboarding process.
Screenshots
Import Runs
Import Templates
Why Choose This Module
Data migration teams, ERP implementers and consultants, finance and operations staff loading recurring spreadsheets, and anyone onboarding products, contacts, leads or stock from CSV/Excel into Odoo.
Specifications
- Compatible: Odoo 18.0 / 19.0
- License: OPL-1
- Languages: English
- Author: Pokutsoft
- Dependencies: base
- Support: support@pokutsoft.com
Update date: 2026-07-02