Import analyzer results from a file

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.

image-20260202-091812.png

Import the file

  1. Select the samples.

image-20260202-092028.png
  1. Click Import Analyzer Results.

image-20260202-092044.png
  1. 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.

image-20260202-092100.png

Map the columns

  1. Once the file is uploaded, open the Map Columns tab.

image-20260202-092114.png
  1. 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

image-20260202-092208.png

Preview before importing

  1. Click Generate Preview.

image-20260202-092224.png
  1. 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.

image-20260202-092246.png

Record the run metadata

  1. 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.

image-20260202-092310.png
  1. Click Import.

image-20260202-092336.png

Results imported successfully.

image-20260202-092352.png

Complete the results

  1. Select all the results.

image-20260202-092408.png
  1. Click Mark Selected Complete.

image-20260202-092421.png

The results are entered successfully. The post-analysis step can now be carried out.

image-20260202-092436.png

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