How to format CSV files in OpenOffice


Latest update: - Andrew Starr

Objective

 Correctly open, format and save CSV files in OpenOffice

Setup

  •  OpenOffice

Steps

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"

Screenshot_2018-09-26_at_13.15.25.png 

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"

Screenshot_2018-09-26_at_13.21.52.png

Screenshot_2018-09-26_at_13.22.03.png

 

 

 

Powered by Zendesk