1. Home
  2. Save Spreadsheet as a Text File

Save Spreadsheet as a Text File

  1. To save the contents of a spreadsheet as an ASCII text file select File | Save As then choose the File Type as Text File (*.txt) from the dropdown list.
  2. Click Options. This lets you control how the text file is written (see below).

Maximum line width

This sets the maximum number of characters that can be written to any line of the file. Any row of the spreadsheet that requires more characters than specified will be wrapped, to form multiple lines in the text file. You may need to set the maximum width if you wish to read the data into other programs or output to the printer. In particular, reading data in Genstat using commands assumes a width of 80 characters unless specified otherwise in the OPEN statement.

Comment line

If selected, this will add a Genstat-style comment, enclosed in double-quotes (“) at the start of the file.

Variable names

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

Quoted text

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

Terminating colon

If selected, a colon (:) will be written at the end of the file.

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.

Separate data columns using

Specifies how to separate the columns of data within the file. You can use either a space, tab, or comma.

Action Icons

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


To produce an ASCII data file suitable for loading via the Load ASCII File menu a suitable combination of options is: Comment Line, Variable Names, Quoted Text, Maximum Width 200.

See also

Updated on March 14, 2019

Was this article helpful?