> For the complete documentation index, see [llms.txt](https://docs.labii.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.labii.com/user-guide/add-record/add-via-import.md).

# Add via import

## 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:

1. **Prepare your data** in a TSV or XLSX file with column headers matching your table structure
2. **Select the file** and specify any project assignments
3. **Map the columns** from your file to the corresponding fields in Labii
4. **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 sequences
* **Multiple 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**](/user-guide/list-view/import.md).