Gene Expression To Spreadsheet (GETS)

Gene Expression To Spreadsheet (GETS) is a tool that generates data-rich multi-coloured Microsoft Excel files from gene expression data files in plain text format. It is available as a web-based tool and as a command-line program. You can find example files in the Downloads section.

Matrix file (mandatory) Please upload a tab-delimited plain text file with gene information. Rows are genes/probes and columns are features. Data in this file will be shown to the right of the heatmap. The file can be zip/gzip compressed. The current file size limit is 30Mb. An example can be downloaded by clicking in the TXT icon (right).
Gene information file Please upload a tab-delimited plain text file with gene information. Rows are genes/probes and columns are features. The file can be zip/gzip compressed. The current file size limit is 30Mb. An example can be downloaded by clicking in the TXT icon (right).
Sample information file Please upload a tab-delimited plain text file with sample information. Samples can be rows or columns (see Which format is the sample information file? on the right panel menu). The current file size limit is 30Mb. An example can be downloaded by clicking in the TXT icon (right).
Colors file Please upload a tab-delimited plain text file with ith color information for the data on the gene and sample information files. The current file size limit is 30Mb. An example can be downloaded by clicking in the TXT icon (right).
Run mode:
Standard Verbose
		GETS typically takes a few minutes to process the data, please be patient.

If you use GETS in your research, please cite: [CITATION HERE].

Last updated in November, 2019

Which format is the sample information file? Columns: the samples are columns and categories are rows in the sample information file. Rows: the samples are rows and the categories are columns in the sample information file.	Columns Rows
Is gene information data already ordered? TRUE: the order of the rows in the gene information file matches the order of the rows in the matrix file. FALSE: the order of the rows in the gene information file does not match the order of the rows in the matrix file.	TRUE FALSE
Is sample information data already ordered? If the format of the sample information file is Columns: TRUE: the order of the columns in the sample information file matches the order of the rows in the matrix file. FALSE: the order of the columns in the sample information file does not match the order of the rows in the matrix file. If the format of the sample information file is Rows: TRUE: the order of the rows in the sample information file matches the order of the rows in the matrix file. FALSE: the order of the rows in the sample information file does not match the order of the rows in the matrix file.	TRUE FALSE
Palette Palette for the colors in the gene and sample information cells.	Bright Muted
Limit for heatmap intensities IQR: limits calculated using the Inter-Quartile Range. Works for most centered matrices. IDR: limits calculated using the Inter-Decile Range. The heatmaps are more contrasted than with IQR, highlighting genes/probes with larger differential expression. Fixed: the user provides the n value for the limits. The intensity limits will be [-n, n] in this case. Note that n must be >=0 (otherwise the IDR will be used as default).	IQR IDR Fixed
Heatmap colors GBR: Green-Black-Red. BWR: Blue-White-Red.	GBR BWR
Should expression values be centered? TRUE: The values in the matrix file will be centered by substracting the median value for each gene. FALSE: The values in the matrix file are already centered.	TRUE FALSE