Submission Workbook
Analyze form responses in an Excel-like grid with grouped headers, filters, and export.
Opening the Workbook
The Submission Workbook is available from the admin panel when you are reviewing responses for a single form:
- Open Form Submissions in the sidebar.
- Choose your form from the form filter dropdown (not "All Forms").
- Click Open workbook next to the filter.
The workbook opens at /admin/form/[formId]/submissions/workbook. You need permission to view submissions for that form.
Grid Features
The workbook presents one row per submission in a wide, scrollable table designed for analysis:
- S.N. — serial number for the current page (continues across pagination, e.g. 51–100 on page 2).
- Submitted At — readable date and time; click the column header to sort ascending or descending.
- Per-column filters — use the filter icon on a column header (equals, contains, greater/less than, empty, and more depending on field type).
- Footer totals — row count and numeric aggregates (sum, average, min, max) for the currently filtered set.
- Pagination — 50 rows per page; filters and sort apply to the full dataset before paging.
Note: Submission ID and last-updated columns are not shown in the workbook; rows are identified by S.N. on screen and by internal id when needed elsewhere in the admin.
Nested Column Headers
Columns are built from your form schema. Fields inside sections, select options with nested forms, and table columns appear under multi-row grouped headers (like Excel), so related fields share a parent label instead of one flat list of column names.
The parent select's chosen value is not exported as its own column — only the nested fields for each option branch appear, grouped under the select field name.
Tip: Use each field's Reporting settings in the form builder (includeInTable, labelOverride) to control which fields appear as workbook columns.
Export from the Workbook
Click Export in the workbook toolbar to download an .xlsx file. The export uses the same filters and sort as the grid (up to 10,000 rows). The file includes:
- Submissions sheet — grouped headers and data rows
- Field logic sheet — conditional rules from the form schema
- Filter summary sheet — row count and column aggregates for the exported set
For quick CSV or JSON exports from the main submissions list, see Export Data.