Load Data From Files
See Also

Loading Data into Spreadsheets

Spreadsheets saved from a previous GenStat session can be loaded from GenStat GSH spreadsheet files. These are in a special format that stores the spreadsheet type, column names and attributes, and data.

New spreadsheets can also be created from many different data formats. Data from these formats are loaded into vector spreadsheets consisting of variate and/or text columns. If the first row of the data in a spreadsheet file contains column names these will be used by GenStat, otherwise default column names will be generated. Automatic conversion to factors can be obtained by terminating column names with a '!' character; alternatively the Convert and Column Attributes/Format commands can be used to alter the spreadsheet. Formulae within XLS, WK1, WQ1, WB* and QPW files are evaluated as the file is loaded.

When loading data from SAS v7-9, INSTAT and Matlab 5 file formats you will be prompted with dialogs where you can specify additional options controlling how the data are to be imported.

To open a file use Open from the File menu and select the required file type when browsing the file list.

You can also load data from ASCII text files by using the ASCII File option from the Load section on the Data menu, selecting the Display Data in a Spreadsheet.

Loading Data into GenStat

If you do not wish to view or edit data from a file you can load it directly into GenStat, using the Load section from the Data menu.

See Also

Import or export data
Add Data to a Spreadsheet
Import Data from Excel
Using GenStat with Excel
Excel Import Wizard
Load Spreadsheet

The SPLOAD directive loads data from GSH and GWB files within the command language. The IMPORT procedure loads data from other file formats within the command language.