Convert WPT to XLSX
Turn WPT 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 WPT files on the dialor turn it to pick what to do
Waypoints in a spreadsheet, one row each.Each feature becomes a row, with its shape as WKT and its attributes as columns.
What you get
One XLSX workbook with one sheet. The sheet is named after the file, cut to 31 characters. Each feature has one row.
The first column is named WKT and holds the shape as text. Every attribute follows as its own column. Numbers, dates and true and false values are typed cells, not text.
Coordinates are written as WGS 84 longitude and latitude. Heights stay in the shapes as Z and in the ele column of points.
How features are mapped
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. 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. Columns that no feature fills are left out.
Edge cases
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, with 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 fails with
resource_limit.
WPT and XLSX.What each format is.
The formats
OziExplorer Waypoints
Waypoints saved by OziExplorer, a mapping program for GPS receivers and paper maps.
- Extensions
- .wpt
- MIME type
- application
/x -oziexplorer -wpt - 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 WPT to XLSX conversion through the API, for your app or your agent.
$ cv convert report.wpt report.xlsx$ cv convert report.wpt report.xlsxQuestions.What people ask about WPT to XLSX.
It is named after the file, cut to 31 characters.
Yes. Routes become lines and tracks become multilines with a part for each segment. Their points also get rows of their own.
Yes, when the device logged them. They appear as the hr and cad columns on the route and track points.
The map has more than 1,048,575 features, which is more than one sheet can hold.