Save comma separated csv files in OpenOffice

I want to establish a protocol for my dataflow in Magento, part of which is “all csv files contains import data should be comma separated”.

OpenOffice is an efficient tool to edit csv files, but how to save them using comma separator? I found OpenOffice behaviour quite unpredictable, sometimes comma separated, sometimes semi-colon separated. Maybe it depends on csv original format upon opening or creating.

How to always save a comma separated csv in OpenOffice?

I did not find a way to make it happen by default, but it can be achieved by 2 steps:

1. Use “Save As…”, and check option “Edit filter settings”

Check Edit filter settings
Check Edit filter settings

2. Set comma as Field delimiter

Filter settings dialogue
Filter settings dialogue

Leave a Reply

Your email address will not be published. Required fields are marked *