Convert LOC to XLSX

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

Geocache waypoints in a spreadsheet.One sheet with a row for each waypoint, with its position as a point and its values in columns.

  1. What you get

    An XLSX workbook with one sheet. The sheet is named after the file, cut to 31 characters. Each feature gets one row.

    The first column is named WKT and holds the shape as WKT. Waypoints become points. Every attribute then gets its own column, and numbers, dates and true and false values are typed cells, not text. A layer column names the layer each feature comes from. Columns that no feature fills are left out.

  2. Coordinates and heights

    Coordinates are written in WGS 84 longitude and latitude. Heights stay in the shapes as Z, and points also carry them in the ele column.

    Times that have a time zone are written in UTC.

  3. 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 so the shape column keeps its name.

    Lists and nested values become JSON text. A shape longer than the 32,767 characters a cell holds leaves its cell empty and raises a warning. A map of more than 1,048,575 features fails, because that is more rows than the sheet holds.

LOC and XLSX.What each format is.

The formats

From · LOC

Geocaching LOC

Geocache waypoints downloaded from Geocaching.com as a .loc file.

Extensions
.loc
MIME type
application/x-geocaching-loc+xml
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 LOC to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.loc report.xlsx
$ cv convert report.loc report.xlsx

Questions.What people ask about LOC to XLSX.

01OF 04

The shape of each feature as WKT. For a waypoint, that is a point.

WGS 84, written as longitude and latitude.

Yes. They stay in the shapes as Z, and points also have them in the ele column.

Yes. A map of more than 1,048,575 features fails. A single shape longer than 32,767 characters leaves its WKT cell empty, with a warning.

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