I am opening a .csv file using LibreOffice Calc.

However, no matter the format I choose to save the file with after modifying it (either ODF or CSV) for some columns that contained quoted values, the quotes are gone after the save process.

Any suggestions about how to keep the original column formatting?


In the .csv format, one can specify that strings should be quoted. These quotes will not show up after you opened the .csv file in Calc.

To make sure that strings are quoted in the .csv file on disk, make sure to check "Quote all text cells" in the "Export Text File" dialog.

If you want to have quotes displayed in your column data (i.e., be part of the actual data), then "escape" the quotes using the same quoting sign. e.g., a string displayed in Calc as "string with spaces" will appear in the .csv file as ...,"""string with spaces""",... if you have chosen the same quote as delimiter in your .csv file.

  • 1
    Note that in order to see the Export dialog, when you Save As you have to select a new file name. If you try to Save As and choose you're existing file the dialog will not appear. – nf313743 Feb 1 '20 at 13:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.