Open your Apple Health data in Excel & Numbers
Three steps
- In the "Export" tab, pick a period: "30 Tage" (30 days), "90 Tage" or "1 Jahr" (one year).
- Tap "Tabelle erstellen" (create table). The app reads your values from Apple Health — that takes a moment and happens entirely on the iPhone.
- Tap "Tabelle teilen oder sichern" (share or save). The standard iOS share sheet opens: save to Files, mail it to yourself, put it in your cloud — whatever suits you.
The file is called health-days-2026-08-01_2026-08-31.csv, with the start and end of the period in the name. The second date is today, for which there are naturally no complete values yet.
How the table is built
Four columns, and one row per day and metric — not one row per day. A day with fourteen recorded values produces fourteen rows carrying the same date:
Day,Metric,Value,Unit 2026-08-01,Steps,9182, 2026-08-01,Oxygen saturation (SpO₂),97.4,% 2026-08-01,Distance (walking & running),8.25,km 2026-08-02,Sleep,7.17,h
That looks unwieldy at first, but it is the shape spreadsheets handle best: a pivot table turns it into the wide view you probably have in mind — days as rows, metrics as columns. In Excel: select the cells, Insert → PivotTable, "Day" into rows, "Metric" into columns, "Value" into values. In Numbers it is Organize → Pivot Table.
Eighteen measures are included, named as in the app: Steps, Sleep, Deep sleep, REM sleep, Core sleep (light sleep), Awake, Resting heart rate, Heart rate variability (HRV), Heart rate, VO₂max, Respiratory rate, Oxygen saturation (SpO₂), Wrist temperature during sleep, Weight, Active calories, Resting energy, Exercise time and Distance (walking & running) — depending on what your Apple Health actually holds. Metrics with no data there produce no rows. On a German-language iPhone the column names are German.
The names in this guide apply from the 1.0.1 update. If your iPhone still runs version 1.0.0, seven of them are named differently: Light sleep, HRV (SDNN), Heart rate (day avg), SpO₂, Wrist temperature, Active energy and Walking & running — updating from the App Store fixes that.
Values are converted to everyday units: percentages as 97.4 rather than 0.974, distances in kilometres, sleep in hours, sleep stages in minutes. Steps have no unit, so that column stays empty.
When everything lands in one column
This is the stumbling block, and it has nothing to do with the app: Excel decides from your Windows or Office regional setting which separator to expect in a .csv. If that doesn't match what's in the file, you get everything in column A.
The app writes in two dialects:
EU separator semicolon (;) decimal comma 36,9 US separator comma (,) decimal point 36.9
By default it follows how your iPhone writes numbers: a device whose region writes decimals with a comma (Germany or Austria, for example) gets the EU dialect; one whose region writes them with a point (UK, US or Switzerland, for example) gets US. US suits an English Excel and Google Sheets; with EU, an English Excel needs one of the fixes below.
How to switch: "Export" tab → "Erweiterter Export" (advanced export) → section "Format" → the picker "Zahlen- & Datumsformat (CSV)". The three options read Automatisch (Gerät) (automatic, follows the device), EU — 36,9 · Semikolon and US — 36.9 · Komma. Your choice then applies to the simple path as well — switch once and carry on exporting as usual.
You can also fix it without re-exporting: in Excel use Data → Text to Columns, "Delimited", and pick the right separator. In Google Sheets, turn off "Detect automatically" on import and name the separator. Numbers usually recognises both dialects by itself.
Note on the label: the picker says "number & date format" but only changes the separator and the decimal mark. Dates stay 2026-08-01 in every case — unambiguous internationally and sortable in any spreadsheet.
Special characters such as ₂
The file is UTF-8 and starts with the byte order mark (BOM) Excel uses to detect the encoding. "Oxygen saturation (SpO₂)" and "Distance (walking & running)" — or the German names with their umlauts — therefore appear correctly without you setting anything on open.
More than eighteen measures
The simple path covers the eighteen measures most people want. For more, "Erweiterter Export" opens all 188 data types from Apple Health, plus the JSON and NDJSON formats and the period "Alles (10 Jahre)" (everything, ten years).
That file is structured differently: it holds individual samples rather than daily values — for heart rate and steps that can run to hundreds of thousands of rows, more than a spreadsheet handles comfortably. Its ten columns are always English and always the same (type, value, unit, start, end, day, source, source_bundle, device, sleep_stage), regardless of your device language. The layout is described in the format reference.
Where the daily totals come from
Whether your numbers are "right" is decided in Apple Health, not in this app: the app adds nothing up itself but uses the daily totals Apple Health computes — which is why the table shows the same figure as the Health app. If something differs from another app, it is almost always about which sources feed into it. The Info tab's "Datenquellen prüfen" (check data sources) shows what is actually being read.