# Import SameSpots data from CSV files

This operation allows you to import a set of CSV files containing spots data obtained with Progenesis SameSpots.

SameSpots CSV format

This option allows you to import spots data from a set of CSV files obtained with Progenesis SameSpots report (i.e. one or more CSV files). This files are obtained by using the File/Export spot measurements option of this software, exporting only spot number, p-value, fold, normalized Volume and volume. For further details on this format, please, check the sample data provided with the tutorial that can be found at the official webpage.

Usage

You can execute this operation by clicking the menu option Import/SameSpots/Import CSV.

A dialog will appear allowing you to choose the directory containing the CSV files and other parameters to filter the identifications to be loaded. As you can see in the following image, this dialog requires you to provide the following information:

- SameSpots CSV directory: the directory containing the CSV files generated by the Protenesis SameSpots software. Please, note that you must select a directory and not the individual files.
- p-value: the maximum p-value allowed for spots to be loaded. Spots within a higher p-value will not be loaded.
- Fold: the minimum fold allowed for spots to be loaded. Spots within a lower fold will not be loaded.
- CSV format: the CSV format of the CSV files. S2P includes two preconfigured formats for Excel and Open/LibreOffice applications. In case you need to specify a custom CSV format you can select the Custom option, which allows you to configure the CSV format.

Import SameSpots CSV dialog

As commented above, you can customize the CSV format by selecting the Custom format option. When you select this option, the following custom format panel will be shown in the dialog. The options included in this panel will allow you to customize the CSV format:

- Quote fields: if this option is selected, then all fields will be quoted in the resulting CSV file.
- Column separator: the separator character/s between columns.
- Decimal separator: the character to use as decimal separator. Note that the decimal separator should be different from the column separator; otherwise, it may result in an unreadable CSV file.
- Line break: the type of line break depending in the target operating system.

Custom CSV panel

After clicking the Ok button, the imported spots data is added as a SameSpots analysis datatype to the clipboard and automatically opened in the SameSpots analysis editor.