Exporting Data
(Select your language using the flags below if required)
Exporting Your Data
Up to 4 different export options are available to cater for different needs. All exports are produced as a CSV file, which can easily be opened with a program like Excel.
Summary & Workouts Export
An amazing export of your data to a csv file type. Users can input a date range and the export will summarise and extract all your key data, such as sleep, steps, distance, HR low/high, waking pulse, it even adds any notes and journal entries! All easily viewed in a line by day view. A very handy feature for those users who also like to work more closely with their data in other tools.
Detail Exports
Similar to the above but this is focused on additional information, providing a deeper detail for your heart rate over a single day or date range. The Detail export with the heart icon is focused on an extract of your daily heart rate measurements. The Detail view with the green person icon, is focused on a detailed extract of your heart during a workout for that day. It will also combine multiple workouts for the same day in the one export.
Using Exports
A step by step process is detailed below for using the Exports.
1. Go into Settings (little cog top right on the Today view)
2. Under the Export menu, select Summary or Workouts depending on the data your looking to extract
3. Select a date range for the export by tapping the available date fields. By default the last month will pre-fill. The maximum time period available for export is one years worth of data from todays date
4. If you would like to include any recorded HeartWatch Notes, tap on the notes toggle
5. Tap on the Export button at the bottom of the screen to produce the comma separated values (csv) file
6. Once the csv file is produced, you will some options for transferring the file. See below I can use AirDrop to send directly to Mac, I can email the csv or save the file to my iPhone. Your options will depend of course on your iPhone setup and iOS version available
7. Locate the transferred file and the csv export will open in your compatible software, such as MS Excel. You will see one row per day, as viewed in the below sample. The column names are abbreviated but self-explanatory, eg. "Sleep-lo-bpm" is the lowest beats per minute you recorded while sleeping.
As some measures may be recorded multiple times in a day, some rules are enforced for the following:
HRV - it uses the best resting reading
Blood Pressure - it uses the best reading for AM or PM
Temperature - it uses the latest reading
Sleep Glucose only shows if you have an active Sleep Glucose tile or News story
For missing entries between days, the Export will auto-fill values between the 2 values so you can see a trend. For example, if you recorded 70.0kg on 1 March and 80.0kg on 10th March, it will show 70.1kg on 2nd March, 70.2kg on 3rd March, etc. This allows users to see trends in the data.
As always, any questions feel free to contact us
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:
Exports Video
Try the following video which shows the basics for using the Summary & Workout Exports on the iPhone: