Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
up vote 2 down vote accepted

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

enter image description here

share|improve this answer
hmm... I don't have it. May be it is in trunk? – SS_Rebelious Aug 29 '12 at 23:25
Yeah maybe it is only in master – Nathan W Aug 30 '12 at 0:15
This was exactly what I needed. Guess I will have to wait until it become stable. Thanks – Alexandre Neto Aug 30 '12 at 9:12
The button is available in the stable version 1.8.0-3, installed with OSGeo4W. – Alexandre Neto Aug 31 '12 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 – Alexandre Neto Mar 27 '13 at 14:51

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

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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