How-To: Export Measurement Data from the MultiLab® Pro IDS as a CSV File to Excel
In this FAQ mini-tutorial, we’ll show you how to export measurement data from the MultiLab® Pro IDS in GxP-compliant CSV format and how to open, import, and process it correctly in Microsoft Excel.
CSV export enables structured, traceable documentation of your measurement data, including all relevant metadata.
In this video, you’ll learn:
how to start the CSV data export in the MultiLab® Pro IDS
what measurement and sensor data is included in the CSV file
how to import CSV files correctly into Excel (Import Wizard & opening directly)
why data is sometimes displayed in a single column and how to fix this
how to correctly set the delimiter (semicolon) and decimal separator (period)
how to save CSV data as an Excel file (.xlsx)
how to merge multiple CSV files
why no information is lost when imported correctly
Included Data (GxP-Relevant)
The exported CSV files from the MultiLab® Pro IDS include, among other things:
Measurement values for all parameters (e.g., pH, conductivity, oxygen)
Sensor designation and serial number
Calibration status and calibration data
Timestamps
Temperature and compensation data
Additional GxP-relevant metadata
Further processing in Excel
After importing, you can use your measurement data in Excel to:
Visualize (charts, measurement trends)
Perform statistical analysis (mean values, standard deviations)
Filter and sort
Create GxP-compliant reports and documentation
