---
title: Preparing Data for Import (Users)
description: "These rules are for importing users only. For records in modules, see [Preparing Data for Import (Default)](https://support.symbiant.co.uk/kb/preparing-data-for-import/). **Warning:** Follow these rules carefully. If you're unsure, raise a support ticket and we'll help you through it. ## An Example File ![An…"
url: "https://support.symbiant.co.uk/kb/preparing-data-for-import-users/"
updated: "2026-10-30"
category: Importing Data
tags:
  - Add
  - Import
  - User
---

# Preparing Data for Import (Users)

These rules are for importing users only. For records in modules, see [Preparing Data for Import (Default)](https://support.symbiant.co.uk/kb/preparing-data-for-import/).

**Warning:** Follow these rules carefully. If you're unsure, raise a support ticket and we'll help you through it.

## An Example File

![An example users import file](https://support.symbiant.co.uk/wp-content/uploads/2026/10/preparing-data-for-import-users-01-prep-users-csv.png)

## The Rules

1. **Save the file as CSV (UTF-8).**
2. **One column per field.**
3. **Every user needs a name and an email address.**
4. **Email addresses must be unique and valid.** A duplicate email address stops the import with an error.
5. **Match the case exactly.** `John@company.com` and `john@company.com` are treated as different.
6. **Avoid commas and special characters** in column headings and values.
7. **Write divisions as full paths** with a forward slash (/) between levels, for example `Company/UK/Sales`. Include the top division and leave out the permission group name.
8. **You can only assign divisions you have access to.** To give a user `Company/UK`, your own account must be assigned to `Company` or `Company/UK`.
9. **Set the Active? status.** Imported users are active by default, and every active user takes a licence seat. To import a user as inactive, put `FALSE` in their **Active?** column.
10. **Add a phone number** for users who will use multi-factor authentication by text message.

## Multiple Roles and Divisions

Put more than one role or division in the same cell, separated by a pipe (|) with no spaces:

- Roles: `risk_manager|incident_manager`
- Divisions: `Company/UK/Finance|Company/UK/IT`

Role names must match the system exactly. See the [User Roles Reference](https://support.symbiant.co.uk/kb/user-roles-reference/).

## Next Step

[Importing Users](https://support.symbiant.co.uk/kb/importing-users/)
