Stanley Horwitz

Q: Exporting Health app data

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.

Posted on Oct 6, 2014 9:51 AM

Close

Q: Exporting Health app data

  • All replies
  • Helpful answers

Previous Page 2
  • by JasperHa,

    JasperHa JasperHa Mar 29, 2015 3:41 PM in response to Sigmund Lundgren
    Level 1 (0 points)
    Mar 29, 2015 3:41 PM in response to Sigmund Lundgren

    Any chance you could share your script? It sounds useful

  • by mishka_53,

    mishka_53 mishka_53 May 31, 2015 3:50 AM in response to Stanley Horwitz
    Level 1 (0 points)
    May 31, 2015 3:50 AM in response to Stanley Horwitz

    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.

  • by CliveAH,Helpful

    CliveAH CliveAH Jun 6, 2015 8:54 PM in response to M UND M
    Level 1 (5 points)
    Jun 6, 2015 8:54 PM in response to M UND M

    The most straight forward export is achieved  by using the app called QS Access available from the App Store. There may be some downsides, but at least the exported file is .csv so can be manipulated withpout a lot of fancy footwork

  • by Stanley Horwitz,

    Stanley Horwitz Stanley Horwitz Jun 10, 2015 8:47 PM in response to CliveAH
    Level 4 (2,706 points)
    Jun 10, 2015 8:47 PM in response to CliveAH

    The QS Access app is exactly what I was looking for! Thanks!

  • by kaderjazairi,

    kaderjazairi kaderjazairi Jun 13, 2015 10:28 AM in response to CliveAH
    Level 1 (0 points)
    Jun 13, 2015 10:28 AM in response to CliveAH

    QS access may work for some reports, but I found in Blood Glucose report, it changes the value to mg/ dL from  mmol/L, and if you choose 1 Hour tab then you get the report for every hour even if you don't have any data points, and if you choose 1 day tab then the time is always 00:00.

    I really don't understand why the Health app wasn't set up to be more user friendly and compatible with other software like numbers and excel...

  • by sneufeld,

    sneufeld sneufeld Jul 9, 2015 10:55 AM in response to Sigmund Lundgren
    Level 1 (0 points)
    Jul 9, 2015 10:55 AM in response to Sigmund Lundgren

    Here's a stab at the beginnings of an online solution for reporting in more detail the data in the Apple Health export file. Only has a few charts for heart rate analysis, but it includes a histogram, which is pretty useful. The data is not uploaded anywhere, it never leaves the user's browser.

     

    http://nterspace.com/health/

  • by KaneSF,

    KaneSF KaneSF Jul 15, 2015 3:25 PM in response to Sigmund Lundgren
    Level 1 (0 points)
    Jul 15, 2015 3:25 PM in response to Sigmund Lundgren

    Is your script available anywhere?  (command line is fine...10 fingers work better than a mouse!)

  • by Gregory Speck,

    Gregory Speck Gregory Speck Aug 26, 2015 8:43 AM in response to rainev
    Level 1 (20 points)
    Aug 26, 2015 8:43 AM in response to rainev

    This seems to bring up the screen. Took a while. There is a lot of data here, and it is taking its time. Thanks.

  • by chyrva,

    chyrva chyrva Sep 21, 2015 12:54 AM in response to mishka_53
    Level 1 (0 points)
    Sep 21, 2015 12:54 AM in response to mishka_53

    Superb!

  • by Crispgmail,

    Crispgmail Crispgmail Oct 7, 2015 5:46 AM in response to Stanley Horwitz
    Level 1 (0 points)
    Oct 7, 2015 5:46 AM in response to Stanley Horwitz

    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?

  • by spencerdcarlson,

    spencerdcarlson spencerdcarlson Nov 14, 2015 1:07 PM in response to Stanley Horwitz
    Level 1 (0 points)
    Nov 14, 2015 1:07 PM in response to Stanley Horwitz

    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.

     

    https://docs.google.com/spreadsheets/d/11eEEovrxIeturBELR7tBSVCdaBQXo6LgFJbAC-AR hIo/edit?usp=sharing

  • by _oreon,

    _oreon _oreon Nov 15, 2015 4:22 AM in response to Stanley Horwitz
    Level 1 (0 points)
    Nov 15, 2015 4:22 AM in response to Stanley Horwitz

    I created a web-app to convert the XML export from the Apple Health app to a much more portable and easier to use CSV format.

     

    http://ericwolter.com/projects/health-export.html

     

    All work is done locally by the browser. Nothing is ever uploaded to my server. I am not able to see any of your data.

  • by minan,

    minan minan Dec 22, 2015 12:38 PM in response to rainev
    Level 1 (0 points)
    Dec 22, 2015 12:38 PM in response to rainev

    I exported twice using this method from the Health app, and I get a blank document. Argh!

  • by Texacali27,

    Texacali27 Texacali27 Apr 11, 2016 2:50 PM in response to Stanley Horwitz
    Level 1 (4 points)
    Apr 11, 2016 2:50 PM in response to Stanley Horwitz

    There's an easier workaround than downloading the app.

     

    What really bugs me about the Health app is that it doesn't give you a grand total for a given time period (at least, I can't figure it out). When I click on my "year summary" of miles, I would like to see the TOTAL of my miles for the year. Not just my miles TODAY.

     

    To get a sum of all the miles I have walked/run since the beginning of the year, I did this:

     

    1. Export data to email by going to Health Data -> All --> Click on Share in upper right hand corner.

    2. Download from email and open with Excel. When Excel gives an errors, say to open as TEXT.

    3. I deleted any rows that were not related to Walk/Running.

    4. Highlight the column that has this LONG string of text data that looks like this: "ning" sourceName="Name’s iPhone" sourceVersion="9.0.2" device="&lt;&lt;HKDevice: 0x12db4fe80&gt;, name:iPhone, manufacturer:Apple, model:iPhone, hardware:iPhone6,1, software:9.0.2&gt;" unit="mi" creationDate="2015-10-26 13:26:47 -0600" startDate="2015-10-26 12:43:40 -0600" endDate="2015-10-26 12:47:38 -0600" value="0.0362545"/>

    5. Click on the "Data" tab and then click "Text to Column".

    6. Selected "Delimited".

    7. Then, under Delimiters, select "other" and put a quotation mark in the "other" field. (") And then click on Finish. What I found was that the mileage values I wanted were at the very end of this LONG string of text, but that there were quotation marks around these values. So, by delimiting the text by quotation marks, it will separate those values into their own column.

    8. Sum the values to get your grand total.

     

    So, YES you can use Excel to open the exported data.

    And, YES you can easily split out all that text by using the "Text to Columns" tool.

     

    (I'm using Excel 2011 for Mac)

     

    DISCLAIMER:

    I wrote all this really fast. I am by no means an Excel expert or an iPhone Health app expert. I'm just trying to help.  I won't be able to answer any questions...

  • by Jpon,

    Jpon Jpon Apr 12, 2016 2:58 AM in response to Stanley Horwitz
    Level 1 (31 points)
    iPhone
    Apr 12, 2016 2:58 AM in response to Stanley Horwitz

    Why not use this app: https://mysugr.com/apps/ 

     

    Available in the app store

     

    Export is no problem. I am using it

Previous Page 2