Export your Health data
Health app → your profile picture → Export All Health Data, then get export.zip to your computer
(step by step). Excel needs a computer: the workbook can have hundreds of thousands of rows,
one sheet per measurement, which the Excel and Numbers apps on a phone struggle to open.
Get it into Excel
- Drop
export.zipon the box above. Excel workbook is already selected. - Pick the data you want (steps, heart rate, weight, sleep…) and, if you like, a date range.
- Click Export and open
apple-health.xlsxin Excel, Numbers or Google Sheets.
The sheets in the workbook
- Daily summary — a row per day and a column per data type, as real numbers, with a frozen header and filters.
- Sleep — hours asleep per night, split into core, deep and REM sleep.
- Workouts and Activity rings.
- Optional: a sheet per data type with every single measurement (up to 200,000 rows per sheet; use CSV for more).
Ideas for your workbook
- Select the date and weight columns and insert a line chart to see your trend.
- Add a 7-day moving average of steps with
=AVERAGE(B2:B8)and fill it down. - Use a PivotTable on the daily summary to compare months or weekdays.
- Compare sleep hours with resting heart rate side by side.
How the numbers are calculated
- Daily summary — one row per day: steps, distance, active and resting energy, flights, exercise minutes (totals) and heart rate, HRV, blood oxygen and more (average, minimum, maximum). Weight shows the last measurement of the day.
- Sleep — hours per night by stage (core, deep, REM, awake) and time in bed.
- Workouts — type, start, duration, distance, energy and average heart rate.
- Activity rings — Move, Exercise and Stand per day, with your goals.
- Every measurement — in the CSV download, one file per data type with start, end, value, unit and source.
iPhone and Apple Watch together? Both count your steps. The Health app merges them; the workbook takes, per day, the device with the highest total, so your daily steps match the Health app.
Private by design
A Health export can hold years of heart rate, sleep and body measurements. The workbook is built on your own computer from the zip you drop here; no part of it is uploaded, and the page keeps nothing once you close it.
Frequently asked questions
Can I open Apple Health data in Excel?
Not the raw export — it is a huge XML file. Convert it here to an .xlsx workbook with one sheet per table, then open it in Excel.
Is there a row limit?
Excel holds about one million rows per sheet. The daily summary always fits; sheets with every measurement are capped at 200,000 rows — download CSV for all of them.
Does it work with Numbers and Google Sheets?
Yes. The .xlsx opens in Apple Numbers, Google Sheets and LibreOffice too.
Is my health data uploaded?
No. Everything happens in your browser.