Export text files

The Export text files dialogue box allows you to define the export options for text files. The dialogue box will be displayed if you save spreadsheet data as file type "Text CSV", and if the Edit filter settings check box is marked in the Save As dialogue box.

Field options

Defines the field separator, text separator and character set that is used for the text export.

Character set

Specifies the character set for text export.

Field delimiter

Choose or enter the field delimiter, which separates data fields.

Text delimiter

Choose or enter the text delimiter, which encloses every data field.

Quote all text cells

Exports all text cells with leading and trailing quote characters as set in the Text delimiter box. If not checked, only those text cells get quoted that contain the Field delimiter character.

Save cell content as shown

Enabled by default, data will be saved as displayed, including applied number formats. If this check box is not marked, raw data content will be saved, as in older versions of the software.

Warning Icon

Depending on the number format, saving cell content as shown may write values that during an import cannot be interpreted as numeric values any more.


Fixed column width

Exports all data fields with a fixed width.