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.
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.
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.
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
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
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.
$ cv convert report.gpkg report.csv$ cv convert report.gpkg report.csvQuestions.What people ask about GPKG to CSV.
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.