TransWikia.com

Export only selected and reordered columns to Excel

Geographic Information Systems Asked on May 26, 2021

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?

One Answer

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.

Answered by J.R on May 26, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP