Skip to content
Convert an Apple Healthkit export zip to a SQLite database
Branch: master
Clone or download
Latest commit 58b65b5 Jul 26, 2019
Type Name Latest commit message Commit time
Failed to load latest commit information.
.circleci Initial framework Jul 20, 2019
healthkit_to_sqlite Fix for #9 - too many SQL variables Jul 26, 2019
tests Break records out into separate tables, closes #6 Jul 22, 2019
.gitignore Initial framework Jul 20, 2019
LICENSE Documentation for progress bar / --silent Jul 22, 2019 Release 0.3.2 Jul 26, 2019


PyPI CircleCI License

Convert an Apple Healthkit export zip to a SQLite database

How to install

$ pip install healthkit-to-sqlite

How to use

First you need to export your Apple HealthKit data.

  1. On your iPhone, open the "Health" app
  2. Click the profile icon in the top right
  3. Click "Export Health Data" at the bottom of that page
  4. Save the resulting file somewhere you can access it on a laptop - I used Dropbox

Now you can convert the resulting file to SQLite like so:

$ healthkit-to-sqlite healthkit.db

A progress bar will be displayed. You can disable this using --silent.

Importing from HealthKit  [#-------------]    5%  00:01:33

You can explore the resulting data using Datasette like this:

$ datasette healthkit.db
You can’t perform that action at this time.