Convert FIT to XLSX
Turn FIT 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 FIT files on the dialor turn it to pick what to do
Your FIT activity as rows in an Excel sheet.One sheet with a row for each feature, its shape as WKT text, and every attribute in its own column.
What you get
A workbook with one sheet, named after the file and cut to 31 characters. Each feature gets one row. The first column is named WKT and holds the shape as WKT. Every attribute then becomes a column, with numbers, dates and true and false written as typed cells.
Columns that no feature fills are left out.
Waypoints, routes and tracks
Waypoints become points, routes become lines, and tracks become multilines with a part for each segment. Every route point and track point also becomes a point of its own. It carries its time in UTC and the values the device logged with it, such as satellites, heart rate as hr and cadence as cad.
A layer column names the GPX layer each feature comes from: waypoints, routes, tracks, route_points or track_points. The track_fid and route_fid columns tie each point to its track or route.
What changes along the way
Coordinates are written in WGS 84 longitude and latitude. Heights stay in the shapes as Z and in the ele column of points. Times that carry a time zone are written in UTC. Lists and nested values become JSON text.
A feature without a geometry keeps its row, with an empty WKT cell. If a column is already named WKT, it is renamed WKT_1. A shape longer than the 32,767 characters a cell holds leaves its cell empty, and a warning is given. A map of more than 1,048,575 features fails.
FIT and XLSX.What each format is.
The formats
Garmin FIT
The binary activity format of Garmin and most fitness watches.
- Extensions
- .fit
- MIME type
- application
/vnd .ant .fit - Kind
- Text and data
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 FIT to XLSX conversion through the API, for your app or your agent.
$ cv convert report.fit report.xlsx$ cv convert report.fit report.xlsxQuestions.What people ask about FIT to XLSX.
WGS 84, written as longitude and latitude. Heights stay in the shapes as Z and in the ele column of points.
Yes. Each route and track point becomes a point of its own, and the values the device logged with it, such as hr and cad, become columns.
If a shape is longer than the 32,767 characters a cell holds, its cell is left empty and a warning is given. The rest of the row stays.
Up to 1,048,575 features. A map with more than that fails.