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...