Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
Hello @cfc

Does it possible to extract all data from WOD to excel ?
From DeepSeek R1


Method 1: Export Directly via Apple Health (XML)
  1. Export Health Data:
    • Open the Health app on your iPhone.
    • Go to your profile (top-right corner) → Export Health Data.
    • Confirm and save the ZIP file to your device.
  2. Transfer & Extract the ZIP:
    • Share the ZIP file to a computer (email, cloud storage, or Airdrop).
    • Unzip the file to access the export.xml (contains all health data, including workouts).
  3. Convert XML to CSV:
    • Option A (Automated Tools):
    • Option B (Manual Parsing):
      • Use Excel’s Power Query (Windows: Data → Get Data → From File → XML) to import and transform XML data into tables.
      • Save the filtered workout data as CSV.
Method 2: Use HealthFit App (Simplest)
  1. Install HealthFit:
    • Download HealthFit (iOS, free with premium options).
  2. Export Workouts to CSV:
    • Open HealthFit → Tap Workouts.
    • Select workouts → Tap Share → Choose CSV.
    • Share the CSV to Excel via email, cloud storage, or direct import.
Method 3: Create a Shortcut (No Third-Party Apps)
  1. Set Up Shortcut:
    • Download the Workout CSV Export Shortcut (search for pre-made shortcuts online or create one):
      • Use the Find Health Samples action (filter for Workouts).
      • Format data into CSV using variables (e.g., start date, duration, calories).
      • Save the CSV to Files or share directly to Excel.
  2. Run the Shortcut:
    • Execute it to export workouts as CSV. Open in Excel or Numbers.
Method 4: Use macOS Apps (If Available)
  1. QS Access (Free):
    • Transfer your iPhone Health data to a Mac via encrypted backup.
    • Download QS Access to read the Health database.
    • Export workouts as CSV.
Final Steps in Excel:
  • Open the CSV in Excel.
  • Use Data → Text to Columns if needed.
  • Format dates/times and organize columns.
Choose the method that best fits your technical comfort! For most users, HealthFit (Method 2) offers the simplest workflow.
 
From DeepSeek R1


Method 1: Export Directly via Apple Health (XML)
  1. Export Health Data:
    • Open the Health app on your iPhone.
    • Go to your profile (top-right corner) → Export Health Data.
    • Confirm and save the ZIP file to your device.
  2. Transfer & Extract the ZIP:
    • Share the ZIP file to a computer (email, cloud storage, or Airdrop).
    • Unzip the file to access the export.xml (contains all health data, including workouts).
  3. Convert XML to CSV:
    • Option A (Automated Tools):
    • Option B (Manual Parsing):
      • Use Excel’s Power Query (Windows: Data → Get Data → From File → XML) to import and transform XML data into tables.
      • Save the filtered workout data as CSV.
Method 2: Use HealthFit App (Simplest)
  1. Install HealthFit:
    • Download HealthFit (iOS, free with premium options).
  2. Export Workouts to CSV:
    • Open HealthFit → Tap Workouts.
    • Select workouts → Tap Share → Choose CSV.
    • Share the CSV to Excel via email, cloud storage, or direct import.
Method 3: Create a Shortcut (No Third-Party Apps)
  1. Set Up Shortcut:
    • Download the Workout CSV Export Shortcut (search for pre-made shortcuts online or create one):
      • Use the Find Health Samples action (filter for Workouts).
      • Format data into CSV using variables (e.g., start date, duration, calories).
      • Save the CSV to Files or share directly to Excel.
  2. Run the Shortcut:
    • Execute it to export workouts as CSV. Open in Excel or Numbers.
Method 4: Use macOS Apps (If Available)
  1. QS Access(Free):
    • Transfer your iPhone Health data to a Mac via encrypted backup.
    • Download QS Access to read the Health database.
    • Export workouts as CSV.
Final Steps in Excel:
  • Open the CSV in Excel.
  • Use Data → Text to Columns if needed.
  • Format dates/times and organize columns.
Choose the method that best fits your technical comfort! For most users, HealthFit (Method 2) offers the simplest workflow.
Wooo that’s clearly explained ! I have to try this !
I have already export my data from apple health app, file is big (2Go), and excel doesn’t want to digest it.

Thanks
 
@cfc can we get different Colors for interval in map ?
 

Attachments

  • IMG_6142.jpeg
    IMG_6142.jpeg
    1.4 MB · Views: 6
@cfc can we get different Colors for interval in map ?
For interval schedules the app shows the route in different colours according to the interval types (green for fast, grey for recover etc) but that isn't the case for manual intervals. Maybe I should just alternate the colours somehow. Possibly dark grey and light grey so you can identify them. It won't be high priority though - sorry.

You could reproduce the effect by using a repeating interval schedule with two different types of different colours.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.