Bulk user imports you can trust from Excel or CSV

Upload a spreadsheet, map the columns, and preview every row before a single record is created. Assign access groups by name, catch bad data before it becomes a broken account, and keep a permanent audit trail of every import you run.

The problem

Onboarding users one at a time through the standard user form is slow and error-prone, and it does not scale to a migration, an acquisition, or a seasonal hiring surge. Odoo's generic import can create users but does not gracefully handle passwords, user types, or access-group resolution by name — a malformed spreadsheet either fails opaquely or silently creates broken accounts, so admins fear bulk imports because one bad row can corrupt an entire batch with no clear way to see what went wrong.

The solution

A guided wizard uploads your.xlsx or.csv file, auto-maps its columns to user fields (including custom fields), and runs a full dry-run validation before anything is created. Fix problems in the preview, then import: valid rows are created even if some rows fail, each isolated in its own savepoint, and every run is logged with per-row results in a searchable Import History for a complete audit trail.

Capabilities

Everything you need for trustworthy bulk onboarding

Every capability below is implemented in the module.

01

Excel & CSV Upload

Upload a.xlsx or.csv file and the wizard auto-detects the format, header row and delimiter for you.

02

Smart Column Mapping

Spreadsheet columns are auto-guessed against user fields, with manual override and mapping to any writable custom field on the user record.

03

Downloadable Import Template

Start from a ready-made.xlsx template with the expected columns, instead of reverse-engineering the file layout.

04

Shared Defaults for the Batch

Apply one user type, access groups and language across every row, so a whole cohort can be onboarded with identical rights in one pass.

05

Access Groups by Readable Name

Assign access groups and technical settings by their display name — no database ID lookups needed to prepare the spreadsheet.

06

Pre-Flight Dry-Run Validation

Every row is checked for missing data, invalid emails, duplicate or existing logins, and unknown groups or languages before a single record is written.

07

Per-Row Error Reporting

The preview lists every row with an ok, warning or error status and a plain-language reason, so you know exactly what to fix and where.

08

Partial-Completion Import

Valid rows are created even when some rows fail — each row runs in its own savepoint, so one bad row never sinks the whole batch.

09

Import History & Audit Trail

Every import is logged with its status, progress and per-row results, giving admins a permanent, searchable record of who imported what and when.

Workflow

How it works

1

Upload your file

Choose a.xlsx or.csv file and set shared defaults such as user type, access groups and language.

2

Map your columns

Review the auto-guessed mapping, adjust it, and point any extra column at a custom field if needed.

3

Review the preview

See every row's dry-run result — ok, warning or error — before anything is committed.

4

Import & track

Confirm the import and find the full result in Import History, with a per-row audit trail you can revisit any time.

Questions

Frequently asked

No sales fog. If your question isn't here, email us and we'll answer it the same way.

Nothing is created until you confirm the import. The dry-run preview flags every problem row first; on import, valid rows are still created even if others fail, and each failed row is reported with the exact reason so you can fix and re-run just those rows.

Get the app

Buy it on the Odoo App Store

Purchase, download and install directly from the official Odoo Apps Store — you'll always get the latest supported build.

Import Users from Excel/CSV

Bulk user creation from Excel or CSV with access groups resolved by readable name, shared batch defaults, a dry run that catches bad rows first, and per-row reporting when one still fails.

Buy on Odoo App Store