SAP Knowledge Base Article - Public

2626329 - Import Tool failing due to error "The Date/Time cell at row 'X' in column 'X' has an invalid cell type. The cell must be formatted as Text."


After downloading and filling the import data template, the admin is getting an error for date formatting while trying to import the file.


SAP SuccessFactors Learning Management Systems (LMS)

Reproducing the Issue

  1. Go to System Admin > Tools > Import Data;
  2. Select import data, record type, import option and browse the files;
  3. Click submit;
  4. Schedule or run the job as needed;
  5. Wait for the completion and download the Error Log.


This is caused by the formatting of the column.


  1. Open the file you are trying to import;
  2. Right click on the column for the date then go to formatting cells;
  3. Select text under category and click OK;
  4. Go back to the column and type the date in the format mm/dd/yyyy;
  5. Try to import the file again.


import data, tool, lms, sap, template, curricula assignment, invalid cell type, invalid format , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , Problem


SAP SuccessFactors Learning all versions