1. Home
  2. Video Tutorials
  3. Importing Data from Excel

Importing Data from Excel

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.


Updated on April 19, 2023

Was this article helpful?