Loading

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

게시 일자: Jun 14, 2026
상세 설명
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>
솔루션

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 기사 번호

000381727

 
로드 중
Salesforce Help | Article