ahcd

Apple Health Care Data convert xml to csv

Introduction.

Are you using the iOS app Health? If you're one of those people, your health data, such as your weight, sleep duration, and steps, is might recorded on your Apple Health app. The app shows some graph and visible data on the app, but why don't you want to analyze the data yourself. there are many forms of data analysis and data visualization. In this repository , I'd like to use a spreadsheet application like Excel or Google Sheets to csv output for analysis. I'm going to show you how to do this with I created a CLI.

How to extract Apple health data.

First, take a look at this

• Open Health on your iPhone.
• Tap the profile icon in the top right corner.
• Scroll to the bottom of your health profile and tap "Export All Health Data".
• Tap "Export" to confirm you want to export the data and start the export process (may take some minutes to complete)
• Save the extracted file to your local computer or Google Drive

extracted files.

you are going to use the export.xml in the context

Nodejs Environment Settings

Please build a local Nodejs environment by referring to the following links

• How to Install Node.js and NPM on Windows
• Installing Node.js® and NPM on Mac

How to install the command

Install the command ahcd

$ npm i -g ahcd

Usage.

$ ahcd                                                                                                                                                                                                
================================================================================
Apple Health Care Data convert xml to csv

Author     : Fumikazu Fujiwara 
Homepage   : https://github.com/freddiefujiwara/ahcd#readme
LICENSE    : MIT
Report bugs: https://github.com/freddiefujiwara/ahcd/issues
================================================================================

Usage: ahcd [-h] <file> [-t <type>] [-d <dir>]

• The ＜file＞ argument must be export.xml which I mentioned.
• -t outputs only a specific csv (e.g. -t BodyMass)
• -d specifies the directory to output to (e.g., -d /path/to)

Demo

$ ahcd -d . export.xml                                                                                                                                                                                
Read export.xml
Analyze export.xml
Wrote . /Height.csv (1 records)
Wrote . /HeartRate.csv (87 records)
Wrote . /BodyMassIndex.csv (50 records)
Wrote . /BloodPressureDiastolic.csv (165 records)
Wrote . /BodyMass.csv (51 records)
Wrote . /BodyFatPercentage.csv (50 records)
Wrote . /FlightsClimbed.csv (1045 records)
Wrote . /BloodPressureSystolic.csv (165 records)
Wrote . /SleepAnalysis.csv (1193 records)
Wrote . /StepCount.csv (12032 records)
Wrote . /DistanceWalkingRunning.csv (13631 records)

Finally

Now you can analyze it in a sheet such as Excel and google sheet. Also, ahcd is welcome to pull request Thanks for reading the final part of the article