SAP Knowledge Base Article - Public

2089299 - Error - User upload error - error at column 1 - Platform

Symptom

  • When uploading the import file you get the message - "error at column 1".

Environment

  • BizX Platform

Cause

  • Most often this is caused due to the fact you are attempting to import a Microsoft excel file.

Resolution

  • The SuccessFactors application requires that you import .csv files. Please check the file to verify that it is in .csv file format. It is possible to open a .csv file and when closing it, save it in excel format. When you attempt to import the file now in excel format the system gives this error.
     
  • If this does not solve your issue your file may have become corrupted. You may need to start with fresh header rows and template to import the data. To do so follow the steps below:

    Exported a new Template:
  1. Click on Admin Tools
  2. Click on Export Users
  3. Click on Export Template
    This will give you a fresh new Data file template for the user upload
  • With this new template:
  1. Cut and paste the data from the old file (excluding the template header rows (rows 1 & 2) into the new file.
  2. Save as a .csv
  3. Upload file into the system.

 

Additional Information:

 
  • Sometimes Excel has hidden characters buried in the file, and this causes the import to fail. Starting with a clean template is often a good workaround.

Keywords

KBA , sf error messages platform , LOD-SF-PLT , Foundational Capabilities & Tools , Problem

Product

SAP SuccessFactors HCM Core all versions