Add via import
Add hundreds of records at once using the import function
Overview
The import function allows you to create and update multiple records efficiently in bulk. Instead of manually adding records one by one, you can prepare your data in a spreadsheet and import hundreds or even thousands of records at once.
This is especially useful for:
Initial data migration from legacy systems
Batch sample creation in research projects
Bulk inventory loading
Large-scale data entry with multiple fields per record
How it works
The import process is straightforward:
Prepare your data in a TSV or XLSX file with column headers matching your table structure
Select the file and specify any project assignments
Map the columns from your file to the corresponding fields in Labii
Review and execute the import to create all records at once
Required fields
When importing new records, ensure that all required fields (marked with an asterisk * in your table settings) are included in your import file. Missing required fields will cause the import to fail for those records.
Advanced features
Update existing records by including UIDs (Unique IDs) to match and modify records
Execute workflows after import to automatically perform actions like creating vials or samples
Use special syntax like
{{INDEX}}for auto-numbering or{{LETTERINDEX}}for letter sequencesMultiple value support for fields that accept multiple selections
For detailed instructions
For comprehensive guidance on file preparation, field formatting, workflow execution, and troubleshooting, see Import Records.
Last updated