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, 2019 at 17:45
  • 1
    Can you add first few rows in the question, by scrambling personal details if they exists? Sep 17, 2019 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, 2019 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. Sep 18, 2019 at 6:34

1 Answer 1


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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .