Convert GTM to XLSX

Turn GTM 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 GTM files on the dialor turn it to pick what to do

Waypoints, routes and tracks in a spreadsheet.One row for each feature, with its shape as WKT and every attribute in its own column.

  1. 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 text. Every attribute follows as its own column, with numbers, dates and true and false as typed cells.

    Coordinates are written in WGS 84 longitude and latitude. Heights stay in the shapes as Z and in the ele column of points.

  2. How features are laid out

    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. These rows carry the time in UTC and the values the device logged with the point, such as satellites, heart rate as hr and cadence as cad.

    A layer column names where 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. Columns that no feature fills are left out.

  3. Edge cases

    Features without a geometry keep their row with an empty WKT. 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. Lists and nested values become JSON text, and times with a time zone are written in UTC.

    A map of more than 1,048,575 features fails with resource_limit.

GTM and XLSX.What each format is.

The formats

From · GTM

GPS TrackMaker

GPS TrackMaker files of waypoints, routes and tracks from the Windows GPS program popular in Brazil.

Extensions
.gtm
MIME type
application/x-gtm
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 GTM to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.gtm report.xlsx
$ cv convert report.gtm report.xlsx

Questions.What people ask about GTM to XLSX.

01OF 04

It takes the name of the file, cut to 31 characters.

They are in the WKT column as WGS 84 longitude and latitude. Heights stay in the shapes as Z and in the ele column of points.

Yes. Every track point and route point also becomes a point of its own, with its time in UTC and the values the device logged. The track_fid and route_fid columns link each point back to its track or route.

It stops with resource_limit when the map has more than 1,048,575 features.

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