I'm with you for the first part - I learned how to do the export, then got it onto my computer. My folder in my downloads folder is named "apple_health_export and it contains four files:
electrocardiograms - which I think is all the ECG measurements I've taken,
workout-routes - which apparently is the "routes" I have used for my walks,
then "export_cda.xml ...and
then "export.xmo
So, I opened my copy of Microsoft Excel, and got:
"
File cannot be opened because:
Line 2, Position 11.
<!DOCTYPE HealthData [
"
That's as far as I got.
Maybe I need a newer version of Excel?
To say I'm lost would be an understatement, but at least I've gotten this far.
The people at Apple Support, when I call, are more lost than me - they don't even know/understand what I've already done, and they tell me to just give the files to my doctor - but his staff knows nothing about any of this. Why should they?
When I try to open the other file "export_cda.xml" the colored "soccer ball" shows up, and the program freezes. This is the error message after using "force quit":
Date/Time: 2023-02-12 11:07:50.380 -0500
End time: 2023-02-12 11:09:07.565 -0500
OS Version: macOS 13.2 (Build 22D49)
Architecture: x86_64h
Report Version: 40
Incident Identifier: 266128F8-D177-4C9B-86EC-865A87124128
Share With Devs: Yes
Data Source: Stackshots
Shared Cache: 61138B36-7859-3ADD-9C47-7E7CD2A358D0 slid base address 0x7ff818a2e000, slide 0x18a2e000 (System Primary)
Shared Cache: E857F813-9944-3302-8FA9-09A43BB2883C slid base address 0x7ff8117f6000, slide 0x117f6000 (DriverKit)
Command: Microsoft Excel
Path: /Applications/Microsoft Excel.app/Contents/MacOS/Microsoft Excel
Identifier: com.microsoft.Excel
Version: 16.16.27 (16.16.20101200)
Team ID: UBF8T346G9
Is First Party: No
Architecture: x86_64
Parent: launchd [1]
PID: 15215
Time Since Fork: 155176s
Event: hang
Duration: 77.19s
Duration Sampled: 3.50s (process was unresponsive for 74 seconds before sampling)
Steps: 35 (100ms sampling interval)
Hardware model: Macmini8,1
Active cpus: 12
HW page size: 4096
VM page size: 4096
Time Since Boot: 322646s
Time Awake Since Boot: 322646s
Time Since Wake: n/a (machine hasn't slept)
Fan speed: 2448 rpm -> 2215 (-233)
Total CPU Time: 7.254s (29.6G cycles, 18.1G instructions, 1.63c/i)
Advisory levels: Battery -> 3, User -> 2, ThermalPressure -> 1, Combined -> 2
Free disk space: 244.15 GB/931.55 GB, low space threshold 3072 MB
Vnodes Available: 69.98% (184154/263168)
Preferred User Language: en-US
Country Code: US
Keyboards: U.S.
OS Cryptex File Extents: 470
--------------------------------------------------
Timeline format: stacks are sorted chronologically
Use -i and -heavy to re-report with count sorting
--------------------------------------------------