> For the complete documentation index, see [llms.txt](https://help.steeple.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.steeple.com/en/administration/import-collaborateurs.md).

# How do I import collaborators in bulk?

### Introduction

The import feature lets you add or synchronize collaborators in bulk from a file, without having to add them one by one.

### How it works

#### Step 1 — Processing history

From the**Directory**, open the menu **⋮** (three dots) to the right of the title **Employees**, then click on **Import employees**. The page **Import** lists the history of previous synchronizations.

#### Step 2 — Choose the import type

Select the operation type: **add**, **deletion** or **mirror synchronization**.

#### Step 3 — Upload the file

Upload the Excel or CSV file containing the collaborators.

#### Step 4 — View alerts

The system analyzes the file and displays a report of '**alerts** about detected anomalies (invalid rows, missing fields, etc.).

#### Step 5 — Verify the analysis

A report of '**analysis** details the operations that will be performed (creations, updates, deletions).

#### Step 6 — Run the execution

Confirm to launch the **runner** that applies the operations. The status is updated live.

#### Operation types

* **Add** (upsert): create new collaborators or update existing ones
* **Deletion** (delete): remove collaborators
* **Mirror synchronization** (mirror): replace the entire list — collaborators absent from the file are removed

#### Test mode (dry run)

It is possible to run a simulation before actually executing the changes. Test mode displays a report of the planned operations without applying them.

The simulation becomes **mandatory** for a file that assigns or modifies a login ID: this is the only place where you can see, before execution, how many email addresses stop being identifiers.

#### Collaborators without an email address

The template includes a column **Identifier** and a column **TV PIN code**, next to the column **Email**. They allow you to import collaborators who do not have a professional email address.

* Each row must contain at least one identifier: an email address or a login ID.
* A row that assigns a login ID without an email address must contain a 4-digit code, otherwise the collaborator would have no way to activate their account.
* The same identifier cannot appear twice in the file.

Rows that do not comply with these rules are flagged in the alert report before any write: the file is not executed until they have been corrected. See [How to add a collaborator without an email address?](https://help.steeple.com/en/administration/collaborateur-sans-email.md).

#### Services and locations

The columns **Department** and **Location** accept one or more names. To specify several, separate them with a semicolon, with or without a space: `Communication;Production` and `Communication; Production` are read the same way.

The comma does not separate: it is part of the name, as in « Administrative, Finance ».

* **The cell provides the complete list.** It replaces the collaborator's services, or locations, even if it specifies only one. A service or a location absent from the cell is removed from it, even if an administrator had added it manually.
* **An empty cell changes nothing**, any more than a column missing from the file.
* **A name that does not yet exist is created.** Check the spelling to avoid duplicates.

Before execution, the analysis counts the collaborators whose services or locations change in the line « N collaborators will see their organization information modified », including those from whom the file removes a value added manually.

The[collaborator export](https://help.steeple.com/en/administration/exporter-collaborateurs.md) outputs all the services and all the locations of each one, separated by a semicolon: the exported file can be re-imported as is.

To fill them in one by one, see [How do I enter multiple services for an employee?](https://help.steeple.com/en/administration/plusieurs-services.md) and [How do I enter multiple locations for an employee?](https://help.steeple.com/en/administration/plusieurs-lieux.md).

#### Message tracking

Each synchronization operation generates tracking messages indicating the result for each collaborator (success, error, etc.).

### Alternative: SCIM provisioning

For automatic and continuous synchronization with a company Directory (Azure Active Directory, Okta, etc.), see the article "Automatic collaborator provisioning (Provisioning / SCIM)".

### What the assistant can do

The assistant cannot launch a bulk import. It can explain how it works and guide you to the Administration interface. With the Administration scope, the assistant can add collaborators one by one.
