Skip to main content

Transfer Apple Watch or Apple Health data to Excel or Sheets

Have you ever attempted to get the data from your Apple Watch or Apple Health app into a format you can share with others? 

Maybe you'd like to share this information with a doctor, or maybe you'd simply like to analyze the data yourself in Excel.  There are XML converters out there, but once you get the data from these converters into excel using this technique, the data can look quite ambiguous.


 Luckily, "There is an app for that."  It's called QS Access.  This solution is very quick and easy for exporting your data into a format you can use quickly.


 Unfortunately with this app, you won't be able to export every field from your apple watch, however you will be able to export fields such as:
  • Active Calories
  • Resting Calories
  • Steps
  • Distance
  • Flights Climbed
  • Heart Rate
  • Blood Pressure
  • Calories
  • Weight
  • BMI
  • and more...
So how do you get this app?  Simply go to the app store from your Apple iPhone and search for "QS Access".  Once you download the app, you select the fields that you would like to export and select, "Create Table".  Next, turn all the categories on from your Health app and select "Allow".  The app will then start collecting and exporting your data and placing it into a spreadsheet.  Once it has completed, simply click the share button on the bottom left corner of the app and choose how you'd like to send the data.  

The exported data will be in a .csv format, so you can then choose the application you'd like to view it in. You should be able to open the file in Excel, Google Sheets, notepad, and even from a cellular device.
Labels:

Comments

Post a Comment

Popular posts from this blog

Creating a Dynamic one click PDF button in Tableau

Can I get that in a PDF view?  If you are a report developer, you have most likely heard this question before. In Tableau, you can choose to print any dashboard as a PDF from the toolbar in Tableau Server, but if your dashboard contains a lot of heavy color, you may want to create a separate layout for your printable PDF.  You could send your users to another dashboard with a separate view design, but what if you could do this, and then generate your PDF in one step?  This would allow your users to generate a PDF and separate view in one click. In this exercise, we are going to create a Tableau button that automatically generates a PDF with an updated look specifically for PDF views only on click. First, we need to create a customized Tableau button. This process is very similar to the first article in this series, " Creating a custom Tableau button " except instead of using a Tableau Shape for our button, we will use an image. 1. Navigate to your “My Tableau ...
Post a Comment
Read more

Creating a custom Tableau button

Have you ever wanted to toggle between Tableau dashboards with customized buttons? Tableau Stories allows you to switch between dashboards with ease, but you may wish to add buttons with a more customized look. This tutorial will demonstrate how to build a button from a Tableau shape.   Creating a Tableau button from a Tableau Shape: 1. Create a new worksheet in Tableau.  The button will reside on a worksheet by itself. 2. Create a calculated field. Give the button a title.  Add the text that you'd like the button to contain within quotes.   Button with text example: 3. Drag the new button field to the rows shelf. 4. Right click on the field header (this example's field header is the text that says "page 2 button") and choose "Hide Field Labels for Rows". 5. Now lets add an arrow shape to the button.  To do this, select "shape" from the marks selection. 6. Click the Shape button and select "More Shapes"....
Post a Comment
Read more