This dialog contains the settings for converting table data into delimiter-separated values formats (for example, CSV, TSV) and vice versa.
When you change settings, the preview changes correspondingly.
Select a template that successfully converts the file data into a table. You can change settings of predefined templates or add a new template. To add a template, click Add Format button ().
Use the Add Format (), Remove Format (), Up () and Down () buttons to create, delete and reorder the formats; Copy Format () to create a copy of the selected format.
Select or type the character that you want to use as a separator for values.
Select or type the character that you want to use as a separator for rows.
Null value text
Select or type the text that you want to use if a cell contains the
Add row prefix/suffix
Click the link and type a row prefix and suffix. Prefix and suffix are character sequences which in addition to the row separator indicate the beginning and end of a row.
Each line in the area under Quotation is a quotation pattern. A quotation pattern includes:
If there is more than one pattern, the first pattern is used.
Use the Add (), Remove (), Up () and Down () buttons to create, delete and reorder the patterns.
Select when you want to enclose values within quotation characters.
Ignore or remove whitespace characters. If this checkbox is cleared, the whitespace characters are treated as parts of the corresponding values.
First row is header
Treat the first row as a row that contains column names.
First column is header
Treat the first column as a column that contains row names.