1. Home
  2. All Topics
  3. Software Topics
  4. CSV representation via Open Office/Excel

CSV representation via Open Office/Excel

The export and display of measurement data works completely without internet or cloud functions:

  1. Export measurement data
  2. Open “Open Office Calc” and open the CSV file via “Open” or double-click the CSV file (or right-click and “Open with…”)
  3. As character set you choose “UTF-8“, as languageEnglish(USA)” and as separator the semicolon. Everything else you leave deactivated or deactivate it yourself, then you get a picture like here:
  1. Now, depending on which values are to be compared, click on the columns at the top while holding down the CTRL key (A, B and K in my case, i.e. the comparison between CO2 and VOCs as a function of time.
  2. For a graphical representation select Insert->Diagram and then the desired diagram type (here once as “points and lines” scheme)
  3. Finally, you select the data range (which fields from the table should be in the diagram), label the data series and the axes and have a finished diagram, which can be resized as desired, for a slightly better representation is recommended here to show the grid of the x-axis with and a right click on the x-axis (date) of the diagram. Here you select “Format axis” and under the point “Arrangement” then “Side by side”.

This sounds a bit complicated, but it works very fast and offers even more filtering and customization options than the display via our in-house cloud. In addition, you can compare more than two devices here by copying columns from other CSV files from other devices and pasting them here into the ODS file that is ultimately converted from them. after that, you can simply specify them as sources in self-created charts. Here the procedure once visually represented:

Here “Open Office Calc” was used, which is free of charge. It also works with Excel, whereby the way here is minimally different, but exactly the same scheme.

Attention: If the measurement data was converted via https://converter.air-q.com , “German” must be selected as the language, since the separators are displayed differently here.

Was this article helpful?

Related Articles

Sie benötigen Hilfe?
Sie können die gesuchte Antwort nicht finden? Kontaktieren Sie uns gern!