Import Users
Bulk importing users on your domain
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.
Preparing the CSV File
To ensure a successful import, the CSV file MUST be formatted correctly.
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, andDELETED.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. This option is only available through sFTP Import process (fetch from URL). Regular CSV import cannot load profile images.
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.
Do not modify field names in the first row of the CSV file, as this may cause data mapping issues.
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.
Last updated