Exporting Your Data
There are 3 ways to export your data from within AutoSleep, each providing a different level of data:
Exporting from the History View (Simple history csv export)
Exporting from the Clock View (Simple daily image snapshot)
Exporting from the Settings View (Advanced date range csv exports)
1 - Export From History View
While in the History view, you will see a link called 'Export' in the top right corner of the page:
This will create a csv (comma separated value) file format which can be opened in a program like Excel and attached to an email. You can then email to yourself or whoever you wish to see the data.
The data exported is a basic summary across your history, with a line per sleep session showing all your sleep rings, such as sleep duration, time awake, time to fall asleep (requires lights out feature to be used), quality, deep sleep, average heartrate and any emoji tags or notes that you recorded. Sample:
2 - Export From Clock View
This is a great way to easily share an image of your sleep rings for a single sleep session. It is particularly useful to send as an iMessage to another person, example, "Mum, look at how much deep sleep I got last night!"
When on the Clock view, tap on the output icon on the top right corner:
Your sleep rings image will be created and ready to send. Tap on the round output icon again under the image and you will now have different options to send, share or save the image, such as using AirDrop, message, email and so on.
The below image shows a sample of the image being sent as a Message:
3 - Exports From Settings
For more advanced exports, go to the Settings tab and you will see 2 exports available, History and Actigraphy. These are more advanced and provide a finer level of detail.
This is the most commonly requested export and contains a great summary of your sleep data. Tap on History and enter a specified date range for the export.
Tap on Export when you are happy with the data range, this will start to compile the CSV file. A % progress bar will show at the bottom as it creates the file. Once ready, options will appear to send, share or save the export, such as using AirDrop, message, email and so on. The export can be opened in any program that is compatible with csv files, such as Excel. Here is a sample of the History export:
History export fields include:
From Date/To Date - the date the sleep session was recorded in
Bedtime / Waketime - the time you went to bed and awoke. Using Light Off feature gives a more accurate bedtime
InBed - how long you were in bed for, shown in hours, minutes and seconds
Awake - how long you were awake for, shown in hours, minutes and seconds
Fell Asleep - if you use the Lights Off feature, this will populate with the amount time it took you to fall asleep
Sessions - the number of sleep sessions recorded during the from and to date
Asleep / AsleepAvg7 - the sleep duration recorded along with the 7 day sleep duration average on that date
Efficiency / EfficiencyAvg7 - the ratio of time asleep versus time spent in bed along with the 7 day efficiency average
Quality / QualityAvg7 - quality considers how long you have slept, how restless you've been and your sleeping heart rate. It is shown as hours, minutes and seconds along with a 7 day sleep quality average
Deep / DeepAvg7 - where your heart rate slows and your muscles relax to a point where you barely move. It is shown as hours, minutes and seconds along with a 7 day deep sleep average
SleepBPM / SleepBPMAvg7 - your average heart rate shown in beats per minute for the sleep, along with a 7 day average of your sleeping heart rate
DayBPM / DayBPMAvg7 - your average heart rate outside of your sleep, generally during the day for most users, shown in beats per minute, along with a 7 day average of your daily heart rate
WakingBPM / WakingBPMAvg7 - your waking pulse shown in beats per minute which is automatically captured by AutoSleep , along with a 7 day waking pulse average
HRV / HRVAvg7- your Heart Rate Variability that was automatically captured by the Apple Watch or using the breathe app. AutoSleep will use the maximum value where multiple values exist for the same date. This will also show a 7 day average of your HRV
SpO2Avg/ SpO2Min / SpO2Max - your Blood Oxygen that was automatically captured by the Apple Watch while you sleep. Remember that you need background measures enabled for automatic measurements while you sleep
Tags / Notes - any emoji tags or notes recorded will appear in the export
Export CSV File Formatting Issues?
With lots of different computers and programs with different defaults, sometimes CSV files can look a mess when opened. When you have a CSV file that is separated by semicolons (;) and your system/Excel default is commas (,), you can add a single line to tell Excel what delimiter to use when opening the file. To do this:
Open your CSV using a text editor:
Windows: NotePage (notepad.exe)
Mac: TextEdit (textedit.app)
Skip a line at the top and add sep=; if the separator used in the CSV is a semicolon (;), or sep=, if the separator is a comma (,)
Save and reopen the file
Note: this newly added line will not show up when opening the file in Excel. Once you've opened up the Excel file (and the formatting looks good), you can re-save the file (if your default separator is a comma) so the "sep=" line is no longer present, which will allow for import.
Another option is using the in-built Excel convertor. This will vary by version, but the function is generally found in the Data tab under "Text to Columns". Follow the wizard to define the separators. See below:
AutoSleep is generally recognised by sleep researchers as one of the most accurate wearable sleep tracking solutions available today. To help sleep research institutes and universities with their sleep research, we have added a 24 hour actigraphy export option. We've benchmarked it against validated medical grade actigraphy devices and are happy to say that it exceeded even our own expectations!
Note that this is only for sleep institutes and universities as it is built for a specific purpose of validating sleep data against medical grade equipment. The Actigraphy export is passcode protected.
If you are a university or sleep research institution conducting sleep studies, then please get in touch with us via the support page. We have plenty of studies using AutoSleep and the Actigraphy export completed and new ones underway. We look forward to helping you!