I have a spreadsheet open in LibreOffice Calc (5.1.6.2). I would like to save it as a CSV using pipe delimiters. I have done this before, but I can't figure out how.
Following the instructions at :
From the menu, I select 'File' > 'Save as'. This opens "Save as" dialog.
In the "Save as" dialog, I change the 'File name' to a .csv extension and select 'Text CSV (.csv)' as the 'File type'.
I check the box for "Edit filter settings" and select "Save".
This brings up a "Confirm File Format" dialog; I choose "Use Text CSV Format" to continue.
This brings up the "Export Text File" dialog. Here, my options for Field Delimiter are limited to the set [, ; : {Tab} {Space}].
I am absolutely certain that previous attempts to save a spreadsheet as a CSV has brought up a "large" version of the "Export File" dialog that includes the ability to choose a pipe (|) character as a delimiter, but now nothing I can do will produce that.
How do I access the "large" Export File dialog that lets me save a CSV file with a | delimiter?
1 Answer
I am using Libre Office 5.2.7.2 on Debian Jessie.
- Example worksheet
- Save as, CSV, check Edit filter settings
Click Save.
In the Export Text File dialog, type the character you want in the Field Delimiter text box (ignore the dropdown choices), replacing whatever character is there.
- Check the result
