Loading

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

Fecha de publicación: Jul 8, 2025
Descripción
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>
Solución

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

Format time using Microsoft 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. 

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)
Número del artículo de conocimiento

000381727

 
Cargando
Salesforce Help | Article