Convert ITN to XLSX

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

One row for each feature, ready for Excel.Each feature becomes a row, with its shape as WKT text and its attributes as columns.

  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, named WKT, holds the shape as WKT, and every attribute follows as its own column.

    Numbers, dates and true and false values are typed cells. Columns that no feature fills are left out.

  2. Shapes and points

    Coordinates are written in WGS 84 longitude and latitude. Waypoints become points, routes become lines and tracks become multilines with a part for each segment. Heights stay in the shapes as Z and in the ele column of points.

    Every route 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 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.

  3. What changes

    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. Lists and nested values become JSON text. Times with a time zone are written in UTC.

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

ITN and XLSX.What each format is.

The formats

From · ITN

TomTom Itinerary

TomTom itineraries, the planned stops a TomTom navigator drives through in order.

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

terminal
$ cv convert report.itn report.xlsx
$ cv convert report.itn report.xlsx

Questions.What people ask about ITN to XLSX.

01OF 04

It holds the shape of each feature as WKT text, in WGS 84 longitude and latitude. Features without a geometry have an empty cell.

Use the layer column. It says whether a row is from waypoints, routes, tracks, route_points or track_points.

Yes. The track_fid column ties each track point to its track, and route_fid does the same for route points.

Either the feature has no geometry, or its shape is longer than the 32,767 characters a cell holds. In the second case a warning is given.

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