Viewing and Exporting Submissions
After a Spreadsheet Form is submitted, you can view the completed spreadsheet in read-only mode and export it as an XLSX file.
Viewing a Submission
- Go to My Submissions, Submission History, or the relevant workflow action
- Find the submission in the list
- Click to open it
- Click Full view or Open Full View to view the spreadsheet
The read-only viewer shows the submitted spreadsheet snapshot with all stored sheets and submitted values.
What the Viewer Preserves
The viewer preserves compatible spreadsheet details, including:
- Sheet names
- Submitted cell values
- Supported column widths
- Supported styles
- Supported merged cells
- Bound cell highlights
- Submitter, submitted date, and status metadata when available
The viewer does not allow editing.
Exporting as XLSX
In the read-only viewer, click Export as XLSX.
The exported workbook:
- Creates one Excel worksheet per submitted sheet
- Uses the submitted sheet names
- Preserves supported column widths
- Preserves supported merged cells
- Preserves supported fill color, text color, font size, bold, alignment, and compatible border styling
- Exports Number, Currency, Percentage, and Date formats as compatible Excel values where possible
- Applies data protection masks where the current user is not allowed to see protected cells
Formula Export Safety
OSPROV protects bound field values from formula injection during XLSX export.
| Value Type | Export Behavior |
|---|---|
| Bound number fields | Exported as numbers |
| Bound date fields | Exported as Excel dates |
Bound text-like values beginning with =, +, or @ | Exported as safe strings with a leading quote |
Unbound static cells beginning with = | Can be exported as Excel formulas |
Use formulas for template or calculation cells, not for user-entered bound text fields.
Data Protection
OSPROV data protection can mask spreadsheet cells in snapshots. When a user is not allowed to see a protected field:
- The protected cell is masked in the viewer
- The protected cell is masked in XLSX export
- Action flows preserve the original protected value instead of saving the mask text back into the real submission
Query Builder and Submission Lists
Every named spreadsheet cell becomes available as a submission column.
| Spreadsheet Field Type | Query Behavior |
|---|---|
| Number | Number-like query behavior |
| Date | Date or datetime-like query behavior |
| Dropdown | Select-like query behavior |
| Text | Text-like query behavior |
Only named cells are extracted into submission data. Unbound cells remain part of the visual document snapshot but are not exposed as named report fields.
Recommended Use
- Read-only viewer — review the submitted layout inside OSPROV
- XLSX export — keep an offline spreadsheet copy or share the submitted layout outside OSPROV
- Submission lists and Query Builder — report on named field values, not every cell in the spreadsheet snapshot