Excel Import Automation for Odoo 19

Advanced Excel import templates for every Odoo model

Excel Import Layer adds a flexible mapping layer before Odoo's standard import engine. Create templates once, map Excel columns to fields in any Odoo model, merge values, group parent-child rows, test safely, and import repeatable files with confidence.

Reusable Templates All Odoo Models Dry-Run Testing XLSX Draft Export No Core Changes

Common problems without a mapping layer

• Excel column names do not match Odoo field names.
• Multiple Excel columns must be merged into one Odoo field.
• Parent and child rows arrive in the same spreadsheet.
• Users repeat the same spreadsheet cleanup for every import.
• Bad relational values break the whole import unexpectedly.

What Excel Import Layer adds

• Saved import templates per Odoo model.
• Excel-to-Odoo field mapping with child field support.
• Column merge rules with configurable separators.
• Grouping logic for parent and one2many line imports.
• Dry-run testing before records are created.

Reusable Import Templates

Create a template for each target model and reuse it whenever files with the same structure arrive.

Excel Column Mapping

Map business-friendly spreadsheet headers to technical Odoo fields without changing the Excel source.

Sum / Merge Mode

Merge multiple Excel columns into the same destination field using a configurable separator.

Header + Value Formatting

Optionally import values as Column Name + Separator + Value for descriptive notes and text fields.

Missing Value Policies

Choose whether to raise an error, create missing relations, ignore invalid values, or skip rows.

Import Draft Download

Generate an XLSX draft file from the configured template so users can fill the expected columns correctly.

Template management

Keep reusable Excel import templates organized by target Odoo model.

Column mapping and merge rules

Map Excel columns to Odoo fields and merge multiple columns into one destination field.

Sales Order imports

Use group columns and child fields to import parent records and lines together.

Master Data

Contacts, products, vendors, customers, pricelists, catalogs, and reference records.

Operational Documents

Sales, purchases, order lines, inventory sheets, and recurring spreadsheet-based operations.

Custom Models

Use the same template mechanism for Studio or custom-developed Odoo models.

Error

Stop the import and show what needs to be corrected.

Create If Missing

Allow new related records to be created when matching is enabled.

Ignore Value

Leave the destination field empty when the value cannot be matched.

Skip Row

Skip only the problematic spreadsheet row and continue processing.

Create Template

Select the Odoo model that will receive the imported data.

Map Columns

Connect Excel headers to Odoo fields and relation paths.

Configure Rules

Set merge behavior, grouping, separators, and missing-value policies.

Test Import

Run a dry-run test without creating records in the database.

Import

Run the final import and open the created Odoo records.

Can I test an import before creating records?

Yes. The wizard includes a Test button that runs the mapped import in dry-run mode.

Can it import parent and child rows?

Yes. Use a group column and map child fields for one2many line imports.

Can I generate an Excel template for users?

Yes. Each saved template can generate a draft XLSX file with expected columns and a mapping sheet.

Does it replace Odoo import?

No. It adds a reusable preparation layer and still uses Odoo's standard import engine.