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"

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/