The sleep-export.csv file is a backup file that contains data from sleep records. Each record is saved onto two lines (manually inserted sleep records), or three lines (sleep records recorded by sleep tracking).
The 2nd row of the (times) headers are explained, but what does the first row mean?
Hi @Tamas_Kende, the first row (the headers) is explained in the article in the first section in the table.
Second line contains values.
Example:
ID: assigned ID for making each entry unique
Timezone of the data: Prague
From: the trackign started 11th February 2026 at 21:19
To: the tracking ended on 12th February at 06:36
Sched: next alarm was set for 13th February at 06:15
Hours: the tracking lasted 9.29 hours
Rating: no rating
Comment: added tag is phaser
Event was awake start (+time stamp)
Event was light value was 39lux (+time stamp)
Event was light value was 47 lux (+time stamp)
Event was awake end (+time stamp)
Numbers in the second line represent the sensor values (under the time headers).
thank you so much for your quick answer, I see two lines (below the header) in the hours columns (headers like 23:38, 23:43, values like 2.5900738, 14293.198) so those are sensor values, I guess the sonar or motion values or both? Is there any guide how to interpret them?
Thank you!
The second and third line are explained in the article below the table.
The second line has values from the sensors (aggregated data), the third line has noise value (aggregated data).
Motion values = accelerometer values or sonar values, depending on which sensor was used for the tracking. There can be only one source of movement data, so it is either sonar, phone accelerometer, or wearable accelerometer.
We currently do not provide guide on how to interpret the aggregated values.