Convert PLT to XLSX
Turn PLT 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 PLT files on the dialor turn it to pick what to do
A spreadsheet row for every point of your track.Shapes become WKT text, and each attribute gets its own column.
What you get
An Excel workbook with one sheet, named after the file and cut to 31 characters. Each feature is one row. The first column, WKT, holds its shape as text, and every attribute follows as a column.
Numbers, dates and true and false values are typed cells, not text. Columns that no feature fills are left out. Coordinates are written in WGS 84 longitude and latitude.
How the track is laid out
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.
A layer column names where each row 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.
Heights stay in the shapes as Z and in the ele column of points.
Limits and edge cases
A feature without a geometry keeps its row with an empty WKT. If a column is already named WKT, it is renamed WKT_1.
A cell holds at most 32,767 characters. A shape longer than that leaves its cell empty, and a warning is given. Lists and nested values become JSON text, and times with a time zone are written in UTC.
A map of more than 1,048,575 features fails with
resource_limit.
PLT and XLSX.What each format is.
The formats
OziExplorer Track
A track saved by OziExplorer, a mapping program for GPS receivers and paper maps.
- Extensions
- .plt
- MIME type
- application
/x -oziexplorer -plt - 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 PLT to XLSX conversion through the API, for your app or your agent.
$ cv convert report.plt report.xlsx$ cv convert report.plt report.xlsxQuestions.What people ask about PLT to XLSX.
It holds the shape of each feature as WKT text, in WGS 84 longitude and latitude. Features without a geometry have an empty cell.
Yes. Each route and track point also becomes a point of its own, with its time in UTC and values the device logged, such as hr and cad.
Use the layer column. It reads waypoints, routes, tracks, route_points or track_points for each row.
It stops with resource_limit when the map has more than 1,048,575 features.