Important information about using 12-digit BeadChip barcodes in GenomeStudio sample sheets

03/15/18


Illumina recently began using 12-digit BeadChip barcodes, which Excel automatically converts to scientific notation. If the BeadChip barcode column in the sample sheet is not reformatted as “Number,” the barcodes are not saved to the CSV file correctly. GenomeStudio does not recognize the barcodes when the sample sheet is imported, and the error message ‘The project can not be created. No valid samples were loaded.’ appears. 

Example: After ‘123456789012’ is entered in the BeadChip barcode column, and the CSV file is saved, the barcode number is reformatted. In Excel, by default, the number is rounded to the nearest 6 significant digits, 123456000000, and is displayed in scientific notation as 1.23E+11.  

To retain the full barcodes in the sample sheet, reformat the BeadChip barcode column as “Number” with 0 decimal places before the file is saved. To format the column correctly, do the following:

  1. Highlight column
  2. Right-click column
  3. Choose “Format Cells”
  4. Click the “Number” tab
  5. Select “Number” and enter “0” as the number of decimal places
  6. Save the file as .csv and use to create GenomeStudio project

If the sample sheet is reopened in Excel, the format of the BeadChip barcode column is not retained. The sample sheet opens with the column reverted to scientific notation. If changes are made to the sample sheet, requiring it to be saved, the BeadChip barcode column must be reformatted as “Number” with 0 decimal places before saving.

The sample sheet can be checked for accuracy using a text editor, such as Notepad. The sample sheet can also be edited in Notepad without any formatting issues.