Convert GPI to XLSX

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

Garmin POIs as rows in an Excel sheet.Each feature becomes a row, with its shape as WKT and every attribute as a column.

  1. What you get

    One workbook with one sheet. The sheet is named after the file and cut to 31 characters. Each feature gets one row. The first column, named WKT, holds its shape, and every attribute follows as a column of its own.

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

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

  2. Points, routes and tracks

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

    The 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.

  3. 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.

    A shape longer than the 32,767 characters a cell holds leaves its cell empty, and the conversion gives a warning. 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 does not convert.

GPI and XLSX.What each format is.

The formats

From · GPI

Garmin POI

Points of interest that Garmin car and handheld navigators load as custom POI files.

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

terminal
$ cv convert report.gpi report.xlsx
$ cv convert report.gpi report.xlsx

Questions.What people ask about GPI to XLSX.

01OF 04

In the first column, named WKT, as text. Features without a geometry keep their row with that cell empty.

Use the layer column. It says whether a row comes from waypoints, routes, tracks, route_points or track_points. The track_fid and route_fid columns link each point to its track or route.

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

Yes. A map of more than 1,048,575 features fails. Smaller maps get one row per feature.

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