To analyze Apple Health data in Excel, export the metric you want from HealthSave as CSV, open it in Excel, then use a PivotTable to roll the dates up into weekly or monthly averages and a chart to see the trend. HealthSave writes clean, per-metric CSV that opens directly in Excel, Numbers, or Google Sheets, no XML wrangling.

Updated June 2026

Why Excel, and why not Apple's own export

Apple Health stores everything on your phone but gives you no way to analyze it. Its Export All Health Data produces a single massive export.xml archive that Excel simply can't open in any useful way. HealthSave skips that entirely: pick a metric, get a tidy CSV with one row per sample, and you're ready to pivot and chart in minutes.

What the CSV looks like

Each export is a simple, analysis-ready table, a timestamp, a value, and a unit per row:

date,value,unit,source
2026-06-01 07:14,58,count/min,Apple Watch
2026-06-02 07:02,61,count/min,Apple Watch
2026-06-03 06:58,57,count/min,Apple Watch

Analyze it in 5 steps

1. Export as CSV. In HealthSave, pick the metric (e.g. resting heart rate) and export CSV, it's free.
2. Open in Excel. Double-click the file; the columns line up automatically.
3. Insert a PivotTable. Select the data, Insert → PivotTable, put the date in Rows and the value in Values (set to Average).
4. Group by week or month. Right-click a date in the pivot, Group, choose Months (or Days/Weeks), to smooth out the noise.
5. Chart it. Insert → PivotChart or a line chart to see the trend over time.

Useful analyses to try

• Resting heart rate by month, is your baseline drifting up or down?
• Weekly step average, compare training weeks to rest weeks.
• Sleep duration trend, pair it with HRV to see how rest tracks recovery.
• Weight over time, a clean line instead of the Health app's cramped chart (export weight).

What's free vs Pro

Pro is a one-time $24.99 (US price, varies by region), Family Sharing included, no subscription.

Honest limits

• HealthSave gives you the data, not the spreadsheet. The pivot tables and charts are yours to build, Excel does that part.
• Free export covers recent history; the full multi-year record needs Pro.
• iOS only; it reads Apple Health, so data must already be in HealthKit.
• Accuracy is your wearable's, the CSV shows exactly what your device recorded.

Related

• How to export Apple Health data, the full guide and formats.
• Turn Apple's unusable export.xml into real CSV.
• Export step count and weight for quick trend charts.
• Want SQL instead of spreadsheets? Store it in your own database.

FAQ

Can I open Apple Health data directly in Excel?

Yes, if you export it as CSV first. HealthSave writes clean, per-metric CSV that opens directly in Excel, Numbers, or Google Sheets, no XML parsing required.

Why not just use Apple's Export All Health Data?

Apple's export is one giant export.xml archive that Excel can't meaningfully open. HealthSave skips the XML and gives you tidy CSV per metric, which is what you actually want for analysis.

Can I build pivot tables and charts?

Yes. Because each row is a date, a value, and a unit, you can pivot by week or month for averages and chart any metric as a trend line, the same way you would any time-series dataset.

Does it work in Numbers and Google Sheets?

Yes. CSV is universal, so the same file opens in Apple Numbers and Google Sheets with the same pivot and chart features.

Is exporting to CSV free?

Yes. CSV and JSON export are free in HealthSave. Full multi-year history, PDF reports, and server sync are part of the one-time Pro upgrade.

HealthSave is not a medical device. It is for informational purposes only and does not diagnose, treat, cure, or prevent any disease or condition. The accuracy of any health data depends on your wearable device and its sensors. Privacy claims of zero data collection apply to the iOS app.

Get HealthSave

Download free, export any metric to CSV, and start analyzing your Apple Health data in Excel in minutes.

Download HealthSave on the App Store