How to Analyze Garmin FIT Data in Excel: Complete Tutorial

How do you analyze Garmin FIT data in Excel? First, convert your FIT file to CSV using our FIT to CSV Converter, then open the CSV in Excel to access all your workout metrics in a spreadsheet format ready for analysis.

This guide walks you through the complete process—from conversion to creating professional charts and calculating key training metrics.

Why Analyze FIT Data in Excel?

While Garmin Connect provides basic analytics, Excel gives you:

• Custom calculations: Create formulas specific to your training needs
• Advanced charts: Build visualizations Garmin doesn't offer
• Data comparison: Analyze multiple workouts side by side
• Export flexibility: Share analysis in any format
• Historical trends: Track progress over months or years

Step 1: Convert Your FIT File to CSV

Before you can analyze in Excel, convert your FIT file:

1. Go to our FIT to CSV Converter
2. Upload your .fit file from Garmin Connect or your device
3. Click "Convert" and download the CSV

For detailed conversion instructions, see: How to Convert FIT to CSV.

Just need to open your FIT file in Excel? If you only want the quick conversion workflow (no analysis), see How to Convert FIT to Excel.

Step 2: Import CSV into Excel

In Microsoft Excel:

1. Open Excel
2. Go to File → Open
3. Select your CSV file
4. Data will auto-populate in columns

In Google Sheets:

1. Go to sheets.google.com
2. File → Import → Upload
3. Select your CSV file
4. Choose "Replace spreadsheet" or "Insert new sheet"

Understanding the Columns

Your CSV will contain columns like:

Step 3: Basic Data Cleanup

Convert Timestamps

Excel may not recognize ISO timestamps. To convert:

1. Select the timestamp column
2. Go to Format → Cells → Custom
3. Enter format: yyyy-mm-dd hh:mm:ss

Handle Empty Cells

Some cells may be empty (e.g., power without a power meter):

1. Select all data
2. Find & Replace (Ctrl+H)
3. Find: leave empty, Replace with: 0 or leave as-is

Create Elapsed Time Column

Add a column for elapsed time from start:

=A2-$A$2

Format as [h]:mm:ss for durations over an hour.

Step 4: Calculate Key Metrics

Average Heart Rate

=AVERAGE(E2:E1000)

Where column E contains heart rate data.

Maximum Heart Rate

=MAX(E2:E1000)

Average Power (Cycling)

=AVERAGE(F2:F1000)

Normalized Power (Cycling)

Normalized Power weights efforts more heavily. Approximate formula:

=AVERAGE(F2:F1000)^0.25*AVERAGE(POWER(F2:F1000,4))^0.75

For accurate NP, use 30-second rolling averages—more complex in Excel.

Average Pace (Running)

If speed is in m/s, convert to min/km:

=1000/(G2*60)

Total Distance

=MAX(I2:I1000)/1000

Converts meters to kilometers.

Total Elevation Gain

More complex—requires comparing consecutive altitude values:

=SUMPRODUCT(MAX(D3:D1000-D2:D999,0))

Step 5: Create Visualizations

Heart Rate Over Time Chart

1. Select timestamp and heart_rate columns
2. Go to Insert → Charts → Line Chart
3. Add title: "Heart Rate During Workout"
4. Label axes: Time (X), BPM (Y)

Power Distribution Histogram

1. Create bins: 0-100W, 100-200W, 200-300W, etc.
2. Use COUNTIFS to count records in each bin
3. Create a bar chart from the counts

Pace/Speed Chart

1. Select timestamp and speed columns
2. Create a line chart
3. Invert Y-axis for pace (slower = higher number)

Heart Rate Zones Analysis

Create zone boundaries based on your max HR:

Use COUNTIFS to calculate time in each zone:

=COUNTIFS(E:E,">=120",E:E,"<140")*Recording_Interval

Step 6: Advanced Analysis

Calculate Training Stress Score (TSS)

For cycling with power data:

TSS = (Duration × NP × IF) / (FTP × 3600) × 100

Where:

• Duration = workout time in seconds
• NP = Normalized Power
• IF = Intensity Factor (NP/FTP)
• FTP = Your Functional Threshold Power

Compare Multiple Workouts

1. Import multiple CSV files into separate sheets
2. Create a summary sheet with key metrics from each
3. Use charts to visualize progress over time

Rolling Averages

For smoother data visualization, create 30-second rolling averages:

=AVERAGE(OFFSET(E2,-14,0,30,1))

This averages 30 rows (30 seconds if recording at 1Hz).

Practical Examples

Example 1: Analyzing a Running Workout

Goal: Find your average pace for the middle 80% of the run (excluding warmup/cooldown).

1. Calculate total records: =COUNTA(A:A)-1
2. Find 10% and 90% row numbers
3. Use AVERAGE on that range for speed
4. Convert to pace: =16.67/avg_speed for min/km

Example 2: Power Zone Distribution

Goal: See how much time you spent in each power zone.

1. Define zone boundaries (e.g., based on FTP)
2. Create formulas counting records in each zone
3. Multiply by recording interval for time
4. Create a pie chart showing distribution

Example 3: Heart Rate Drift Analysis

Goal: Check if heart rate drifted upward during a steady-effort run.

1. Split data into first half and second half
2. Calculate average HR for each half
3. Cardiac drift % = (HR2-HR1)/HR1 × 100
4. Drift over 5% may indicate dehydration or fatigue

Tips for Better Analysis

Data Quality

• Use 1-second recording for detailed analysis
• Smart recording may miss short efforts
• Check for data gaps from lost sensor connections

Comparing Workouts

• Normalize for duration when comparing
• Account for environmental factors (heat, altitude)
• Use rate metrics (per minute, per km) rather than totals

Visualization Best Practices

• Use consistent scales when comparing charts
• Add trendlines to spot patterns
• Color-code zones for quick identification

Tools Beyond Excel

For more advanced analysis, consider:

• Golden Cheetah: Free, powerful training analysis software
• WKO5: Professional cycling analysis (paid)
• TrainingPeaks: Online training platform with analytics
• Python/R: For custom statistical analysis

But for most athletes, Excel provides everything you need.

Related Resources

• FIT to CSV Converter - Convert your files for analysis
• How to Convert FIT to Excel - Quick conversion-only workflow
• How to Convert FIT to CSV - Complete conversion guide
• FIT vs CSV vs TCX: Format Comparison - Choose the right format
• Complete Guide to Garmin FIT Files - Understanding FIT data

Start Analyzing

Ready to dive into your training data? Start by converting your FIT files with our free FIT to CSV Converter, then follow this guide to uncover insights from your workouts.

Understanding your data is the first step to training smarter and achieving your fitness goals.