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:

  1. 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.
  2. In the Tree panel, select ...

Get Mastering QGIS - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial