Convert your Apple Health export to CSV and JSON
Choose the export.zip from the Health app and get spreadsheet-ready files back: daily totals for every metric, sleep and other categories in minutes per day, every workout, and the raw records of any metric you pick. It is free and runs entirely in this browser. The page is not allowed to make network requests, so your health data never leaves your computer.
Your files
Every record of one metric
Heart rate, for instance, comes as thousands of samples a day. Pick a metric for a CSV with each sample, its source and its time.
What your export contains
How do I get export.zip from my iPhone?
- Open the Health app and tap your picture or initials, top right.
- Tap Export All Health Data at the bottom, then Export.
- Wait while it builds the file. Years of data can take several minutes.
- Send
export.zipto your computer with AirDrop, or save it to Files and open this page in Safari on the iPhone.
A computer is the better place for a big export. A phone browser can run out of memory on an export of several gigabytes.
What is in each file?
| File | One row per | Columns |
|---|---|---|
apple-health-daily-metrics.csv | Day, metric, source and unit | date, type, source, unit, samples, sum, average, min, max |
apple-health-daily-categories.csv | Day, category, source and value | date, type, source, value (for sleep: InBed, AsleepCore, AsleepDeep, AsleepREM, Awake), samples, minutes |
apple-health-workouts.csv | Workout | start, end, activity, minutes, source, distance, distance unit, active energy, energy unit, average heart rate |
apple-health-summary.json | Everything above | The same rows as JSON, plus a list of every type with its record count and date range |
apple-health-<metric>.csv | Sample, for the metric you pick | type, source, unit, value, start, end |
Dates are the day each sample started, in the time zone your phone recorded it in. Type names drop Apple's prefixes, so HKQuantityTypeIdentifierStepCount becomes StepCount. Use sum for things that add up over a day (steps, distance, active energy, dietary nutrients) and average, min and max for readings (heart rate, weight, blood oxygen).
Why are my steps higher than the Health app shows?
Because your iPhone and your Apple Watch both count steps, and Apple Health keeps both sets of samples. The Health app shows one total by preferring one source when they overlap. The export does not do that work for you, so this converter keeps each source on its own row instead of adding them together. For a daily step count, use the row for one source (usually your watch), or the higher of the two, rather than the sum of both.
Is my data uploaded?
No. The converter is two scripts that run on your computer (the page and the parser, both readable). This page is served with a security policy that blocks every network connection, so even a bug could not send your file anywhere, and there is no analytics on it. You can switch off Wi-Fi after the page loads and it works the same.
How big an export can it handle?
Gigabytes. It reads the zip as a stream instead of loading it whole, so memory stays low however big export.xml is, and the large-file (zip64) format Apple uses for big exports works. In our tests a 1.1 GB export (over four million records) took about 20 seconds. It needs a current Safari (16.4 or later), Chrome, Edge or Firefox.
Want this without exporting every time?
The Health app's export is a full backup, rebuilt from scratch each time. Marrow Health reads Apple Health directly on your iPhone, so you can export any metric as CSV or JSON, and workout routes as GPX, whenever you like, with daily totals reconciled against Apple's own (no double-counted steps). It can also push your data to a URL on a schedule, or let an AI read it. All of that is free.
More on the options: every way to export Apple Health data, scheduled exports, and giving an AI agent access.