Import users via CSV

User import via CSV

To add many users at the same time, you can import a CSV file.

Prepare the CSV file

CSV file format

Your CSV file should contain the following columns:

email,first_name,last_name,groups
[email protected],Max,Mustermann,Sales
[email protected],Anna,Schmidt,"Sales,Marketing"
[email protected],Peter,Weber,IT

Required and optional fields

Field	Required	Description
email	Yes	User’s email address
first_name	Optional	First name
last_name	Optional	Last name
groups	Optional	Groups (comma-separated if multiple)

Important format notes

• Separator: Comma (,) or semicolon (;)
• Encoding: UTF-8 for special characters
• Multiple groups: In quotation marks, comma-separated

Run the import

Step by step

1. Go to Admin > Users
2. Click “Import” or “CSV import”
3. Click “Choose file”
4. Select your CSV file
5. Click “Upload”

Check the preview

After uploading, you see a preview:

• Number of users to import
• Detected columns
• Possible errors or warnings

Confirm import

1. Check the preview carefully
2. Correct any errors in the CSV
3. Click “Start import”

After the import

What happens?

• All users receive an invitation email
• Users are assigned to the specified groups
• The status of all users is initially “Pending”

Import report

After completion, you see:

• Successfully imported: Number of new users
• Skipped: Email addresses that already exist
• Errors: Invalid rows with error descriptions

Error handling

Common errors

Error	Cause	Solution
”Invalid email”	Email format is wrong	Correct the email address
”Group not found”	Group name does not exist	Create the group first or check the name
”User exists”	Email is already registered	Remove or ignore the row
”Encoding error”	Wrong file encoding	Save as UTF-8

Correct the CSV file

1. Open the CSV in a text editor or Excel
2. Correct the faulty rows
3. Save as CSV (UTF-8)
4. Run the import again

Create CSV with Excel

Export from Excel

1. Create the data in Excel
2. Go to File > Save as
3. Select “CSV UTF-8 (comma-delimited)”
4. Save the file

Column headers

Use the exact column names:

• email (not “E-mail” or “Email”)
• first_name (not “First name”)
• last_name (not “Last name”)
• groups (not “Groups”)

Download template

Download our template to use the correct format:

1. Go to the import dialog
2. Click “Download template”
3. Open the template in Excel
4. Fill in your data

Best practices

Before import

• Create groups: All referenced groups must exist
• Check data: Check email addresses for typos
• Small tests: Test with a few rows first

During import

• Be patient: Large imports can take a few minutes
• Do not interrupt: Keep the browser tab open

After import

• Check report: Were all users imported successfully?
• Spot checks: Review a few users manually
• Invitations: Confirm receipt with a few users