> For the complete documentation index, see [llms.txt](https://guides.mangoapps.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://guides.mangoapps.com/admin-guide/user-provisioning-and-management/add-users/import-users.md).

# Import Users

### Overview

The **Import Users** feature in MangoApps allows **network admins** and **organization admins** to bulk import and invite users using a **CSV file**. This enables onboarding by adding a large number of users at once, reducing manual effort.

<figure><img src="/files/OjFJ0aPdoiGNX2IGkK9j" alt="" width="563"><figcaption></figcaption></figure>

***

### **Preparing the CSV File**

To ensure a successful import, **the CSV file MUST be formatted correctly**.&#x20;

<figure><img src="/files/2U0ANccRl9Y22ovEdMfa" alt=""><figcaption></figcaption></figure>

Below is a list of out-of-the-box fields that can be synced through a CSV file. **Either 'email/login' or 'employee ID' is required**:

#### **Fields in the CSV File**

* **name** – Full name of the user (Displayed as "User Name" in the Admin Portal).
* **firstname** – The user's given name.
* **lastname** – The user's surname or family name.
* **email/login** – Unique email ID/login ID (Primary identifier for users). Mandatory.
* **Date of Birth (dob)** – The user's birthdate (MM/DD/YY format).
* **title** – The user's job title or designation.
* **organization** – The company or department the user belongs to. Must match an existing organization on the domain for automatic assignment
* **phone** – The user's contact number.
* **desktop\_extension** – The user’s internal phone extension.
* **mobile** – The user's mobile phone number.
* **manager** – Manager assigned to the user (for reporting structure).
* **Enabled** –  This column determines the user account status, with supported values being `TRUE`, `FALSE`, and `DELETED`.
  * `TRUE` – The account is enabled.
  * `FALSE` – The account will be disabled.
  * `DELETED` – The account will be deleted during the CSV import.
* **locale** – The user’s preferred language and region settings (Must match the Admin Portal language list).
* **Office Locations** – The physical office locations associated with the user (Must match an existing office location on the domain).
* **also known as** – Alternative names or nicknames.
* **education** – Details about the user’s academic background.
* **experience** – Work experience and employment history.
* **expertise** – Areas of specialization or skills.
* **employee id** – A unique identifier for the user (mandatory).
* **profile image** – The user’s profile picture. <mark style="color:red;">This option is</mark> <mark style="color:red;"></mark><mark style="color:red;">**only**</mark> <mark style="color:red;"></mark><mark style="color:red;">available through sFTP Import process (fetch from URL). Regular CSV import</mark> <mark style="color:red;"></mark><mark style="color:red;">**cannot**</mark> <mark style="color:red;"></mark><mark style="color:red;">load profile images.</mark>
* **gender** – The user's gender identity.
* **Languages Known** – Languages the user can speak or understand.
* **relationship status** – Marital or relationship status.
* **Name Of Children** – Names of the user’s children, if applicable.
* **alternate email** – A secondary email address for the user.
* **date of joining** – The date the user joined the organization.
* **address** – The user's residential or office address.
* **skype** – The user’s Skype ID for communication.
* **Social Media Handles** – Links or usernames for social media accounts.
* **bio** – A brief biography or personal summary of the user.
* **DefaultPassword** – The initial password assigned to the user.
* **User Role** – The role assigned to the user within the system.
* **Add To Teams** – Specifies teams or groups the user should be added to.
* **Restricted user** – Indicates if the user has limited access or permissions. The supported values for this column are 'Y' or 'N', meaning yes or no. **Yes** means the user will be in a restricted role and **No** indicates the user will be a normal user.
* **Skills** – A list of the user’s professional skills.

{% hint style="danger" %}
**Do not modify field names in the first row of the CSV file**, as this may cause data mapping issues.&#x20;
{% endhint %}

**Download a sample CSV file** using the **View sample CSV format** link in the Admin Portal.

***

### **How to Import Users**

**Upload the CSV File**

* Click **Browse File**, select the **CSV file**, and click **Open**.

**Choose an Import Option**

* **Skip the records** → Prevents updates to existing users.
* **Update existing users** → Updates all existing users with the CSV data.

**Additional Configurations**

* ✅ **Allow out-of-network users to be imported** – Allows adding users with non-company email domains.
* ✅ **Auto-send invites to new users** – Automatically emails login credentials to new users.

**Click Import Now** to start the process.

***

### **Post-Import Actions**

* The **network admin** receives an email confirming the import status.
* If "Invite users without an Email ID" is disabled in **Admin Portal > Domain > General Settings**, users without an email are skipped.
* Imported users are automatically assigned the **"Network User"** role, regardless of email domain.

***

### **FAQs**

#### **What role is assigned to users imported via a CSV file?**

All users imported via CSV are assigned the **Network User** role.