Open your spreadsheet in Excel & Numbers

Guide to the app's "Export" tab · September 2026

The app's interface is German only. The German button labels are given in quotes below so you can follow along without knowing the language.

Three steps

  1. In the "Export" tab, pick a period: "30 Tage" (30 days), "90 Tage" or "1 Jahr" (one year).
  2. Tap "Tabelle erstellen" (create table). The app reads your values from Apple Health — that takes a moment and happens entirely on the iPhone.
  3. 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,SpO₂,97.4,%
2026-08-01,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 two clicks. 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: steps, sleep and its stages, resting heart rate, HRV, heart rate, VO₂max, respiratory rate, SpO₂, weight and body composition, distances and more — depending on what your Apple Health actually holds. What is missing there is missing here.

Units are converted for humans: 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 UK or US device gets the US dialect, which suits an English Excel and Google Sheets. A German, Austrian or Swiss device gets EU — and then an English Excel needs a hand.

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.

One honest 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.

Umlauts, ₂ and µ

No trouble there. The file is UTF-8 and starts with the byte mark Excel uses to detect the encoding. "SpO₂" and "Gehen & Laufen" 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 a different animal: 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 enjoys. 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.

What we cannot know

Whether your numbers are "right" is Apple Health's call, not this app's: we add nothing up ourselves but let the daily total be formed there — 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.

← Back to the start page