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? Commented Mar 4, 2020 at 22:56
  • I'm using Qgis software
    – YuvalM
    Commented Mar 4, 2020 at 22:58
  • 1
    Please edit your question to make it clear. Commented Mar 4, 2020 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
    Commented Mar 5, 2020 at 10:07
  • Ok thank you. Is there a way I can export only the non-virtual fields into an existing Excel table?
    – YuvalM
    Commented Mar 5, 2020 at 10:20

1 Answer 1


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
    Commented Mar 5, 2020 at 6:27
  • you are right @ValP. I have amended the answer accordingly.
    – GforGIS
    Commented Mar 6, 2020 at 0:49

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.