_1@2x.png)
GravityExport: Splitting complex fields in Multiple Columns
By default, complex fields like the Name, Address, and other fields that contain sub-fields get combined into one column during export. This is often not useful, especially for data analysis.
With the Multiple Columns setting disabled:
| Entry ID | Name |
| 1 | Miss Alice in Wonderland PhD |
| 2 | Mr. Bob Sponge Squarepants Ms |
Notice how all the sub-fields of the Name field are combined into one column.
With the Multiple Columns setting enabled:
| Entry ID | Prefix | First | Middle | Last | Suffix |
| 1 | Miss | Alice | in | Wonderland | PhD |
| 2 | Mr. | Bob | Sponge | Squarepants | Ms |
When using GravityExport Lite, this setting is available in the GravityExport's Settings tab on the Gravity Forms' Settings page.
