How do I add a column to an attribute table?

When I open up the attribute table I'm unable to click the edit pencil because it's grayed out?

enter image description here

Ultimately, I'm trying to transfer data in a column I have in Excel into this zoning shapefile.

enter image description here

I tried searching for a solution to this issue but wasn't able to find anything.


QGIS, or more specifically OGR, has two different drivers for XLS and XLSX (see http://www.gdal.org/ogr_formats.html)

XLSX can be edited, XLS can not.

Try converting your data to XLSX and you should be able to edit the dataset in QGIS afterwards.

  • what do you think the logic is, for not allowing editing for XLS?
    – ziggy
    Sep 25 '16 at 21:10
  • 6
    XLS is binary and a closed format.
    – Nathan W
    Sep 26 '16 at 0:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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