# 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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://guides.mangoapps.com/admin-guide/user-provisioning-and-management/add-users/import-users.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.