ODOO GUIDE

Odoo Advanced Import Pro Guide: Import Data from CSV, Excel, XML, JSON & APIs

Odoo 14.0 Odoo 15.0 Odoo 16.0 Odoo 17.0 Odoo 18.0 Odoo 19.0

Import data into Odoo from CSV, XML, Excel, or JSON — from a file, a link (URL), or an API — with field matching, preview, filters, and clear success/error logs.

By Akash Soni March 26, 2026

Setup Module + Install + Access

Complete beginner setup: add the addon to addons path, restart, update Apps list, install, confirm menu, and give user access.

Start an Import (File, URL, or API)

Pick a format, select the target screen, and load your data correctly.

Match Your Columns to Odoo Fields

Use Auto Map, then fine-tune so data lands in the right place.

Import Only the Rows You Want (Filters)

Set rules like “Status = Active” so only matching rows are imported.

Preview + Choose Create / Update

Decide whether to create new records, update existing ones, or both.

Track Progress (Pause / Resume / Stop)

Imports can run in the background. Learn how to control them safely.

Scheduled Imports (Run Automatically)

Run imports daily/weekly/monthly—or once—without manual work.

Help Guide Screen + Sample Files

Use the built-in Help Guide and start with sample files included in the module.

Key Features

feature_icon
Works with any Odoo screen

You choose the Target Model (Contacts, Products, Orders, or any custom screen).

feature_icon
Multiple formats

Import from CSV, XML, Excel, or JSON—whichever your business already uses.

feature_icon
Upload, URL, or API

Bring data from a file on your computer, a public link, or an external system’s API.

feature_icon
Smart field mapping

Auto Map matches common names, then you can fine-tune where each column goes.

feature_icon
Preview before import

Check the first 5 rows to confirm values land in the right Odoo fields.

feature_icon
Create or Update

Create new records, update existing ones, or do both with a Unique Field.

feature_icon
Filters (optional)

Import only the rows you want—like “Status = Active” or “Email is not empty”.

feature_icon
Logs + downloadable errors

Row-by-row messages help you fix issues quickly and download an error report.

feature_icon
Pause / Resume / Stop

Control long imports safely while tracking progress.

feature_icon
Scheduled imports

Run imports automatically (once, daily, weekly, monthly, yearly, or custom).