Users - Import Users | Admin Guide - Zoho One

Import users

Add or update a large number of user accounts by importing them from a user data file.

Supported file formats

  1. XLS (Microsoft Excel 97-2003 Worksheet)
  2. XLSX (Microsoft Excel Open XML Format Spreadsheet)
  3. CSV (Comma Separated Values)
  4. VCF (vCard File)

Supported encodings

  1. UTF-8 (Unicode)
  2. UTF-16 (Unicode)
  3. ISO-8859-1
  4. ISO-8859-2
  5. ISO-8859-9 (Turkish)
  6. GB2312 (Simplified Chinese)
  7. Big5 (Traditional Chinese)
  8. Shift_JIS (Japanese)
  9. GBK
  10. Windows-1251 (Cyrillic)

Mandatory fields

  1. 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.
  2. 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.
  3. Custom fields - If you created mandatory custom fields in the admin panel, they must also be mapped to a column.

Steps to import users

  1. Sign in to Zoho One , then click Directory in the left menu.
  2. Go to Users, then click .
  3. Click Import.
  4. Choose the user data file and its Character Encoding, then click Next.
  5. 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.
  6. 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.

    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 CRM Training
      Redefine the way you work
      with Zoho Workplace

        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 CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now

            Zoho Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION

                                    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.

                                        Manage your brands on social media

                                          Zoho Desk Resources

                                          • Desk Community Learning Series

                                          • Digest

                                          • Functions

                                          • Meetups

                                          • Kbase

                                          • Resources

                                          • Glossary

                                          • Desk Marketplace

                                          • MVP Corner

                                          • Word of the Day

                                            Zoho Marketing Automation

                                              Zoho Sheet Resources


                                                  Zoho Forms Resources

                                                    Secure your business
                                                    communication with Zoho Mail

                                                    Mail on the move with
                                                    Zoho Mail mobile application

                                                      Stay on top of your schedule
                                                      at all times

                                                      Carry your calendar with you
                                                      Anytime, anywhere

                                                            Zoho Sign Resources

                                                              Sign, Paperless!

                                                              Sign and send business documents on the go!

                                                              Get Started Now

                                                                      Zoho TeamInbox Resources

                                                                              Zoho DataPrep Resources

                                                                                Zoho DataPrep Demo

                                                                                Get a personalized demo or POC

                                                                                REGISTER NOW

                                                                                  Design. Discuss. Deliver.

                                                                                  Create visually engaging stories with Zoho Show.

                                                                                  Get Started Now

                                                                                                      • Related Articles

                                                                                                      • Add user

                                                                                                        In order to Add users, you need to be an admin in your organization. In the mobile application: For iOS devices: Open the Zoho One app on your mobile device. Tap at the bottom right, then tap ADD USER. Under Basic Info: Enter the user's First name ...
                                                                                                      • User classification

                                                                                                        User types A user type defines the extent to which a user has consented to become a member of a particular organization and collaborate with it. The three user types include Pending users, Confirmed users, and External users. Pending users A user ...
                                                                                                      • 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 ...
                                                                                                      • Edit user details

                                                                                                        You can edit a user's details, such as their info, photo, and email address. Follow the steps to edit the details of a user: In the mobile application: For iOS devices: Open the Zoho One app on your mobile device, then tap  in the top right corner. ...
                                                                                                      • Reinvite a pending user

                                                                                                        Prerequisites Permission required to perform this action: Add Users Reinvite a pending user You can reinvite a pending user to join your organization by re-sending an invitation email to them, up to three times. If the user still didn't accept the ...
                                                                                                        Wherever you are is as good as
                                                                                                        your workplace



                                                                                                          Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.


                                                                                                          Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.


                                                                                                          Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.

                                                                                                          CRM Tips

                                                                                                          Make the most of Zoho CRM with these useful tips.

                                                                                                            Zoho Show Resources