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.

Improve this question
5
  • 2
    Hey, welcome to GIS SE. What software are you using? Commented Mar 4, 2020 at 22:56
  • I'm using Qgis software 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. 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? Commented Mar 5, 2020 at 10:20

1 Answer 1

Reset to default
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

Improve this answer
2
  • I think that the question was about export 'Virtual Fields' in a normal layer. Commented Mar 5, 2020 at 6:27
  • you are right @ValP. I have amended the answer accordingly. Commented Mar 6, 2020 at 0:49

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.