2115614 - How to open a text file through Microsoft Excel?

• How to open a .txt or .csv file in Microsoft Excel?
• How can I open UDF file in Microsoft Excel?
• Where can I open csv files?

SAP SuccessFactors HCM Suite

Since SuccessFactors utilizes the .csv file format and many users have Microsoft Excel installed, below are some tips for opening .txt or .csv files in MS Excel:

1. Open Excel and go to the Data tab.
2. Click From Text, then locate and select the file to import.
3. Check if the file displays the desired columns. If correct, click Load.
4. If the columns are not formatted correctly, choose a different format under File Origin. The default format is typically Unicode (UTF-8).
5. Select your preferred format and click Load.

If you have additional question or are facing some issue, you should engage your internal IT Team to further help you. This KBA contains only some tips that you should follow.

User data file, which program use, UTF-8, excel, special, character, Unicode (UTF-8) , KBA , LOD-SF-PLT-UIM , Employee Import Issues , LOD-SF-PLT-DRM , Data Retention Management , How To