Convert TCX to XLSX

Turn TCX files into XLSX. A workbook with one sheet named after the file, cut to 31 characters, and one row for each feature: its shape as WKT in a first column named WKT, then every attribute as a column, with numbers, dates and true and false as typed cells.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop TCX files on the dialor turn it to pick what to do

Your activity as rows in an Excel sheet.Each track, lap start and point gets a row, with its shape as text and its heart rate in a column.

  1. What you get

    An XLSX workbook with one sheet, named after the file and cut to 31 characters. Each feature is one row. The first column is called WKT and holds the shape as text. Every attribute follows as its own column, with numbers, dates and true and false as typed cells.

    A layer column names where each row comes from: waypoints, routes, tracks, route_points or track_points. The columns track_fid and route_fid tie each point to its track or route. Columns that no feature fills are left out.

  2. What the rows hold

    Each activity becomes a track named after its start time, and each course becomes a track under its own name. Tracks carry times, heights, heart rate and cadence. Lap starts and course points become waypoints.

    Every route and track point also becomes a point of its own. It has its time in UTC and the values the device logged with it, such as satellites, heart rate as hr and cadence as cad. Heights stay in the shapes as Z and in the ele column of points.

    Waypoints become points, routes become lines, and tracks become multilines with a part for each segment. Coordinates are written in WGS 84 longitude and latitude.

  3. What changes or is dropped

    Speed, calories, notes and device details are dropped. Lists and nested values become JSON text. Times with a time zone are written in UTC.

    A feature without a geometry keeps its row with an empty WKT. If the data already has a column named WKT, it is renamed WKT_1.

  4. Limits of a cell and a sheet

    A cell holds 32,767 characters. If a shape is longer, its cell is left empty and a warning is given. A map of more than 1,048,575 features fails, because that is more rows than the sheet holds.

TCX and XLSX.What each format is.

The formats

From · TCX

TCX

Garmin training logs with laps, heart rate and GPS.

Extensions
.tcx
MIME type
application/vnd.garmin.tcx+xml
Kind
Text and data
To · XLSX

Excel Workbook

Excel's workbook format since 2007. Sheets, formulas, formats and charts in zipped XML.

Extensions
.xlsx
MIME type
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Kind
Documents

In your code.The same TCX to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.tcx report.xlsx
$ cv convert report.tcx report.xlsx

Questions.What people ask about TCX to XLSX.

01OF 04

No. The output is one file with one sheet, named after the file and cut to 31 characters. Each feature is a row, and the layer column tells you which kind it is.

Each track point becomes a point of its own, with its time in UTC and the values the device logged. Heart rate is in the hr column and cadence in the cad column.

No. Speed, calories, notes and device details are dropped.

WGS 84 longitude and latitude. The WKT column holds the shapes, and heights stay in them as Z.

More conversions.Other ways in and out of TCX and XLSX.