...
| Warning |
|---|
In order to export data to Excel you must setup your form fields as saved fields as described here. Form fields, in the order listed on the Saved Fields list, become columns from left to right when the submissions data is exported to Excel. |
Click the Excel icon at the top of the table to view the submission results in Excel. The spreadsheet reflects the submissions that are displayed in the table (filtered by date).
...
The export to Excel spreadsheet function available in the submission repository reporting screen will now export the saved fields in a column order from left to right that matches the saved field ordering on the saved fields dialog (see section 2) as shown from top to bottom. Note that the submissions meta data is still listed first and the ordering of that data is not available as part of this enhancement.
The submissions export gets a bit more complex with groups and especially with repeating groups. Previously, the export would always maintain fields in groups and repeating groups in adjacent columns. This is no longer possible with user specified ordering of columns. This can make the export slightly strange when you look at it, but the user specified ordering must always work.
...