...

The preferred method for importing a generic list of data spreadsheet into Partek^® Genomics Suite^® is as a text file. Our example is Here, we illustrate importing a list of genes with p-value and fold-change from an experiment comparing two conditions. 

• Select File from the main toolbar
• Select Import
• Select Text (.csv .txt)...under the Import option 
• Select the text file using the file browser to launch the Import .txt, .tsv, or .csv File dialog

...

• Select Next > to move to the Data Type section 
• Select your data type; here we have chosen Genomic Data because it is a gene list (Figure 2)

We have also deselected Is the data log transformed (LOG_base (x+offset) ) ? 

Selecting Genomic Data will result in open a dialog prompt after import to configure genomic properties for the imported list including selecting the type of genomic data, the location of genomic features in the spreadsheet, the annotation column with gene symbols, the chip or reference source and annotation file, and the species, and reference genome build. This option should be selected if the text file contains genomic position data or other array/sequencing results. 

• Select Next > 

...

The next step is to identify where the data starts and where the optional header is found using Identify Column Labels, Start of Data (Figure 3). The line that contains the header (if present) must precede the data. If there are lines to be skipped in the file (like comments), they may only appear at the top of the file, before the header line or data begin.

If there are many comment lines at the start of the file, you may need to select View Next 5 Records to get to the row that contains the column header. If you accidentally move past the screen that contains the header or data rows, select View Previous 5 Records. 

...

• If a header row is present, select Col Lbls to allow you to select a column header row
• Select the row where the data beings using the Begin Data selector 
• If any cells have a missing value, you can signify this with a special symbol selected using the Missing Data Representation panel

This Signifying missing data is important if the missing value is a number you have empty cells in a column that you plan to use for statistical analysis because missing values can cause statistical tests to fail. The default missing value indicator is ?. 

...

• Select Next Select Next > 

The final section of the Import .txt, .tsv, or .csv File dialog is Verify Type & Attribute of Data Columns (Figure 5). While data column type and attribute can be modified after import, it is easier and faster to select the proper options during import as multiple columns may be selected during this dialog.  

...

If there is an identifier like gene symbol or SNP, the Type field for that column should be set to text and Attribute should be set to label. Numeric values (intensities, p-values, fold-changes, etc.) should have Type set to double and Attribute set to response. The other possible value for Attribute is factor and describes sample data. The user interface is this dialog allows you to select multiple columns at once. The interface controls are detailed in the dialog (Figure 5). 

• Select Finish to import the text file and open it as a spreadsheet

If Genomic Data data was selected in the Data Type section, the Configure Genomic Properties dialog will open (Figure 6). These options will be discussed in the next section when we add an annotation file, but we will make a few selections now. 

...

• Select Other from the Choose the type of genomic data drop-down menu
• Select Gene symbol instead of Marker ID
  
• Select Feature in column and choose Symbol from the drop-down menu
• Set Column 1. Symbol will : will be automatically selectedset
• Select OK 

The imported spreadsheet will open (Figure 7). 

...