[GIS] QGIS Attribute update using excel

attribute-joinsexcelfields-attributesqgis

I am looking to update the Attribute table for a Layer in QGIS using a join.

However I am not looking to ADD attributes to the table (thereby adding extra columns) rather I would like to "Update" the values within the pre-existing columns.

I have read similar articles to this —> https://infogeoblog.wordpress.com/2013/02/18/joining-layers-in-qgis/

But unfortunately it only adds columns.

Ultimately I am trying to create a CRM system from Excel, whereby I would create tasks / notes / follow ups —–> that would update the values in QGIS. Happy for any other recommendations that would achieve this or CRM QGIS plugins.

Best Answer

I think the only way to update a layer's attribute values from Excel is if you imported a csv file into QGIS and enabled the Watch file option:

Add Delimited Text Layer

Now when you edit your file from Excel, the Attribute Table in QGIS will also update (if the table is open, you will need to close and re-open it again).

If you join a layer to the imported csv and updated the results via Excel, the imported csv will again be updated but the joined layer will not be updated. The only way to update the joined layer would be to rejoin it again.

I have asked this as a feature request over a year ago and has been classed as Future Release - High Priority.

Related Question