8 exporting data, Exporting data, Section 9.8 e – Xylem WQL-Cond CONDUCTIVITY DATALOGGERS User Manual
Page 74: Xporting, Data
Working with the database and measurement data
WQL-Cond
170
ba75822e01
03/2011
9.8
Exporting data
The data displayed as a graphic with the aid of the Query menu can be
exported to a *.csv file. The WQL-Log program creates three csv files with
each export procedure: One with the measurement data, one with the
calibration data and a third one with the setting data.
In this form the data can be read and processed with Microsoft Excel and
many other spreadsheets.
Proceed as follows to export the datasets displayed as a graphic:
Note
If the number of datasets to be exported is more than 60,000 and the data
are to be processed with Microsoft Excel 2007 or older, export the data with
the function, "Export as *.csv file (splitted)", as Excel versions 2007 and
older can store only 60,000 datasets in one worksheet. The number of
datasets is given in the header of the graphic, next to the series number of
the logger that provided the data.
1
In the Export menu, click the menu item, Export as *.csv file or Export
as *.csv file (splitted).
The Save as window appears.
2
The WQL-Log PC program suggests a directory and file name. Store
the data to be exported in the selected directory under the required
name with the Save button.
3
A note on the successful data export appears. Confirm with OK.