Loading
Salesforce now sends email only from verified domains. Read More

Fixing Import Error: INVALID_TYPE_ON_FIELD_IN_RECORD

Publish Date: Apr 3, 2026
Description

If there are errors during your data import, a summary email is sent with the details in the attachment. A common error you may encounter in the summary email is INVALID_TYPE_ON_FIELD_IN_RECORD. This means the data type of the field you are importing into does not support the value you are attempting to import.

For example, importing a value of 2 into a checkbox field instead of 1 for checked values and 0 for unchecked values

Resolution

To fix this error, perform the following.

Enter a Supported Value in Your CSV File

  1. Open the error csv file you received as an attachment in the summary email after the initial import
  2. Click the gear icon in the top right corner of the Salesforce screen
  3. Select Setup
  4. Click Object Manager
  5. Click the Label for the object you are importing into
  6. Click Fields & Relationships
  7. Click the Field Label for the field identified in the error csv file error message column
  8. Confirm the Data Type of the field in Salesforce
  9. In the error csv file, change the value in the cell identified in the error message to a supported value as seen in the Field Data Types link below
  10. Save the error csv file
  11. Perform the import again using the error csv file

 

Additional Resources

For more information on errors that can be encountered within Salesforce, what they mean and how to fix them, please review the following resources:

  1. Core Data Types Used in API Calls
  2. Field Data Types
Knowledge Article Number

000390015

 
Loading
Salesforce Help | Article