Simple Apple Health XML to CSV

A simple script to convert Apple Health's export.xml file to an easy to use csv.

How to Run

1. Verify you have Python 3 & Pandas installed on your machine or environment

python --version should return Python 3.x.x where x is any number.

If you have Python 2.x.x, please upgrade to Python 3 here: https://www.python.org/downloads/ (or specify your environment's Python version)

python3 -c "import pandas" should return blank from the command line

If you get a ModuleNotFoundError: No module named 'pandas' error, install pandas and try again:

pip3 install pandas

2. Export your Apple Health Data

Go to your health home screen and click on the profile icon

On the next page, click the "Export Health Data" button

Your data will be prepared, and then you can transfer the export.zip file to your machine.

3. Unzip the file, which should contain:

• apple_health_export

  • export.xml

  • export_cda.xml

4. Place the "apple_health_xml_convert.py" file from this repo into the folder alongside the files and run the script

python3 apple_health_xml_convert.py

The export will be written with the format:

• apple_health_export_YYYY-MM-DD.csv

In Excel, the output should look something like this:

Note: This script removes the Apple Health data prefixes: HKQuantityTypeIdentifier, HKCategoryTypeIdentifier, and HKCharacteristicTypeIdentifier for increased legibility. Feel free to comment out those lines in the code with a # if you want to keep them in the CSV output.

FORK: Transform the output to two new versions (a shorter one and a shorter and transposed one)

The first new output file is apple_health_export_grouped_YYYY-MM-DD.csv and should look like this:

The second one is apple_health_export_transposed_YYYY-MM-DD.csv and should look like this:

The reason behind this fork is that these output files might be more useful for analysis, especially if you want to combine the Apple data with other fitness/health data in a more 'standard' format.