Downloading Activities to CSV header data change

I download my activities (all road cycling) to a CSV, then import to a Excel file that I do analysis one.  I simply copy and insert the new data into the Excel file.

It worked fine up until Tuesday 11/3/24.  It appears the data is now exported with some new columns.  Also, some of the old columns have moved.  This has made the simple copy and insert not work. The issue starts after the Max Power column.

Is anyone aware of this change?  Before I reformat my old Excel file to match the new download I am hoping for a better answer.

Old Format:

Activity Type Date Favorite Title Distance Calories Time Avg HR Max HR Aerobic TE Avg Speed Max Speed Total Ascent Total Descent Avg Bike Cadence Max Bike Cadence Normalized Power® (NP®) L/R Balance Training Stress Score® Max Avg Power (20 min) Avg Power Max Power Grit Flow Total Strokes Avg. Swolf Avg Stroke Rate Total Reps Dive Time Min Temp Surface Interval Decompression Best Lap Time Number of Laps Max Temp Avg Resp Min Resp Max Resp Moving Time Elapsed Time Min Elevation Max Elevation

New Format:

Activity Type

Date Favorite Title Distance Calories Time Avg HR Max HR Aerobic TE Avg Speed Max Speed Total Ascent Total Descent Avg Bike Cadence Max Bike Cadence Normalized Power® (NP®) L/R Balance Training Stress Score® Max Avg Power (20 min) Avg Power Max Power Total Strokes Min Temp Decompression Best Lap Time Number of Laps Max Temp Avg Resp Min Resp Max Resp Moving Time Elapsed Time Min Elevation Max Elevation
  • OK, I have confirmed the new field layout comes across regardless of how I filter the data on Garmin Connect (no filter, cycling, cycling/road).

    None of my equipment has changed.  I will either re-export 18 years of data or re-arrange old columns to match new

  • I have confirmed the new field layout comes across regardless of how I filter the data on Garmin Connect (no filter, cycling, cycling/road).

    It is in fact not directly the activity type that determines the header. It is rather the resulting set of activities, that determines it. So if the Cycling and Road Cycling exports the same activities, then the header will be identical.

    Instead of changing the activity type filter, use the filtering by date, and try exporting only older activities. I would bet that you then get the old layout (since the old activities do not contain the new metrics).