I could not import the file. What could be the possible reasons?
The following could be one of the reasons why you could not import the file.
- There is no column header in the import file. Each column needs to have a column header. For example, the column that contains the email address of the records can have the column header as Email.
- Your file contains empty values for some of the mandatory fields in CRM.
- In case you are mapping a column (in your import file) with a drop-down field in CRM and the value is not already added in CRM. You need to add the values for the MM/dd/yyyy.
- The date and time format in your import sheet is not mapped with that of Zoho CRM. For example, let's say the date format in your import sheet is MM/DD/YYYY. You have to select this format correctly from the Date and time format drop down while importing the sheet. You can find this under the Advanced Options.
- The import file had an empty row which is interpreted as the end of the file.
Note:- In the Free Edition, you can import only a maximum of 1500 records.
- You can use the XLS, XLSX, VCF, or CSV format up to 1500 records. For importing more than 1500 records (only in paid Editions), only CSV format is supported. For more information, see Import Data
Related Articles
Import/Export a File
You can import or export file in different formats right from Writer. Supported File Formats: Import: .doc, .docx, .odt, .rtf, .html, .htm, .txt Export: .docx, .doc, .odt, .rtf, .txt, .zip, .epub, .pdf To import a file: In the File drop-down list, ...
What is the file format accepted by CRM for calendar import or export?
The format of the file for import and export in Calendar is .ics format.
What is the maximum file size allowed for import in sheets?
The maximum file size allowed is 10 MB.
How can I associate contacts with the respective accounts while importing them using a single import file?
While importing the accounts and contacts using a single file, you can associate the contacts with the respective accounts. Your import file may contain both the contact and account details. You need to do the following: Copy the Account information ...
I have my own email list as a file, how do I import it into my Email marketing Account?
Email marketing supports CSV, XLS and XLSX format. Browse to where the file is on your computer and start importing, our import wizard will guide you to do the rest.