How do I import CSV, text or Excel measurement files?

Choose File=>Import Data and select the file. UniPlot finds the column separator, the decimal sign, the channel names and the units by itself and converts the file once into a UniPlot data file. After that the channels are listed with their units and can be plotted by drag and drop. No import template and no add-in is needed.

Import dialog with channel list, attributes and data grid of an imported Excel file

Import dialog after loading a file: channels, attributes and the data in a grid.

How it works

  1. Choose File=>Import Data, select the file type (text, CSV or Excel) and one or more files. Hold Ctrl or Shift to select several files.

  2. UniPlot converts each file into a UniPlot data file (NC2). This is only done the first time; afterwards the converted file opens immediately.

  3. Choose the dataset type, for example 2D: x/y, select the channels for x and y and click Load, or drag the channels into a diagram.

What UniPlot recognizes automatically

  • Column separator: semicolon, tab, comma or spaces.

  • Decimal sign: period or comma.

  • Names and units: one row with channel names and one row with units below it. Comment lines above the data are skipped.

  • Text and date columns: columns without numbers become text channels, values such as 2007-01-17 become date or time channels.

  • Missing values: empty fields and fields such as *, -, #, nan or no value are stored as missing values instead of zeros.

Why it helps

  • Files from almost any data logger or test bench export can be read without writing an import script.

  • Units are kept and appear in axis titles and legends.

  • Files with up to 8000 columns are supported; the number of rows is only limited by memory.

Good to know

  • File=>Import Options sets how axis titles and legend texts are built from channel name and unit, for example Torque [Nm].

  • If formula channels are configured, they can be calculated during the import.

  • All rows should have the same number of columns. Missing fields at the end of a row are stored as missing values.

  • For your own text exports, the UTX format additionally stores attributes, for example the operator for the whole file and a unit for each channel.