While using QGIS, and having loaded a non spatial table (from a dbf or a Spatialite table), is it possible to add a new row to its table attributes?

Normally in a spatial layer you have to use "add features button", that obviouslly won't work in this case.

My idea was to use Qgis as somekind of frontend to a Spatialite database, with the ability to edit\add features in spatial tables as well in the non-spatial ones.

2 Answers 2


With a DB Manager (unless your spatialite version is 3) you are able to execute any query including INSERT, so yes (plus there is spatialite-gui-plugin, but again spatilite 3 is not supported). But I prefer to use for this spatialite-gui in parralel with QGIS. Changes are synchronised nicely (at least so far for me).


In 1.8 there should be an add button in the attribute table

enter image description here

  • hmm... I don't have it. May be it is in trunk? Aug 29, 2012 at 23:25
  • Yeah maybe it is only in master
    – Nathan W
    Aug 30, 2012 at 0:15
  • This was exactly what I needed. Guess I will have to wait until it become stable. Thanks Aug 30, 2012 at 9:12
  • The button is available in the stable version 1.8.0-3, installed with OSGeo4W. Aug 31, 2012 at 8:20
  • If someone don't want to open the attribute table each time he needs to add a new line, an alternative to this answer was given in this question Mar 27, 2013 at 14:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.