Importing from Excel
Instead of typing records one by one, you can load them from an Excel spreadsheet. This page explains what can be imported, how to prepare the file and how to read the results.
Who this is for: Laboratory owners and administrators · You need: the "Manage parameters" permission to import parameters, or "Manage regulatory frameworks" to import limits
The idea in short
The Import from Excel wizard has three steps: Upload file, Map columns and Results. You upload a spreadsheet, tell SmartLIMS which column holds which field, check a preview and import.
You can import two kinds of records:
| What | Where you start it | Button |
|---|---|---|
| Parameters | Settings → Parameters | Import from Excel |
| Limits of a regulatory framework | Settings → Regulatory Frameworks | Import limits from Excel |
A limit (MRL, maximum residue level) is the highest legally allowed amount of a substance in a product. See Regulatory limits and catalogs and the Glossary.
The import is partial: rows that are valid are saved, and rows with problems are skipped and listed with the reason. One bad row doesn't stop the rest.
How to prepare the file
- Save it as .xlsx.
- SmartLIMS reads the sheet that was open when you last saved the file. Save the file with your data sheet open.
- Put column headers in the first row. Data starts on the second row.
- Use one row per record. Blank rows are skipped.
- Keep it to 5000 rows or fewer per import. Split bigger files.
- Column names don't have to match SmartLIMS exactly, but if they do (for example "Name", "Unit", "LOD"), the columns are matched for you.
- For yes/no fields such as Accredited, write
1,true,yes,yordafor yes. Anything else counts as no. - For operators, use
<,<=,=,>=or>. - For dates, use the form
2026-08-25(year-month-day).
Parameter fields
Only Name is required. You can also map Code, Unit, the reference min and max operator and value, LOD, LOQ, Measurement uncertainty, Reference value origin, the three suffixes (name, code and reference value, in that order), Reference value for report, External code, Accredited and System field. See Products, parameters and groups for what each field means.
The link to the substance catalog is not imported. Set it afterwards on each parameter, or add EU substances with Add from EU jurisdiction, which sets it for you.
Limit fields
| Field | Required | What to put in it |
|---|---|---|
| Framework | Yes | The exact name of one of your company's own frameworks. Frameworks supplied by the system are read-only and can't be imported into. |
| Product | Yes | The product's name as it appears in the product catalog. |
| Parameter | Yes | The substance's name in the parameter catalog, or its CAS number. |
| Min value / Min operator | One value is needed | The lower limit and its operator. |
| Max value / Max operator | One value is needed | The upper limit and its operator. |
| Citation | Yes | Where the limit comes from, for example the regulation and annex. |
| Analyte definition | No | What exactly is measured, if the regulation defines it. |
| Provenance note | No | Any note on where the value came from. |
| Effective from / Effective to | No | The dates the limit applies between. |
A row fails if the framework, product or parameter isn't found, or if more than one matches the name. Give your frameworks unique names, and add limits for ambiguous products or substances by hand.
How to import
- Open the page you are importing into and click Import from Excel (or Import limits from Excel).
- Upload file: select your .xlsx file.
- Map columns: for each Field, choose its Source column. Your choices are:
- a column from your file,
- — Don't import — to leave the field empty,
- — Use a default value — to type one value that is used for every row (for example the same Unit for all).
- Fields marked (required) must be mapped. Until they are, you see "Map all required fields before continuing."
- Check the Preview below the mapping. It shows the first 5 rows as they will be imported.
- Click Import.
- Results: read the summary, then click Done.
SmartLIMS remembers your mapping for the next import of the same kind, for your company. If your file has the same layout next time, you only need to check and click Import.
📷 Screenshot: the Map columns step with a default value set for Unit and the preview below
Reading the results
The Results step shows:
- "N row(s) imported": rows that were saved.
- "N row(s) failed": rows that were skipped.
- One line per failed row, such as "Row 14: …", with the reason. The row number is the row in your spreadsheet.
📷 Screenshot: the Results step with two failed rows listed
Errors and what to do
| Message | What it means | What to do |
|---|---|---|
| The uploaded file has no data rows. | The file has headers only, or the wrong sheet was open when it was saved. | SmartLIMS reads the sheet that was open when the file was last saved. Open the sheet with your data, save and upload again. |
| The file has too many rows. Maximum is 5000 rows per import. | The file is too big. | Split it into several files. |
| This import has expired. Please upload the file again. | The upload is older than 24 hours, or was already imported. | Start again from Upload file. |
| This external code is already used by another parameter. | A parameter with that External code already exists. | Change or remove the code in that row. |
| A framework, product or parameter is not found or matches more than one | The name doesn't match exactly, or is shared. | Correct the name, or add that limit by hand. |
Re-running an import
An import always adds records. It doesn't update or replace existing ones. If you import the same file twice, you get every record twice (except parameters with an External code, which fail the second time).
To fix failed rows:
- Copy only the failed rows (and the header row) into a new file.
- Correct them.
- Import the new file.
Tips
- Try a small file of five or ten rows first, then import the rest.
- Fill in External code on parameters. It protects you against importing the same parameter twice.
- Use — Use a default value — for fields that are the same for every row, instead of adding a column.
- Check a few imported records afterwards, especially limits, against the source regulation.