Skip to main content

Exporting CSV data

Consibio Support Team
Updated

Download guide as a PDF

 

Downloading the CSV file

Open CSV export tool

  1. Open your project in Consibio Cloud.
  2. Go to the “Reports” section:
  3. Click on the “Export data” button in the top right corner:
  4. The CSV export tool opens:

 

Select the parameters and time range for the export

  1. Click on “Select elements” to choose which parameters should be included in the exported data:

     
  2. Select the elements you need in the elements selector:

     
  3. Adjust which time range you want the exported data from:

     
  4. Optional: If you are exporting data from multiple sources (i.e., they originate from different devices), the timestamps might be slightly different resulting in separate rows in the exported data. Set the “Align timestamps” field to a non-zero value to force the timestamps to be aligned to the selected interval. Leave this as zero if you are not sure how to use it.

Download the data

  1. Click on “Download” to download the CSV file to your computer:

 

Understanding the CSV file

The file is a CSV file (Comma Separated Values), so it is a text file with tabulated data separated by commas:

Timestamp,Date (UTC),Date (local),H2S
1775124340,2026-04-02T10:05:40Z,2026-04-02T12:05:40,0.0
1775127580,2026-04-02T10:59:40Z,2026-04-02T12:59:40,0.0
1775127600,2026-04-02T11:00:00Z,2026-04-02T13:00:00,0.0
1775127670,2026-04-02T11:01:10Z,2026-04-02T13:01:10,0.0
1775127720,2026-04-02T11:02:00Z,2026-04-02T13:02:00,0.0
1775127780,2026-04-02T11:03:00Z,2026-04-02T13:03:00,0.0
1775127840,2026-04-02T11:04:00Z,2026-04-02T13:04:00,0.0
1775127900,2026-04-02T11:05:00Z,2026-04-02T13:05:00,0.0
1775127960,2026-04-02T11:06:00Z,2026-04-02T13:06:00,0.0


Most spreadsheet programs (Microsoft Excel, Google Sheets etc.) can import this file format directly and convert it into columns and rows in the spreadsheet automatically.

Each row represents an entry in the datalog.
It contains 3 columns for the timestamps and then one column for each selected element that is included in the export (in this case a single column called “H2S”):
 

  1. Timestamp
    This column is a UNIX timestamp. It represents the amount of seconds elapsed since Jan. 1st 1970 at 00:00 UTC time (timezone 0). It is a standard that computers internally use to represent time and is used if the exported CSV data is used programmatically.
     
  2. Date (UTC)
    Shows the date and timestamp in UTC time according to the ISO 8601 standard for dates.
    On the first row in the example, we have this value: 2026-04-02T10:05:40Z
    The format is: <year>-<month>-<day>T<hour>:<minute>:<second>Z
    In this case, the date is 2nd of April 2026 at 10:05:40 (5 mins and 40 secs past 10am) 
    The "Z" in the end denotes that it is "Zulu time", which is another term for UTC time.
     
  3. Date (local)
    Denotes the date and time in the same format, but in your own timezone (the timezone of the computer where the export was made).
    On the first row, this column has the value: 2026-04-02T12:05:40 
    Thus, it is the 2nd of April 2026 at 12:05:40 (5 mins and 40 secs past 12pm) in the local time.
     
  4. <A column for each element>
    After the 3 timestamp columns, there is a column for each element selected in the export. In the example, there is a single column called “H2S [ppm]”. 
    The value in this column is the value of the element at the time shown in the same row. In the example it is simply: 0.0 ppm.

    The unit of the value is shown in the brackets after the parameter name “H2S [ppm]”.

Related articles