Import users
Add or update a large number of user accounts by importing them from a user data file.
Supported file formats
- XLS (Microsoft Excel 97-2003 Worksheet)
- XLSX (Microsoft Excel Open XML Format Spreadsheet)
- CSV (Comma Separated Values)
- VCF (vCard File)
Supported encodings
- UTF-8 (Unicode)
- UTF-16 (Unicode)
- ISO-8859-1
- ISO-8859-2
- ISO-8859-9 (Turkish)
- GB2312 (Simplified Chinese)
- Big5 (Traditional Chinese)
- Shift_JIS (Japanese)
- GBK
- Windows-1251 (Cyrillic)
Mandatory fields
- Email address - If you have to import multiple email addresses, keep them in separate columns and map them all to the Email Address field using the
icon.
- Password - All passwords in the mapped column must be at least eight characters long, and contain at least one each of letters, numbers, and special characters.
- Custom fields - If you created mandatory custom fields in the admin panel, they must also be mapped to a column.
Prerequisites
Roles required to perform the import action:
- Organization Owner
- Organization Admin
Steps to import users
The steps to import users vary between the three User Interface versions supported in Zoho One. Select the UI version you use from the tabs below and proceed with the steps that follow.
- Sign in to Zoho One ,then click the Admin Panel icon
on the top-right corner.
- Click on User Management on the left menu, the Users tab will open by default.
- Click the kebab menu
.
- Click Import.
- Choose the user data file and its Character Encoding, then click Next.
- Map the fields between the user data file and Zoho One. If the file doesn't have a Password field, you can set a common one-time password for all imported users.
The users will be prompted to set a password at their first sign-in.
- If there were any problems during
import, there will be a list of users who weren't imported, along with
the reason and solution. You can choose to resolve the problems to
continue importing, or skip the problematic users and import the rest.
- Sign in to Zoho One ,then click the Directory Settings icon
on the top-right corner.
- Click on User Management on the left menu, the Users tab will open by default.
- Click the kebab menu
- Click Import.
- Choose the user data file and its Character Encoding, then click Next.
- Map the fields between the user data file and Zoho One. If the file doesn't have a Password field, you can set a common one-time password for all imported users.
The users will be prompted to set a password at their first sign-in.
- If there were any problems during
import, there will be a list of users who weren't imported, along with
the reason and solution. You can choose to resolve the problems to
continue importing, or skip the problematic users and import the rest.
- Sign in to Zoho One, then click Directory in the left menu.
- Go to Users, then click
.
- Click Import.
- Choose the user data file and its Character Encoding, then click Next.
- Map the fields between the user data file and Zoho One. If the file doesn't have a Password field, you can set a common one-time password for all imported users.
The users will be prompted to set a password at their first sign-in.
- If there were any problems during import, there will be a list of users who weren't imported, along with the reason and solution. You can choose to resolve the problems to continue importing, or skip the problematic users and import the rest.
One Experience UI
Spaces UI
Unified UI
One Experience UI
Spaces UI
Unified UI
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
Zoho FSM Video Tutorials
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho CPaaS?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Add & Import Lite Users
Before you can add Lite users, ensure the following: Permission requirements: Organization Owner Organization Admin License requirements: At least one Lite-user add-on must be purchased and available in your organization You must have unused ...App Migration with Lite Users
When you add a standalone Zoho application (like Zoho Books or Zoho CRM) to your Zoho One organization, existing users are automatically migrated from the standalone app. This article explains how migration affects Lite user licenses and what happens ...Add user
Overview In Zoho One, you can add users such as employees or lite users and manage them by assigning applications, setting security policies, assigning roles, managing their devices, and much more. To add multiple users, you can either import users ...Assign Extended Apps to Users
This article explains how to assign, import, and remove Extended Apps for users. How assignment works Assigning an Extended App to a user automatically assigns the corresponding add-on license. Removing or disabling the application for a user ...Troubleshooting Lite Users & Add-ons
This guide helps you resolve common issues with Lite users and Lite-user add-ons in Zoho One. If a Lite User Add-on isn't visible If you can't see a Lite-user add-on on your Manage Add-ons page: The app supported by the add-on must already be added ...
New to Zoho LandingPage?
Zoho LandingPage Resources