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 a mixture 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 the Admin Panel.
  2. Go to Users and 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

    • How do I import users from CRM?

      In the Users tab, click the Other Actions icon and select Import from CRM. Enter the details and import users from Zoho CRM.
    • Import users from Zoho Mail Suite

      Zoho Projects provides an option to import users and accounts from Mail Suite. This feature is not available for Zoho CRM Plus and Zoho One users. Click  in the upper-right corner of the top navigation bar. Navigate to the USERS section and ...
    • Import users from Zoho Mail Suite

      Zoho Projects provides an option to import users and accounts from Mail Suite. This feature is not available for Zoho CRM Plus and Zoho One users. Click  in the upper-right corner of the top navigation bar. Navigate to the USERS section and ...
    • Import Google Apps Users into Zoho Projects

      You can easily import Google Apps users into Zoho Projects. You can import the users for a portal or any selected project. However, you can import Google Apps users into Zoho Projects, only if have integrated your Google Apps account with Zoho ...
    • Import project users from Zoho CRM

      Zoho Projects provides an option to import users and accounts from Zoho CRM. From Zoho CRM, you can now import your project and client users to your Projects portal. This feature is not available for Zoho CRM Plus and Zoho One users. Login to Zoho ...