...
When you mouse over a column in the Submission area you’ll see the icon icon. Click it and choose from several sorting and grouping options:
...
| 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 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 and submission type). The default columns in the submission table appear in the spreadsheet even if you are not displaying them in the table. Hide the columns in Excel if you do not want to display them in your spreadsheet.
Repeating Data
...
You should be aware that the table control in a form defaults to three rows. If you only fill in 2 rows, the third row is still part of the submission. The export to Excel shows a blank row in the resulting spreadsheet.
If you remove the empty row from the table in the form by clicking the icon before submitting, the empty row will not display.
Columns added to the Submission Table will not show in the Excel spreadsheet. See Submission Table for information about how to add a column. For Example, adding the form ID column to the Submission Table will not put a Form ID column in the Excel spreadsheet. This is as designed.
| Section | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
Time and date time values exported to Excel are submitted UTC values from the submission doc. Time data will be displayed in the Excel spreadsheet in UTC format. For Example: The Product Order Spreadsheet shows the data from two customer orders entered at 9:00 AM and 2:30 PM in the Eastern Standard Time Zone. Time data will be converted to UTC and stored in the xml document. Exporting the submissions data to Excel will show the time data converted to UTC as it is in the xml document. See the Order Time column in the image.
Processing submission data using the frevvo API
...