You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
My wife and I purchased Series 5 watches, primarily for the health reasons. I am extremely disappointed that we can't export the data to an Excel file. We could have gotten a less expensive watch that would do that. Will that change soon?
Windows, Windows 6
If you go to the Health app on the iPhone, tap on your profile button in the upper right corner after opening Health. That page should have your name, medical details, accounts, Privacy, and then below that, Export All Health Data. Tap on that button, and it will prepare and export your health data. Depending on how much information you have, it can take a little while to prepare. Once prepared, you will get a zip file notification for a file called Export, and the share screen, to determine where you want the file. You can email it to yourself, or save it to Files. You are then prompted for the location if you save to files, you should then be able to open it in Excel. If you email it to your computer, you should also have access to it in Excel.
If you go to the Health app on the iPhone, tap on your profile button in the upper right corner after opening Health. That page should have your name, medical details, accounts, Privacy, and then below that, Export All Health Data. Tap on that button, and it will prepare and export your health data. Depending on how much information you have, it can take a little while to prepare. Once prepared, you will get a zip file notification for a file called Export, and the share screen, to determine where you want the file. You can email it to yourself, or save it to Files. You are then prompted for the location if you save to files, you should then be able to open it in Excel. If you email it to your computer, you should also have access to it in Excel.
Thanks, but this is not the answer. Apple support says there is no way to export the data collected in your health app on the watch or the iPhone. Apple will need to come up with an answer I believe.
I have a copy of my health data on my windows laptop that I exported from the phone,it's 263MB in size and the folder structure is apple-health-export/workout routes folder and 2 files export.xml
and export-cda.xml.
I did the conversion, I got several hundred lines and columns as shown below. Is this what you are seeing? Apple support walked me through the export. Is there another way to do the export?
US
2.16.840.1.113883.1.3
US
2.16.840.1.113883.1.3
I must be doing something wrong. There is nothing that I can read usefully. I saved the zip file. I extracted the zip file. I opened the apple health data file. I chose the cda.xml file. When I export the data I get coded data. The xml file will not export.
I testing mine again a little while ago and found I had an issue. For me, I AirDropped it to my MacBook Air. I couldn't email it because of the size of the file, and using Excel in iOS is not the most robust of its uses. I know that I have a great deal of Health data on my iPhone, so it creates a large file. Depending on the type of program you are trying to use to open the XML file can also have an affect on the result. I did a Google search, and found something that talked about the type of profile used when creating the XML file. I couldn't get the XML file to open on my Mac, so I've looked for another way. I did it before when Apple first set it to be able to download Health data and it worked fine. I'm trying to determine what they changed, and haven't gotten a result yet. I'll keep searching, but you may also wish to search for Health data on iPhone and how to export, and also opening an XML file in whatever computer OS you use.
I have found the "QS" free app mentioned in several locations. I will try that later today or tonight.
You might want to try this one,just tried it and it's excellent;
https://apps.apple.com/us/app/health-csv-export-tool/id1115567069
This might help;
Thanks, and forgive me for being so hasty in my response and not trying your suggestion.
Thanks, I will do those searches. I am using a PC Windows 10, MS Office Excel. Hopefully you can figure this out.
Thank you. I did add the app. I am surprised that you can only move one category at the time. I also get no data when I try to export my walks/runs/workouts. I will keep trying.
Series 5 watch
