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.

1 Answer 1


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
    Commented Sep 25, 2016 at 21:10
  • 6
    XLS is binary and a closed format.
    – Nathan W
    Commented Sep 26, 2016 at 0:04

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.