I tried to save a qlr file for a shp layer joined to an xls file, but when I load it, the join definition isn't there anymore...

Join definition is present in the qlr file, so I assume it should work.

Has anybody already tried this ?

  • Did you check the layer id in the qlr file matches the layer id in your project? Dec 20, 2015 at 10:25
  • Thank you for your answer, Matthias. I am trying to load the qlr in an empty project... I also tried with a csv instead of the xls, but had the same problem. Checking the content of both qlr files, it appears that there is no reference to the xls/csv file, only to its id in the join definition, which explains why the join isn't restored : the joined xls/csv isn't loaded.
    – sigeal
    Dec 20, 2015 at 14:31
  • I think you need to load manually the xls/csv file in the empty project. Or work on the same project that remembers shape and xls/csv and qlr file. Why trying to load your layer inside a new project?
    – wiltomap
    Dec 23, 2015 at 7:49

2 Answers 2


Had the same question, and eventually figured out that grouping your xls/csv with your shapefile enables you to save the group as qlr.

Then, simply load the qlr : shp and xls/csv are equally loaded whithin the group you created.

Hope that might help other people having same question.

  • Great trick, works perfectly !
    – sigeal
    Mar 2, 2020 at 8:17

Once your XLS file is joined to your shapefile, then save your shapefile with a new name in order to save the added columns in the attribute table of your shapefile (right-click on layer > Save As...). If you don't do that, the joined columns seem to be included in the attributes table but this is virtual and not properly saved within your shapefile attributes.

Hope this helps.

  • Thanks for this answer, wiltomap. I know that I can save my layer to keep joined fields, but I would like to have a dynamic join.
    – sigeal
    Dec 23, 2015 at 7:07

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.