Convert USR to XLSX

Turn USR 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 USR files on the dialor turn it to pick what to do

Waypoints, routes and trails in one sheet.Each feature from your Lowrance file becomes one row, with its shape as text.

  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, WKT, holds the shape as text, and every attribute follows as its own column.

    Numbers, dates and true and false values are typed cells. Lists and nested values become JSON text, and times with a time zone are written in UTC. Columns that no feature fills are left out.

  2. How features are laid out

    Waypoints become points, routes become lines, and tracks become multilines with a part for each segment. Coordinates are written in WGS 84 longitude and latitude.

    A layer column names where each feature comes from: waypoints, routes, tracks, route_points or track_points. 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. The columns track_fid and route_fid tie each point to its track or route.

    Heights stay in the shapes as Z and in the ele column of points.

  3. 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 shape longer than the 32,767 characters a cell holds leaves its cell empty and gives a warning. A map of more than 1,048,575 features fails with resource_limit.

USR and XLSX.What each format is.

The formats

From · USR

Lowrance USR

Waypoints, routes and trails saved by Lowrance fish finders and chart plotters.

Extensions
.usr
MIME type
application/x-lowrance-usr
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 USR to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.usr report.xlsx
$ cv convert report.usr report.xlsx

Questions.What people ask about USR to XLSX.

01OF 04

In the first column, named WKT, as text. Each row has the shape of one feature.

Read the layer column. It says waypoints, routes, tracks, route_points or track_points for each row.

Yes. Every route and track point becomes its own point with its time in UTC, along with values the device logged, such as hr and cad.

It stops with resource_limit when the map has more than 1,048,575 features.

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