0

I am using QGIS 3.12. I want to export my attribute table to an exciting EXCEL table but I want to arrange the columns in a different order and also to select which columns to export and which not. Is it possible?

1

I think the best way is to use the "Refactor fields" tool from the processing toolbox.

This tool let you reorder field, drop field, rename field and even using expression to change field value. You can then save the result in many different format including .xlsx

From the tool help :

Refactor fields :

This algorithm allows editing the structure of the attributes table of a vector layer. Fields can be modified in their type and name, using a fields mapping. The original layer is not modified. A new layer is generated, which contains a modified attribute table, according to the provided fields mapping.

2
  • Cool..I'll try.Thank you! – YuvalM May 27 '20 at 7:32
  • You can also create a virtual layer if you know how to write sql and then save the output to any format you need – kartoza-geek May 28 '20 at 20:00

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.