# Load spots data

This operation allows you to load spots data from a CSV file.

Spots data CSV file

This option allows you to load spots data from a CSV file. This CSV file must have the same format that the one used by the SameSpots report editor to store the spots data.

Usage

You can execute this operation by clicking the menu option Load/Load spots or the toolbar button.

A dialog will appear allowing you to choose the CSV file containing the spots data. As you can see in the following image, this dialog requires you to provide the following information:

- Spots data: a CSV containing the spots data to be loaded.
- CSV format: the CSV format of the selected CSV file. 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.

Load Spots Data 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 loaded spots data is automatically added as a Spots data datatype to the clipboard and automatically opened it in the Integrated analysis view.