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.
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.
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.
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
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
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.
$ cv convert report.gpi report.xlsx$ cv convert report.gpi report.xlsxQuestions.What people ask about GPI to XLSX.
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.