Import users

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.

    • Related Articles

    • Add user

      In the mobile application: Open the Zoho One app on your mobile device, then tap  in the top-right corner. Tap  at the bottom, then tap ADD USER. Under Basic Info: Enter the user's First name and Last name. In the Email ID field: If you haven't added ...

    • User classification

      User types Pending users A user added with an email address that doesn't belong to a verified domain will receive an invitation through email, and will be Pending until they accept it. Example: You are adding Charles, who doesn't have a zylker.com ...

    • 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: Open the Zoho One app on your mobile device, then tap  in the top right corner. Under USERS, tap ...

    • Assign app to individual user

      Sign in to Zoho One , then click Directory in the left menu. Go to Applications, then click the app you need to assign. Click Assign Users, then go to the Individual tab. Choose the user by manually entering their name and searching, or by using the ...