|Load Data From Files|
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.