9

I imported the coordinates from an Excel table. They show as single points as intended. Now I want to add columns to the attribute table, but I'm not able to edit it. I wanted to import the following columns from Excel as well, but that doesn't seem to work either.

Sorry for the noob-question, but I couldn't find anything relating the theme through google and such.

Ok, with pictures then: I want to use that to add columns with information to these

enter image description here enter image description here

You see, the small pensil thingy is greyed out, so I can't edit anything in this layer and I can't add any information to my points.

If I try Ale suggestion I get this error:

enter image description here

3
  • If I understand well you do not need to export coordinates from QGIS to excel, you con view point coordinates using the field calculator
    – Ale
    Commented Nov 4, 2013 at 14:49
  • Have you tried to save your layer in a new one and try to edit the second one?
    – Ale
    Commented Nov 4, 2013 at 16:15
  • Not entirely sure what your problem is, but if you imported your data using add delimited text as layer then it may be related to settings for your import. From what I can remember you might need to have the_geom column in your table in order to enable editing. In any case you might want to try looking at a plugin called quickmultiattributeedit Commented Nov 4, 2013 at 16:26

2 Answers 2

18

By default CSV layers cannot be edited. You have to save to a different format, e.g. Shapefile, before you can start editing.

Update 2015-11:

There's a new plugin that solves this issue called Editable GeoCSV. It can handle x and y columns for points or a WKT column. For more details see http://giswiki.hsr.ch/Editable_GeoCSV_QGIS_Plugin

3
  • 1
    Wow, I think that nailed it. Save the layer as ArcGIS Shape. Then delete old Shape. Then reopen as new vektorlayer. Seems to have worked. Full acces to edit mode with the attributes. :) Thanks, guys!
    – user23609
    Commented Nov 4, 2013 at 19:13
  • Still has the bug, edits made from the "Identify Tool" dialog don't work. Instead, open the Attribute Table and edit in there. See github.com/geometalab/Editable-GeoCSV-QGIS-Plugin/issues/2 Using QGIS version 2.14.2-Essen
    – BillW
    Commented May 13, 2016 at 0:05
  • such a shame it is not working for QGIS 3.xx
    – mrakoplas
    Commented Oct 21, 2020 at 3:46
3

Save as Geopackage solves the problem in QGis 2.18

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.