Convert OV2 to XLSX

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

One row for each point of interest.Each feature becomes a row in an XLSX sheet, with its shape and attributes in columns.

  1. What you get

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

    Coordinates are written in WGS 84 longitude and latitude. Columns that no feature fills are left out.

  2. What changes on the way

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

    A shape longer than the 32,767 characters a cell holds leaves its cell empty, and a warning is given.

  3. Routes, tracks and limits

    Waypoints become points, routes become lines and tracks become multilines with a part for each segment. Every route and track point also becomes a point of its own, with 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. A layer column names the GPX layer each feature 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.

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

OV2 and XLSX.What each format is.

The formats

From · OV2

TomTom POI

TomTom OV2 files of points of interest, such as speed cameras or favorite places.

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

terminal
$ cv convert report.ov2 report.xlsx
$ cv convert report.ov2 report.xlsx

Questions.What people ask about OV2 to XLSX.

01OF 04

It is named after the file, cut to 31 characters.

Each feature's shape is written as WKT in the first column, named WKT. Coordinates are in WGS 84 longitude and latitude.

They keep their row, and the WKT cell is empty.

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

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