How to Import Data

1. To open an existing Genstat spreadsheet (.gsh file) select File | Open, then navigate to the file and open it.

Genstat supports many different file types, so there are a variety of methods for getting data into a spreadsheet.

• Create an empty spreadsheet and enter the data manually.
• Open one of the Genstat example data sets.
• Use the Excel import wizard to import an Excel file.
• Open marker and map files for QTL data.
• Copy and paste clipboard data.
• Open a CSV file.
• Open an ASCII file.
• Open a CSPro survey.
• Open a spreadsheet from a URL.
• Open a file from a URL.
• Use an ODBC or DDE link.
• Open a file created with another program.

See also

• SQL Statements
• Create New Database Table from Spreadsheet
• Insert Spreadsheet into Database
• Merge Spreadsheet into Database
• Run ODBC Export Link (GLK) file
• Using ODBC with 64bit Windows
• Spreadsheet Export Menu
• Spreadsheet Add Menu
• Spreadsheet New Menu
• DBIMPORT procedure
• DBEXPORT procedure