Convert NMEA to XLSX
Turn NMEA 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 NMEA files on the dialor turn it to pick what to do
A sheet with one row per feature.The shape goes in the first column as WKT. Times, heights and satellite counts follow.
What you get
A workbook with one sheet, named after the file and cut to 31 characters. Each feature is one row. The first column is called WKT and holds the shape as WKT. Every attribute then gets its own column.
Fixes from the log become one track. Its rows carry the times, heights, satellite counts and dilution values. Numbers, dates and true and false values are written as typed cells. Coordinates are in WGS 84 longitude and latitude. Heights stay in the shapes as Z.
What is dropped or changed
Speed and course are dropped. Sentences with a wrong checksum are skipped, so they add nothing to the track.
Lists and nested values become JSON text. Times with a time zone are written in UTC. Columns that no feature fills are left out.
Edge cases in the cells
A feature without a geometry keeps its row, and its WKT cell is empty. If the data already has a column named WKT, it is renamed WKT_1 so the shape column keeps the name.
A cell holds at most 32,767 characters. If a shape is longer than that, its cell is left empty and a warning is given. A map of more than 1,048,575 features fails.
NMEA and XLSX.What each format is.
The formats
NMEA Log
Raw sentences from a GPS receiver.
- Extensions
- .nmea
- MIME type
- text
/x -nmea - 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 NMEA to XLSX conversion through the API, for your app or your agent.
$ cv convert report.nmea report.xlsx$ cv convert report.nmea report.xlsxQuestions.What people ask about NMEA to XLSX.
No. Both are dropped. The times, heights, satellite counts and dilution values are kept.
They are skipped. Only sentences with a correct checksum are used.
WGS 84, written as longitude and latitude. The WKT column holds the shapes in those coordinates.
Heights stay in the shapes as Z. Point rows also carry them in the ele column.