Exporting and importing Sample tags: annotate files by spreadsheet


Aside from the manual waythe Cytobank platform supports applying sample tags to files via spreadsheets. This can accelerate the annotation process in certain cases and is useful for creating templates for repeat experiments.  

How to import / export Sample tags by spreadsheet 

 Navigate to your experiment and select Actions > Export > Export Sample tags: 

The resulting spreadsheet can be used as a template for importing Sample tags to annotate your experiment. 


Note that the Sample tags export will reflect the current state of the tags in the experiment. If you have already annotated your files, then the Sample tags spreadsheet will export in an annotated format (useful for templating). The resulting spreadsheet will appear as below for an experiment with no Sample tags assigned to files: 


(note, "Plate" and "FCS File Category" may be assigned automatically upon upload of files to the Cytobank platform, depending on the dataset)  

Open the spreadsheet. Sample tags can be simultaneously created and assigned by entering character strings into the cells of the spreadsheet in the desired columns. Consider, for example, that we wanted to accomplish the same Sample tags assignments as in the basic annotating article linked above. We would fill out the spreadsheet as such: 



This gives instructions to the Cytobank platform to create four Sample tags (IL10, IL6, LPS, Unstim) within the Conditions dimension and to apply the tags to the files listed on the left. The "Unstim2" file will not be tagged. 

After saving the file as either .txt, csv or .tsv file, it can be uploaded and applied to an experiment. To do this, first navigate to the experiment, and then choose Actions > Upload > Upload sample tags: 




After uploading, the experiment files will be annotated with Sample tags! 

Important usage note: 

You cannot remove or reassign sample tags by uploading a spreadsheet. The spreadsheet upload feature can only add sample tags, and uploading a spreadsheet into an experiment with previously defined sample tags leads to double annotating single files, which can create buggy downstream behavior. If you need to upload sample tags by spreadsheet on top of already tagged files, make sure that the spreadsheet does not have instructions to annotate files that are already annotated (remove already existing tagging information before upload). Alternatively, navigate to the Sample tags interface within the Cytobank platform and elect to reset the dimension. This is an option on each Sample tags page. Resetting the dimension will erase all Sample tag information for a particular class of tag. 

Other recommended reading 

Also read the Overview of Sample tags for a solid theoretical grounding in the concept of annotating with Sample tags. 




Have more questions? Submit a request