SAP Knowledge Base Article - Public

2228906 - HOW TO: Save Excel Files to CSV

Symptom

HOW TO: Save Excel Files to CSV

Environment

  • Platform
  • Import Files

Resolution

  1. Export the CSV file from SF Admin Tools
     
  2. Save the file to your desktop
     
  3. Open Excel, DO NOT OPEN FILE!!!
     
  4. Create a new blank workbook
     
  5. Click ‘Data’
     
  6. Hover over ‘Import External Data’
     
  7. Click ‘Import Data’. You want to import from a text file. Your‘Text Import Wizard’ may appear in some versions of excel.
     
  8. Verify that the ‘Delimited’ radio button is selected then click ‘Next’
     
  9.  Put a check mark in the box to the left of  ‘Comma’, since the delimiter in your file are commas.
     
  10. Click ‘Next’
     
  11. The first column should already be highlighted as seen in the example to the right (If it is not highlighted then click once on the column header labeled ‘General’ over the first column.)
     
  12. Using the horizontal scroll bar at the bottom, scroll all the way to the right.
     
  13.  Hold down the ‘Shift’ key and click the last column header.
    This should highlight all columns
     
  14. Click the ‘Text’ radio button
    You should immediately see all column headers change to ‘Text’
     
  15. Click ‘Finish’
     
  16. Click ‘OK’
  17. Now you are able to make edits to the file
     
  18. When you have completed all updates you must save the file as a .CSV (Comma Separated Value) Refer to the next screenshot for a reference on how this is done:

Keywords

  • User Data File
  • CSV
  • Comma Delimited Files
  • Excel
  • Import Files
, KBA , LOD-SF-PLT , Foundational Capabilities & Tools , How To

Product

SuccessFactors HCM Core 1207 ; SuccessFactors HCM Core 1210 ; SuccessFactors HCM Core 1302 ; SuccessFactors HCM Core 1305 ; SuccessFactors HCM Core 1308 ; SuccessFactors HCM Core 1311 ; SuccessFactors HCM Core 1402 ; SuccessFactors HCM Core 1405 ; SuccessFactors HCM Core 1408 ; SuccessFactors HCM Core 1508