Why CSV
The most useful boring format
Use daily totals in Excel, Google Sheets, or Numbers to build charts and compare days. Check the exported Unit column before combining metrics. For source-level records with nested values, choose a CSV-aware analysis tool or export JSON.
Choose your workflow
Export in an app, or convert an XML archive
Apple Health's built-in export produces an XML archive. Conversion tools and scripts can turn that archive into CSV. Other App Store apps also offer CSV export without building a project.
With Health.md, choose your metrics and dates on your iPhone, preview the output, and save it to your own folder. The same export can also write JSON, Markdown, or Obsidian Bases files.
Choose a format
CSV for spreadsheets, Markdown for your journal
You can enable more than one format for the same export. Start with the output you will actually use.
| Your goal | Format | What to expect |
|---|---|---|
| Charts and spreadsheets | CSV | Rows of metrics with values and units. Start with Summary for daily totals. |
| Scripts and source records | JSON | Structured daily data; optional Lossless Health Records retains canonical source records when available. |
| A readable health journal | Markdown | Daily notes with headings and selected health metrics. |
| Obsidian database views | Obsidian Bases | Frontmatter properties for filtering and comparing notes in Bases. |
Want health data beside your journal? Follow the Apple Health to Obsidian walkthrough. On Android, use the separate Health Connect guide; available metrics and export contracts differ by platform.
How it works
Your first CSV, from selection to saved file
Start with one date you can check in Apple Health. Follow the first-export screenshot walkthrough if you are setting up Health permissions or a destination for the first time.
Authorize and pick metrics
Install Health.md, authorize the Apple Health categories you want, and select exactly which metrics go into the export.
Start with one day
Choose Summary for daily totals, select one date, and preview the file before writing it. Once the output fits your workflow, export a longer range.
Open it anywhere
Enable CSV, choose a writable folder in Files, and tap Export Data. Review the result, open the folder, and import one generated file into your spreadsheet.
These captures use the real app interface and CSV writer with fictional health data in a simulator. They demonstrate the file workflow; your permissions, available metrics, and values will differ. Select a screenshot to inspect it.
Download the fictional CSV shown above to inspect the saved rows. Its sleep total is 23,400 seconds (6.5 hours); Steps is 12,500 count. The reference sample at the top of this page uses a different fictional day.
Find the file you just saved
After Export Data finishes, review the written, skipped, or failed files. Open Files → Browse and the folder you selected in Health.md. Find the CSV for your chosen date; daily exports write separate files for separate dates.
A successful Preview checks the output, not the file write. If the folder is empty, check the export result and reselect a writable destination before trying again.
Try a finished spreadsheet
28 days, two charts, and the CSVs behind them
Open the fictional workbook before using your own data. It includes raw rows, daily steps and sleep views, and working charts. No app, health permissions, or sign-in is needed to download it.
Download the full sample pack for the workbook, 28 daily CSV inputs, combined CSV, and README. Or download the combined CSV for a spreadsheet import.
- Inspect the result: open the workbook in Excel and compare its raw rows with the steps and sleep charts. Its dates and input ranges are fixed; adding rows does not extend them automatically.
- Try the inputs: unzip the pack, then use the browser combiner to append its daily CSVs. The combiner preserves rows; it does not create charts or an Excel workbook.
- Repeat with your data: export one known day, verify the saved CSV, then follow the Excel guide or Google Sheets guide. Importing to Sheets sends that copy to Google.
The sample pack is a separate fictional dataset from the app captures above. Health.md exports CSV files, not an Excel workbook; the workbook is an example of what you can build from them.
After the export
Turn daily CSVs into a weekly review
Prefer a local script to a spreadsheet? Try the weekly CSV review example. It includes a Python script, the same 28 fictional daily inputs, and an expected Markdown report. Python 3.9 or later must already be installed; no extra packages or uploads are needed.
Run python3 weekly_review.py from the unzipped example. The sample produces 249,630 total steps over 28 recorded days and 7.49 hours average sleep over 27 recorded days. Missing sleep stays missing, and recorded zero values stay included.
Inspect the expected report, read the script, or follow the step-by-step local review instructions. The script uses daily summary files, not the combiner's combined.csv. It processes files already on disk and does not pair devices or schedule exports.
From file to spreadsheet
Open your Apple Health CSV in Excel, Sheets, or Numbers
Try the 28-day workbook and CSV pack for a complete example, or the single-day synthetic CSV to check a basic import. Keep these fictional datasets separate from your own records.
Excel on desktop
Use Data → From Text/CSV (under Get Data in some versions), select the file, and check the comma delimiter in the preview before loading. Keep Metric and Unit as text and inspect date conversions. See Microsoft's CSV import instructions. Follow the Apple Health to Excel guide for filtering, combining daily files, and weekly PivotTables.
Google Sheets
Open a spreadsheet, choose File → Import → Upload, and select the CSV. Insert a new sheet and choose Comma if automatic separator detection is wrong. Importing sends the file to Google; try the synthetic sample before deciding whether to upload your records. See Google's import instructions. Follow the Apple Health to Google Sheets guide for combining dates, weekly pivot tables, and charts.
Numbers on Mac
Open the CSV in Numbers. If the columns do not separate correctly, adjust the text import settings and delimiter before editing the table. See Apple's Numbers import guide.
Filter to the Category and Metric you want before charting Value. Keep Unit visible, exclude metadata rows, and do not add daily totals to individual readings. A longer date range produces multiple daily files; do not assume it is one combined workbook.
Ready to use your own data? Get Health.md for iPhone, authorize the metrics you need, and export one day as CSV.
Free browser tool
Combine daily Health.md CSV files
Append daily exports into one CSV with a single header before importing into a spreadsheet. Files are processed in this tab; the combiner does not upload them or send filenames, values, or row counts to analytics.
Choose up to 31 UTF-8 CSV files, at most 1 MiB each and 5 MiB total, with up to 50,000 combined rows. Each file must use Date,Category,Metric,Value,Unit,Timestamp. Both five-field rows with an omitted Timestamp and six-field rows are kept as provided. Apple XML archives and other column layouts are not supported.
Up to 31 files · 1 MiB per file · 5 MiB total · 50,000 rows
Choose daily CSV exports, or try the fictional example.
Download combined CSVUse files from the same export profile and format settings. Metadata rows stay in the output. Files are appended in the order supplied by your browser; no date sorting is performed. Values, dates, and units are preserved; duplicate or overlapping rows remain. The tool does not calculate totals or reconcile changed exports. Review your selection before charting so repeated days are not counted twice. Formula-like cells are not accepted.
Clear removes the tool's current selection and download link. It does not delete saved downloads. Original files stay unchanged; downloaded output and backups follow your browser and storage settings.
Check your first file
Verify dates, units, and missing data
- For daily activity counts, follow the Apple Health steps export guide and keep daily totals separate from source records.
- Check the Date and Unit columns before combining rows. A distance in meters is not a distance in kilometers.
- Export Yesterday for an overnight sleep session that started yesterday. Follow the sleep export walkthrough and read how sleep dates are assigned.
- For exercise sessions, follow the Apple Health workout export guide. Several CSV rows describe one workout; use JSON for per-session identity and grouping.
- For daily heart statistics or timestamped readings, use the heart rate export guide. Keep bpm separate from HRV milliseconds; use the HRV export walkthrough for SDNN averages and samples.
- If a metric is missing, follow the Apple Health export missing-data checklist to check source records, dates, selection, and permissions. Missing data does not mean zero.
- If Preview works but writing fails, reselect the destination folder and check that its file provider is available. See the folder troubleshooting guide.
After changing permissions, let your watch or source app finish syncing with Apple Health and try that date again. For a screenshot walkthrough of authorization, Preview, and export results, see your first iPhone export.
The file itself
What's in the CSV
Daily exports write one CSV file per day with the header Date,Category,Metric,Value,Unit,Timestamp. Compatibility summary rows can omit the final Timestamp field; metadata, timestamped, and canonical-record rows use all six fields.
Synthetic example (selected rows). These rows come from the production-generated Apple schema v8 reference fixture, not a person's health data. The full file includes more metrics and metadata.
Date,Category,Metric,Value,Unit,Timestamp
2026-03-15,Metadata,schema,healthmd.health_data,,
2026-03-15,Metadata,schema_version,8,,
2026-03-15,Raw HealthKit,Raw Capture Status,not_requested,status,
2026-03-15,Activity,Steps,12500,count
2026-03-15,Activity,Walking Running Distance,9500.0,meters
Download the full synthetic CSV to try an import without sharing your own data. Daily aggregates have no single measurement timestamp. In this example, not_requested means the canonical source archive was off, not that the export failed.
Lossless Health Records adds canonical JSON objects inside CSV cells. Those cells can contain commas, quotes, and line breaks; use a standard CSV importer rather than splitting on commas. See the CSV format reference for the complete row contract and source-record examples.
Privacy
Your data stays yours
Folder exports are local-first by default. Health.md writes the CSV to the folder you choose without creating a Health.md server copy or requiring a Health.md account. If that folder syncs, its provider's terms apply.
The separate, optional single-owner Health.md Cloud pilot retains API exports intentionally uploaded to it. There is no public signup and no automatic device sync. This CSV folder workflow does not upload to that pilot. See the privacy policy for retention, deletion, and the pilot's unbacked storage limits.
Keep going
More ways to use your data
Starting with export.xml? Read the Apple Health XML export guide. Health.md creates fresh exports from authorized device data; it does not convert an existing archive.
Prefer a local script? Analyze Apple Health CSV with Python using a tested steps report, with no package installation or cloud upload.
Still choosing an app? Compare Health.md and Health Auto Export before setting up your spreadsheet or automation.
Every format, not just CSV
JSON, Markdown, and Obsidian exports from the same picker. Export Apple Health data
Analyze it with AI
Drop the CSV into Claude or ChatGPT, or connect Codex and Claude directly via MCP. Use Apple Health with AI
Read the docs
CSV row contracts, fixtures, and the full export reference. Export format reference
Make it your own
Open a sample. Export one day.
Once the sample fits your spreadsheet, use Health.md to export your own selected metrics. Start with one day, verify the values, then choose a longer range.
Try a CSV export on iPhone5 free export actions, then one lifetime purchase. Prefer a journal? Explore the free Obsidian starter vault.
Common questions
Frequently asked questions
Do I need a Mac or Xcode to export Apple Health to CSV?
No. Health.md is a shipping iOS app — you choose metrics and a date range on your iPhone and get CSV files back. Nothing to build, no scripts to run, no Mac required.
Which health metrics can I export to CSV?
Choose from supported Apple Health metrics, including steps, heart rate, HRV, sleep, and workouts. Availability depends on your device, OS, source data, and Health permissions.
What date ranges can I export?
Today, yesterday, all available history, or a custom start and end date — per export.
Can I open the CSV in Excel or Google Sheets?
Yes. Start with Summary for daily totals, export one day, and import the CSV into Excel, Google Sheets, or Numbers. Lossless Health Records adds nested JSON cells for source records; use a CSV-aware tool to preserve those values.
Can I combine multiple daily CSV files?
Yes. The free combiner on this page appends supported Health.md CSV files in your browser with one header. It preserves values and duplicate rows, does not calculate totals, and does not upload your files. It does not convert Apple XML archives.
Is it free?
The app includes 5 free export actions. One action can include multiple dates and formats. After that, a one-time lifetime unlock removes the limit — no subscription. The App Store shows your current localized purchase price.