Select menu: File | Save As (Options butto
- 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.
- Click Options. This lets you specify the format of the data (see below).
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.
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.
|Clear||Clear all fields and list boxes.|
|Help||Open the Help topic for this dialog.|