Genstat can import data from many spreadsheet formats. These tutorials explain how to import workbooks, spreadsheets and individual cell ranges from Excel. After importing Excel data into Genstat, you can analyse and manipulate it, then save the results as a Genstat spreadsheet or an Excel file.
Importing data from Excel
Need to import an Excel spreadsheet into Genstat? Here’s how.
Importing an Excel range
Want to import a selection of columns or rows rather than an entire spreadsheet? Here’s how.
Importing Excel cell formatting
You can import Excel cell formatting information, such as fonts, colours and styles, as data. This is particularly useful when formatting has been used to capture supplementary information, such as using coloured cells to indicate outliers. Cell formulae can also be imported as data.