1

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 https://help.libreoffice.org/Calc/Importing_and_Exporting_CSV_Files:

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?

Improve this question

1 Answer 1

Reset to default
1

I am using Libre Office 5.2.7.2 on Debian Jessie.

  1. Example worksheet

enter image description here

  1. Save as, CSV, check Edit filter settings

enter image description here

  1. Click Save.

  2. 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.

enter image description here

  1. Check the result

enter image description here

Improve this answer
1
  • That works, of course. I didn't realize I could type my own option. I must be confused about the other dialog that I thought I remembered seeing. Anyway, thank you!
    – Borea Deitz
    Jun 18, 2019 at 13:20

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .