When I copy data from a table attribute to excel the order of column is randomly. E.g. If in Qgis the order of column is column_a, column_b, column_c, column_d in excel is column_a, column_c, column_b,column_d

I've tried to change past format destination but with no result

  • Maybe you could open directly the *.dbf file with Excel (if the data source is a shapefile).... – Oscar Campo Mar 30 '18 at 12:56
  • If you do as @OscarCampo suggests, copy the dbf file and open the copy, not the original. If you open the original, it may corrupt the shapefile. – csk Mar 30 '18 at 18:23

I suggest saving the layer as MS Office Open XML spreadsheet and not use copy/paste (right-click -> Save as...). You can do your selection in QGIS and save only selected features. Furthermore you can select the fields whch you like to export. Field order should be kept as far as I'm experienced:

enter image description here

and then set the dialog up like this:

enter image description here

| improve this answer | |

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.