I have a project in Qgis that gets its data from a locally stored excel file (linked). Is there a way to automatically update the linked data? What is happening now is that when I change some rows in the excel file, I have to go back to the project "delete" and "classify" the selected data. I would like to see this automated. I have very few (none) experience with Qgis.

  • Is it an excel file or a csv? If the layer is classified using the column attribute it should stay classified even if the rows change. If you right click on the layer you can see the attribute table and that may help "visualize" what is happening. From VIEW -> Panels -> Layer Styling you can select the column you want to Categorize with. Look Here -> ibb.co/tDJrv9V
    – Cary H
    Feb 27, 2019 at 19:52
  • 1
    It would probably be helpful if you could give us a little more information about what you are doing. For example, plotting points in an Excel file on background mapping. Does the Excel file contain xy coordinates?
    – nhopton
    Feb 27, 2019 at 20:09
  • 1
    I got CSV file working with the 'watch file' gis.stackexchange.com/questions/148812/…
    – Mapperz
    Feb 27, 2019 at 23:05
  • @nhopton: I got a layer that is linked with a shape file (Qgis ID - Coordinates) next I have another layer that is linked with the excel file (Qgis ID - Name). Through the Qgis ID I'm able to link Coordinate with Name.
    – BCallBE
    Feb 28, 2019 at 7:08
  • @Cary H: I opened your link and this is exactly what I'm seeing in my layer that contains the shape file. If I change values in the column of the locally stored excel file, I automatically see changes in the layer in qgis that's connected to it, but the layer containing the shapefile doesn't refresh its data. In layer containing shapefile I go to: properties-symbology-delete all-classify
    – BCallBE
    Feb 28, 2019 at 8:14


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.