Search code examples
fieldexport-to-csvlibreofficeseparator

How to export CSV file in Libre Office using separator at the end of last field?


I have an application which saves CSV files. When I import in Libre Office 5 and save again as CSV, the resulting file will not contain a field separator at the end of the last field. I could use an awk script but is too hard to use for other users. Is there any setting in libre office which will allow me to import and save the file successfully?


Solution

  • The format of the CSV-file that you described corresponds to a table with an empty column with an "invisible heading", usually a space.

    Therefore, the easiest and fastest way to do what you want is to add a space in the table header after the last column before exporting.

    CSV-end-separator.png