I would like to use the Health app to record my daily blood glucose test results, but there doesn't seem to be any way to generate a report on the results for my doctor or export the data to a CSV or any other type of file. My doctor's practice is not set up yet to receive electronic results, so I still need to give him a hard-copy report. If anyone has figured this out, please let me know.
After struggling with the XML export and getting nowhere, I found a tip to download a free app: QS Access. It lets you build a table with only the data you want and easily exports it to any spreadsheet software. I had my BP and heart rate data in Excel with no messing around in less than a minute. Completely painless.
I Have a similar question for a similar app. It has export capability but the developer did not include all data fields in their export file. Can I get at the data somehow to extract all data without using their export functionality? I've tried contacting the developer to request the fields added but have not had any response at all
I'm confused by all this.
It seems to me neither QS Access nor the standard Apple Health export export all the raw data points.
Both seem to average the data on an hourly basis, rather than recording and maintaining the original data points.
Is there no way of getting access to the original data points.
They are still visible inside the app, so they are still stored somewhere.
I get data like this
<Record type="HKQuantityTypeIdentifierBloodPressureSystolic" source="Health" unit="mmHg" startDate="20150711123800+0100" endDate="20150712123800+0100" min="129" max="129" average="129" recordCount="1"/>
<Record type="HKQuantityTypeIdentifierBloodPressureSystolic" source="Health" unit="mmHg" startDate="20150712123800+0100" endDate="20150713123800+0100" min="134" max="144" average="139" recordCount="2"/>
<Record type="HKQuantityTypeIdentifierBloodPressureSystolic" source="Health" unit="mmHg" startDate="20150713123800+0100" endDate="20150714123800+0100" min="123" max="140" average="130.167" recordCount="6"/>
<Record type="HKQuantityTypeIdentifierBloodPressureSystolic" source="Health" unit="mmHg" startDate="20150714123800+0100" endDate="20150715123800+0100" min="112" max="123" average="120" recordCount="4"/>
<Record type="HKQuantityTypeIdentifierBloodPressureDiastolic" source="Health" unit="mmHg" startDate="20150711123800+0100" endDate="20150712123800+0100" min="77" max="77" average="77" recordCount="1"/>
<Record type="HKQuantityTypeIdentifierBloodPressureDiastolic" source="Health" unit="mmHg" startDate="20150712123800+0100" endDate="20150713123800+0100" min="74" max="79" average="76.5" recordCount="2"/>
<Record type="HKQuantityTypeIdentifierBloodPressureDiastolic" source="Health" unit="mmHg" startDate="20150713123800+0100" endDate="20150714123800+0100" min="65" max="80" average="71.8333" recordCount="6"/>
<Record type="HKQuantityTypeIdentifierBloodPressureDiastolic" source="Health" unit="mmHg" startDate="20150714123800+0100" endDate="20150715123800+0100" min="75" max="83" average="77.5" recordCount="4"/>
which seems to show 6 data points at 12:38 on the same day
Any ideas?
How does Apple calculate steps from the raw data?
I have an excel sheet with two tabs
1.) export.xml (Health App export iPhone Health App > Heath Data > Export ) I also added a few columns for readability. "Start Date" which is derived from apple's "startDate" column.
2.) iPhone (manual input data on my iPhone Health App > Health Data > All > Steps > Show All Data )
I can't make sense of how they calculate the steps per day. I've summed up all data points starting on a given date, but that doesn't work.
JLiljegren, Thanks for the tip. Its a start in the right direction, but the resulting file is in XML format. Now, I need to find a way to open that file in Excel or Apple's Numbers app.
Have you figured out the data layout? I am trying to spreadsheet the steps data and the format is difficult to decipher...
Hi rugburn, Sorry, but no. I have not had time to study the data layout.
I am using a Mac. I have Excel 2011, but it does not have an option to import XML files, like Excel does on Windows. Sigh!
Hi,
I would really like to be able to convert the times in the exported data to something that I can understand.
Please would you let me know how to convert the time values.
Best wishes Ludlowboy
I have similar problem, but I don't see any "box with the outwards arrow (top right)"… Any ideas?
Any chance you could share your script? It sounds useful
Is your script available anywhere? (command line is fine...10 fingers work better than a mouse!)
This seems to bring up the screen. Took a while. There is a lot of data here, and it is taking its time. Thanks.
Superb!
I exported twice using this method from the Health app, and I get a blank document. Argh!
Export Health Data is under the profile now
Exporting Health app data
