Import analyzer results from a file
How-to · Lab staff
Part of: Set up an analyzer
At a glance
Purpose | Bring analyzer results into OpenELIS from a CSV or Excel file, rather than over a live connection. |
You'll end up with | Results entered against the right samples and marked complete, ready for post-analysis. |
Who does this | Lab staff. Access is set by user permissions and can be configured by your administrator. |
Before you start | A CSV or Excel export from the analyzer, and knowledge of which of its columns hold the well coordinate, the sample identifier and the result value. |
Where | Main menu → Analyzers → Analyzer Results |
This is the file-based route, and it remains current. Results can be entered manually, imported from a file as described here, or arrive directly from the instrument over a Bridge connection — see Set up an analyzer for the connected route.
File import matches rows to samples by well coordinate or lab number, so it suits plate-based instruments and any analyzer whose output is collected as a file.
Open Analyzer Results
Analyzers allow entry of results in three ways: entered manually, imported from a CSV file, or sent directly by the analyzer. Click Analyzer Results.
Import the file
Select the samples.
Click Import Analyzer Results.
Upload a CSV or Excel file containing the analyzer results by clicking Select File.
Note: rows are matched using either the wells or the lab numbers.
Map the columns
Once the file is uploaded, open the Map Columns tab.
Map each column by choosing, from the drop-down, the column as it appears in your file:
Well Coordinate Column
External ID Column
Result Value Column
Preview before importing
Click Generate Preview.
Check the preview. The columns shown are Matched and Replicate. When satisfied with the mapping, click Continue to Metadata.
Read the preview rather than skipping it. It is the point at which a mis-mapped column is still cheap to fix — Matched shows which rows found a sample, and Replicate flags repeated readings.
Record the run metadata
Enter:
Assay Run ID
Operator ID / Name
Machine Parameters
Reagents used
This metadata is what makes an imported run traceable afterwards — who ran it, on what settings, with which reagents.
Click Import.
Results imported successfully.
Complete the results
Select all the results.
Click Mark Selected Complete.
The results are entered successfully. The post-analysis step can now be carried out.
Tips
Import matches on well coordinate or lab number. If rows come back unmatched in the preview, check that the External ID column is the one carrying the identifier OpenELIS knows.
Generate the preview and read it. It is cheaper than correcting imported results.
Importing does not complete the results. Mark Selected Complete is a separate step.
Flat-file parsing is maintained by the OpenELIS team, so a new instrument's file format may need work rather than configuration.
Provenance
Status | Verified content, re-homed |
Original author | Taib, 2 February 2026 |
Re-homed | 15 September 2026. This page was filed outside the analyzer material and was hard to find; it has been moved under Set up an analyzer, retitled to house style, and given an At a glance block. All fourteen original figures and the step text are unchanged. |
Reviewer | Original content stands; the added framing is unverified |