2

I am using QGIS.

I am trying to export my attribute table to Excel but I want the virtual fields also to be exported with their function. For example I have a field that sums up two other fields and I want in my Excel file to keep the sum function and not only the context of the number.

  • 2
    Hey, welcome to GIS SE. What software are you using? – Marcelo Villa-Piñeros Mar 4 '20 at 22:56
  • I'm using Qgis software – YuvalM Mar 4 '20 at 22:58
  • 1
    Please edit your question to make it clear. – Marcelo Villa-Piñeros Mar 4 '20 at 22:59
  • keep in mind, that you can't directly translate the QGis Expression to Excel Functions. Even if you find a way to export the fields with the underlaying function, the calculation most likely won't work since the syntax is different. – nepluisse Mar 5 '20 at 10:07
  • Ok thank you. Is there a way I can export only the non-virtual fields into an existing Excel table? – YuvalM Mar 5 '20 at 10:20
2

If you want to export your attribute table containing virtual fields, just right click on the layer, choose export, then select MS Office Excel format. All attributes will be exported including the virtual fields that you have created. However, the functions from the field calculator cannot be exported as MS. excel formulas.

enter image description here

  • I think that the question was about export 'Virtual Fields' in a normal layer. – Val P Mar 5 '20 at 6:27
  • you are right @ValP. I have amended the answer accordingly. – MyGIS Mar 6 '20 at 0:49

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.