Loading

Salesforce Error 'value not of required type' When Importing Time Values

Publiseringsdato: Jun 14, 2026
Beskrivelse
When you attempt to import Date or Date/Time fields using Data Loader or Data Import Wizard, you may encounter an error message:
 

When importing with Data Loader: 

  • <field name>: value not of required type: <cell value>

When importing with Data Import Wizard

  • INVALID_FIELD: Failed to deserialize field at col <csv column #>. Due to, '<cell value>' is not a valid value for the type xsd:time:<field name>
Løsning

This error occurs because the time format in the CSV file does not match the format that Salesforce expects for Date/Time fields during import. Follow the steps below to correct the format before importing.

This error indicates that the time format in the CSV file is unsupported in Salesforce.

Fix the time format in Excel

If the Time format in the .CSV File is not valid, follow these steps in Excel:


1. Click the header of the column containing your time field
2. Right-click any of the highlighted cells and choose Format Cell
3. Choose Custom
4. In the Type box, enter: hh:mm:ss.000Z
5. Click OK. 

Result:
Notice the value in the cell A:2 is displayed as the format. But the Formula Bar shows "9:30:00 PM". Upon importing, the system will read the value of the cell. 

Accepted format by tools:

Data Loader format:

  • HH:MM:SS.000Z 
  • Example: 08:00:00.000Z

Data Import Wizard formats 

1. HH:MM:SS.000 (Example: 08:00:00.000)
2. HH:MM:SS.000Z (Example: 22:00:00.000Z)
Knowledge-artikkelnummer

000381727

 
Laster
Salesforce Help | Article