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.

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

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

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

From · NMEA

NMEA Log

Raw sentences from a GPS receiver.

Extensions
.nmea
MIME type
text/x-nmea
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 NMEA to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.nmea report.xlsx
$ cv convert report.nmea report.xlsx

Questions.What people ask about NMEA to XLSX.

01OF 04

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.

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