Setting Delimiters when opening a CSV File (OpenOffice Calc)

I had a question recently concerning the opening of CSV files in OpenOffice.

Sometimes when we open CSV files, they open in Calc by default, and the Text Import window doesn’t appear.

If this is the case for you, and the data is not being sorted into columns in a format you are happy with, then close the file and go to File >> Open.

Then select the CSV file and the following window should open.

Under “separator options” select the characters, tabs or other delimiters used to separate columns in your data.

You can fiddle with this so that you can see the output at the bottom of this window.

No related content found.

Additional Resources


  1. But how can we choose a carriage return as a delimiter? I have CSV files that seem to need both carriage return and comma, but I can’t find a code for the return. Thanks.

    • I’m not aware of there being a way to choose a carriage return as a delimiter when importing csv files. Carriage returns are often used as the end of a record (row) so I’m not sure this is the correct use of a carriage return. If I see this, I will often open the csv file in a text editor and manually use find-and-replace to replace any unwanted delimiters with something that is more manageable.

      Sorry I couldn’t be more help.

Speak Your Mind