3293073 - Employee Import is failing '' Invalid file format specified. Please ensure the imported file is in CSV format''

Error while importing .zip files in Import employee data. 

''Invalid file format specified. Please ensure the imported file is in CSV format''

*Image/data in this KBA is from SAP Internal Systems, sample data, or Demo Systems. Any resemblance to real data is purely coincidental*

• SAP SuccessFactors HXM Suite
• SAP SuccessFactors Employee Central

1. Import Employee Data-> any option (termination details is just an example)
2. Import the .zip file containing the .csv import file.
3. Validate or Import.
4. Error: Invalid file format specified. Please ensure the imported file is in CSV format.

Check the import file and note that the values were not each put in separate rows/columns, they were instead separated by the ';' symbol. 

In order to use the import file correctly, each value should be put in its own row/column.

If your import files all use the ';' separator, there is a quick way to change them from all being in the one row/column and separated, to all being in separate rows/columns as needed, according to online articles. Please see the steps below that I used to change the format of the file you attached, for example:

1. Open your CSV file using a text editor.
   1. Windows: NotePad (notepad.exe)
   2. Mac: TextEdit (textedit.app)
2. Press Enter to create a new line at the very top of the file, and add sep=; if the separator used in the CSV is a semicolon (;), or sep=, if the separator is a comma (,). 
3. Save your changes (command + S or control + S), then re-open in any Spreadsheet app.

2482914 - Attaching Documents with Employee Data Imports - Employee Central

zip format, import, import zip file, error, .zip, composite, csv file, error, Invalid file format specified. Please ensure the imported file is in CSV format , KBA , LOD-SF-EC-EDP-TER , Termination Details Import , Problem

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM Suite all versions