TCX to CSV Converter
Convert Training Center XML files to CSV format for spreadsheet analysis
Your Data is Secure
All file conversions happen directly in your browser. We never upload, store, or save your files on any server. Your data remains completely private and secure.
How to Convert TCX to CSV
Follow these simple steps to convert your files quickly and easily
Upload Your TCX File
Click the upload area above or drag and drop your TCX file. Select a .tcx file from your Garmin device, training software, or fitness platform.
Click Convert
Click the convert button to process your TCX file. The converter extracts all trackpoint data and creates a comprehensive CSV file with all metrics.
Download Your CSV File
Once conversion is complete, download your new CSV file. Open it in Excel, Google Sheets, or any data analysis software for detailed workout analysis.
About TCX to CSV Conversion
Learn more about the converter and its creator
Jonas
I'm a software developer and sports enthusiast. I created these converters to help athletes manage their workout data efficiently.
Understanding TCX to CSV Conversion
Converting TCX (Training Center XML) files to CSV (Comma-Separated Values) format allows you to transform your structured workout data into a spreadsheet-friendly format for detailed analysis, visualization, and data processing. This conversion makes your Garmin and other fitness device data accessible in Excel, Google Sheets, and data analysis tools.
What Data is Preserved?
The conversion process extracts and preserves all trackpoint data from your TCX file, including:
- Timestamp information - Exact time for each data point
- GPS coordinates - Latitude and longitude for location tracking
- Elevation data - Altitude measurements in meters
- Distance information - Cumulative distance in meters
- Speed measurements - Instantaneous speed in m/s
- Heart rate data - Heart rate in beats per minute
- Cadence information - Steps or pedal revolutions per minute
- Power output - Power measurements in watts (when available)
- Temperature data - Environmental temperature readings
- Activity metadata - Sport type, activity ID, and lap information
- Elapsed time - Time elapsed from the start of the activity
CSV Format Benefits
Converting TCX to CSV format offers several analytical advantages:
- Universal compatibility with spreadsheet applications (Excel, Google Sheets, LibreOffice)
- Easy data analysis with formulas, pivot tables, and charts
- Simple data visualization and graphing capabilities
- Compatibility with statistical analysis software (R, Python, MATLAB)
- Lightweight text format that's easy to share and process
- Human-readable structure for manual data inspection
- Perfect for custom analysis and research projects
CSV Structure and Columns
The generated CSV file includes the following columns:
- Timestamp - ISO 8601 formatted date/time for each trackpoint
- Activity_ID - Unique identifier for the workout session
- Sport - Type of activity (Running, Cycling, Swimming, etc.)
- Lap_Number - Which lap or interval the trackpoint belongs to
- Latitude - GPS latitude in decimal degrees
- Longitude - GPS longitude in decimal degrees
- Altitude_m - Elevation above sea level in meters
- Distance_m - Cumulative distance traveled in meters
- Speed_ms - Instantaneous speed in meters per second
- Heart_Rate_bpm - Heart rate in beats per minute
- Cadence_rpm - Cadence in revolutions/steps per minute
- Power_watts - Power output in watts (cycling/running)
- Temperature_c - Temperature in degrees Celsius
- Elapsed_Time_s - Seconds elapsed from activity start
Common Use Cases
Converting TCX files to CSV format is particularly useful for:
- Advanced statistical analysis of workout performance
- Creating custom charts and visualizations in Excel
- Research projects involving fitness and exercise data
- Comparing multiple workouts with pivot tables
- Data science projects and machine learning analysis
- Custom performance tracking and trend analysis
- Sharing workout data with coaches or researchers
- Integration with business intelligence tools
Multi-Activity and Lap Support
The converter handles complex TCX files comprehensively:
- Multiple Activities - Processes all activities in a single TCX file
- Lap Information - Preserves lap structure and numbering
- Activity Identification - Each row includes activity and sport type
- Chronological Ordering - Trackpoints sorted by timestamp
- Complete Data - All trackpoints from all laps and activities
Technical Details
The conversion process involves these steps:
- Parsing the TCX XML structure and validating format
- Extracting all activities and their associated laps
- Processing each trackpoint with complete sensor data
- Organizing data chronologically across all activities
- Calculating elapsed time from the first trackpoint
- Formatting data according to CSV standards
- Generating proper headers for easy spreadsheet import
- Ensuring data integrity and completeness
Data Analysis Tips
Once you have your CSV file, consider these analysis approaches:
- Time Series Analysis - Track changes in metrics over time
- Performance Zones - Analyze time spent in different heart rate or power zones
- Pace/Speed Analysis - Calculate average speeds for different segments
- Elevation Profiles - Create charts showing climbs and descents
- Efficiency Metrics - Calculate power-to-weight ratios or pace consistency
- Comparison Studies - Compare multiple workouts or time periods
Pro Tip
The CSV format includes elapsed time calculations, making it easy to create time-based charts and analysis. Use the Timestamp column for absolute time analysis and Elapsed_Time_s for relative workout analysis. The Lap_Number column helps segment your analysis by intervals or workout phases.
Spreadsheet Compatibility
The generated CSV files use standard formatting that works seamlessly with Microsoft Excel, Google Sheets, LibreOffice Calc, and other spreadsheet applications. Data types are automatically recognized, and you can immediately start creating formulas, charts, and pivot tables for analysis.
Data Completeness
The converter extracts all available data from your TCX file. Some columns may be empty if your device didn't record certain metrics (e.g., power data for activities without a power meter). This is normal and allows for flexible analysis across different types of activities and devices.