Exporting tables out of SpatiaLite
You can export tables from SpatiaLite to many different formats using DB Manager. Tables can be exported to the following commonly-used formats, as well as many other formats:
- ESRI Shapefile (
.shp) - dBase (
.dbf) - Text (
.txt), Commas Separate Values (.csv), and Excel spreadsheets (.xls/.xlsx) - AutoCAD DXF (
.dxf) - Geography Markup Language (
.gml) - Keyhole Markup Language (
.kml) - Geometry JavaScript Object Notation (
.geojson) - GeoRSS (
.xml)
To demonstrate an export, export the Waterfalls table to the shapefile format by performing the following steps:
- Open DB Manager by clicking on DB Manager under Database. Expand SpatiaLite and select the database from which you wish to export a table in the Tree panel.
- In the Tree panel, select the table that you wish to export.
- Navigate to Table | Export to file to open the Export to vector file dialog.
- In the Format dropdown box, choose ESRI Shapefile.
- Click on the ellipsis button at the right-hand side of the Output file text box and name...
