Convert GPKG to XLSX

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

A map layer as one row per feature.Each feature becomes a row, with its shape as text and its attributes as columns.

  1. What you get

    An Excel workbook with one sheet, named after the file and cut to 31 characters. Each feature has one row. The first column, named WKT, holds the shape as WKT. Every attribute follows as its own column.

    Numbers, dates and true and false values are typed cells, not text. Features without a geometry keep their row, and the WKT cell is empty.

  2. Coordinates

    Coordinates are written as WGS 84 longitude and latitude. They are converted from the system of the source, such as Korea's EPSG:5186. If the data names no system, the coordinates stay as they are.

  3. What changes

    Lists and nested values become JSON text. Times with a time zone are written in UTC. If a column in the data is already named WKT, it is renamed WKT_1 so the shape column keeps its name.

    A cell holds at most 32,767 characters. A shape longer than that leaves its cell empty, and the conversion gives a warning.

  4. Several layers and big maps

    When the GeoPackage has several layers, they are joined into one sheet. A layer column names where each feature came from.

    A map of more than 1,048,575 features fails with resource_limit.

    For other routes, see every GPKG conversion or every XLSX conversion.

GPKG and XLSX.What each format is.

The formats

From · GPKG

GeoPackage

The OGC GeoPackage, a SQLite database of map layers that QGIS and ArcGIS read and write.

Extensions
.gpkg
MIME type
application/geopackage+sqlite3
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 GPKG to XLSX conversion through the API, for your app or your agent.

terminal
$ cv convert report.gpkg report.xlsx
$ cv convert report.gpkg report.xlsx

Questions.What people ask about GPKG to XLSX.

01OF 04

Yes. Each shape is written as WKT in the first column. A feature without a geometry keeps its row with an empty WKT cell.

WGS 84 longitude and latitude. Coordinates are converted from the source's system. If the data names no system, they are kept as they are.

The layers are joined into one sheet. The layer column says which layer each feature came from.

The map has more than 1,048,575 features, which is more than the workbook can hold.

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