Rules for data importing in Zoho CRM

Rules for data importing in Zoho CRM

Supported Formats

 

You can use XLS, XLSX, VCF or CSV format for importing up to 1500 records. For more than 1500 records, only CSV format is supported.

 

Maximum Limits

 

Free Edition - 1500 per batch

Professional Edition - 10000 per batch

Enterprise Edition- 20000 per batch (only for Clone option). Skip/Overwrite can be performed with a maximum of 2000 records.

 

Important Notes

 

·         First row of the given file will be treated as field names.

·         Please ensure your file size does not exceed 5 MB.

·         Before importing the data all duplicate records will be ignored from the XLS/XLSX/CSV/VCF file.

·         Duplicate check will be performed based on the Email field of Leads and Contacts modules, where as Name/Subject of other modules.

·         While checking for duplicate records, you can overwrite, clone, or skip the duplicates. For more information refer to Online Help.

·         In case of XLS file, only MS Excel 97 - 2003 formats are supported.

·         Unexpected errors may occur if the XLS file contains any special controls like combo filters or images embedded within it.

·         Check box value should be 1 or 0

·         Date values must be in MM/dd/yyyy format. Dates in any other format will be ignored.

·         Date Time values must be in MM/dd/yyyy hh:mm:ss format. Date Time values in any other format will be ignored.

·         By default, the character encoding is UTF-8 (Unicode). Make sure you provide the correct character encoding if your import file requires a different character encoding.

·         It is recommended that you test your import with a sample file before you import the actual data.


    • Related Articles

    • Deleting a Zoho CRM Account

      There are several steps to go through in order to delete a Zoho CRM account. Please refer to the link below from Zoho's user guide for more details. https://help.zoho.com/portal/kb/articles/how-can-i-delete-my-zoho-crm-account

    • Zoho CRM Licenses and Feature Comparisons

      You can check out a complete feature comparison here for each license available for ZOho CRM: https://www.zoho.com/crm/comparison.html

    • How do I invite a new user to the CRM portal?

      Add the user to the CRM portal then follow the steps below: Setup Users and Control > Users Click the user in question Click the green 'Reinvite' button in the top right of the user details screen The user will then receive an invitation email. They ...

    • Zoho CRM Customers

      Please take a look at the following link to see some well known Zoho CRM customers: https://www.zoho.com/crm/customers/

    • Integrating Multiple Zoho CRM Portals to a Single Zoho Campaigns Portal

      You can integrate more than one CRM account in Zoho Campaigns and sync the Leads / Contacts to Zoho Campaigns. In Zoho Campaigns, go to Settings >> Integrations >> Zoho CRM >> Add another account.