1. Home
  2. Save CSV Options

Save CSV Options

Select menu: File | Save As (Options butto

  1. To save the contents of a spreadsheet as CSV file select File | Save As then choose the Comma-Separated Values File (*.csv) from the dropdown list.
  2. Click Options. This lets you specify the format of the data (see below).

Variable names

If selected, this will include a row at the top of the file indicating the names of each column.

Output values with full precision

If selected, the values in a column will be output with 15 significant figures (full precision), otherwise the values will be output as displayed in the spreadsheet with potential rounding of the values and subsequent loss of precision.

Align columns with spaces

If selected, spaces will be added to column values so that all of the column’s values are vertically aligned, otherwise no spaces are added. Note that if spaces are added to values this may make the file incompatible with other applications.

Include data type indicators on column names (!, # and $)

If selected, the column names will have type indicators (! for a factor, # for a variate and $ for a text) appended to the name, otherwise just the plain column names with no decoration will be output.

Quoted text

If selected, this will enclose strings in single-quotes (e.g. ‘A’).

Write asterisk (*) for missing values

If selected, this will output an asterisk, i.e. *, for missing numeric values. If not selected, then a blank (e.g. , ,) or a empty string (e.g. ,,) will be output, according to whether or not Align columns with spaces is ticked. 

Action Icons

Clear Clear all fields and list boxes.
Help Open the Help topic for this dialog.

See also

Updated on August 30, 2019

Was this article helpful?