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.
Steps to import users
- 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. 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.
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:
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 ZeptoMail?
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 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 ...User classification
User types A user type defines the extent to which a user has consented to become a member of a particular organization. The three user types include Pending users, Confirmed users and External users. Pending users A user added with an email address ...In-App user add-ons
If your organization has exhausted its available user licenses while adding or importing a user, you can purchase additional licenses directly from the Zoho One admin console. Licenses can still be purchased through the Zoho Store. Learn how to add ...Convert external user to organization user
A user in Zoho One is considered to be external if their Zoho account is associated with another organization. Converting an external user as your organization user will allow you to edit, update their account details. You can also manage their ...Delete Pending User
Overview Deleting a pending user allows administrators to revoke an unaccepted invitation, helping to maintain proper access control by ensuring that only intended users receive the invitations. This action may be necessary in the following ...
New to Zoho LandingPage?
Zoho LandingPage Resources