Convert GPKG to CSV

Turn GPKG files into CSV. A CSV with one row for each feature: its shape as WKT in a first column named WKT, then every attribute as a column.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop GPKG files on the dialor turn it to pick what to do

Map features as rows in a CSV.One row per feature, with its shape as text and every attribute as a column.

  1. What you get

    A single CSV with one row for each feature. The first column is named WKT and holds the feature's shape as well-known text. Every attribute follows as its own column.

    A feature without a geometry keeps its row, with an empty WKT.

  2. What changes

    Coordinates are written in WGS 84 longitude and latitude. If the GPKG uses another system, such as Korea's EPSG:5186, the coordinates are converted. If the data names no system, the coordinates are kept as they are.

    A column already named WKT is renamed WKT_1, so it does not clash with the shape column. Lists and nested values become JSON text.

  3. Several layers

    When the GPKG holds more than one layer, they are joined into one CSV. A layer column names the layer each feature came from.

    To go the other way, use CSV to GPKG.

GPKG and CSV.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 · CSV

CSV

Rows of comma-separated values. The plainest way to move a table between programs.

Extensions
.csv
MIME type
text/csv
Kind
Text and data

In your code.The same GPKG to CSV conversion through the API, for your app or your agent.

terminal
$ cv convert report.gpkg report.csv
$ cv convert report.gpkg report.csv

Questions.What people ask about GPKG to CSV.

01OF 04

The first column, named WKT. It holds each feature's shape as well-known text.

Yes, when the source names a system. They are converted to WGS 84 longitude and latitude. If no system is named, they stay as they are.

They keep their row. The WKT column is empty for them.

No. The result is one file. Layers are joined, and the layer column shows where each feature came from.

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