Hi. How can we help?

How to format CSV files in OpenOffice


Correctly open, format and save CSV files in OpenOffice


  •  OpenOffice


Opening the CSV file:

  1. Open a CSV file in OpenOffice
  2. Set the character set to Unicode (UTF-8)
  3. Set separator options to separated by comma
  4. Set the text delimiter to "
  5. If working with a product CSV, right click the SKU column and set to "Text"


Saving the CSV file:

  1. Click File > Save As
  2. Ensure file type is set as "Text CSV (.csv)"
  3. Select "Edit filter settings"
  4. Click "Save"
  5. Enable "Quote all text cells"
  6. Click "OK"




Additional Information

Download Open Office for free - https://www.openoffice.org/download/



Was this article helpful?

3 out of 4 found this helpful