/Simple-Apple-Health-XML-to-CSV

A simple script to convert all records from an Apple Health 'export.xml' file into a csv

Primary LanguagePythonBSD 2-Clause "Simplified" LicenseBSD-2-Clause

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

Health Home ➡️ Export Data

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 (This is the file with your data that you want to convert)

    • 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.