enter image description hereI'm trying to import a file with Data Loader into a Standard object and I get the errors as follow:

ID: value not of required type: 425.0.

The Data Type is TEXT in salesforce. In the CSV import file the Column type is General and it contains numbers. I would like to import the numbers in a text field but it's adding .0 at the end of the number. How can I fix this issue? Any suggestions are highly appreciated.

  • what do you mean by "it is adding"? What is "it"? – kurunve Sep 17 at 17:45
  • 1
    Can you add first few rows in the question, by scrambling personal details if they exists? – Pranay Jaiswal Sep 17 at 17:51
  • change the format of the csv column to Number then set decimals to 0; then save CSV file. Check file in a text editor that the trailing .0 is removed before data loader step – cropredy Sep 17 at 19:01
  • Hi all, I have added the picture for reference. The problem is I'm trying to insert the ID field into Salesforce( text) Data type and it is trowing error. – Salesforce User Sep 18 at 6:34

Put a single quote (') character in front of the numbers in excel. This will make the number into a string.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.