I could not import the file. What could be the possible reasons?

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