Exporting Data¶
FormVox allows you to export your form responses in multiple formats for external analysis and archiving.
Export Formats¶
CSV (Comma-Separated Values)¶
Best for: - Spreadsheet applications (Excel, Google Sheets, LibreOffice Calc) - Simple data analysis - Importing into other systems
Structure: - One row per response - One column per question - First row contains question titles
JSON (JavaScript Object Notation)¶
Best for: - Developers and programmers - API integrations - Preserving data structure
Structure:
{
"form": {
"title": "Customer Survey",
"questions": [...]
},
"responses": [
{
"submitted": "2024-01-15T10:30:00Z",
"answers": {
"q1": "John Doe",
"q2": "Very satisfied"
}
}
]
}
Excel (.xlsx)¶
Best for: - Microsoft Excel users - Advanced analysis with formulas - Sharing with non-technical users
Features: - Formatted columns - Multiple sheets (summary + raw data) - Charts (optional)
ZIP (File Uploads)¶
For forms with file upload questions, download all uploaded files:
- Open the Results view
- Click Download uploads or the ZIP icon
- All uploaded files are downloaded as a ZIP archive
The ZIP file structure:
Note: This option only appears for forms that have file upload questions with submitted files.
PDF per Response¶
Every response can be downloaded as a PDF: the form as the respondent saw it, with only the questions they were shown, in their language and time zone. It is headed by your Nextcloud's theming (its name, primary colour and, when one is set, its own logo), followed by the form's title and description.
- One response: in the responses list, click the PDF button in the row.
- All responses: choose Export PDFs (ZIP) in the export menu. For a form with many responses from before PDFs existed, the ZIP holds the PDFs that are ready and a README saying how many are still being made; they are made in the background, so download the ZIP again a few minutes later.
The ZIP ends with manifest.csv: one row for every response, with its id, the PDF's file name, its status (included,
pending while it is still being made, failed when it could not be made), and the SHA-256 checksum and size of the
PDF in the ZIP.
A PDF is named {title}_{date}_{response id}.pdf, for example Registration_2026-11-10_3f2a9c1e-….pdf, the same in a
download, the ZIP and the confirmation email. The title is written in plain letters (ä becomes ae, é becomes e).
A response's PDF is made once and kept, so it stays the same document after you change the form's questions. To send it to respondents, switch on Attach a PDF of the response under the confirmation email in the share dialog. Respondents who are signed in get it at their account's e-mail address. A PDF larger than 8 MiB stays behind; the confirmation goes without it.
How to Export¶
From the Results View¶
- Open your form
- Click Results in the toolbar
- Click the Export button
- Choose your format (CSV, JSON, or Excel)
- Configure options (see below)
- Click Download
Export Options¶
Include: - [ ] Response timestamps - [ ] Response IDs - [ ] Partial responses (incomplete submissions)
Format: - [ ] Include question numbers - [ ] Use question IDs as headers (for JSON) - [ ] Flatten matrix questions
Date Range: - All responses - Last 7 days - Last 30 days - Custom range
Working with Exported Data¶
In Excel/Spreadsheets¶
After exporting to CSV or Excel:
- Open the file in your spreadsheet application
- Use filters to analyze subsets
- Create pivot tables for summaries
- Build charts for visualization
Tip: For CSV files, use "Data > Text to Columns" if columns don't separate correctly.
In Programming Languages¶
Using the JSON export:
Python:
import json
with open('responses.json') as f:
data = json.load(f)
for response in data['responses']:
print(response['answers'])
JavaScript:
const data = require('./responses.json');
data.responses.forEach(response => {
console.log(response.answers);
});
Automated Exports¶
Scheduled Exports¶
Currently, FormVox doesn't support scheduled exports. For regular exports:
- Set a calendar reminder
- Export manually at regular intervals
- Consider using the API for automation
API Export¶
For developers, use the FormVox API to export programmatically:
curl -H "Authorization: Bearer TOKEN" \
https://your-nextcloud.com/apps/formvox/api/forms/FORM_ID/responses
See API Reference for details.
Data Privacy¶
Before Exporting¶
Consider: - Who will have access to the exported file? - Does it contain personal information? - Are you complying with data protection regulations (GDPR, etc.)?
Sensitive Data¶
For forms with sensitive data: - Export only what you need - Store exports securely - Delete exports when no longer needed - Anonymize data if possible
Backup and Archiving¶
Regular Backups¶
For important forms: 1. Export data regularly (weekly/monthly) 2. Store exports in a secure location 3. Keep multiple versions
Archiving Old Data¶
To archive and clear old responses: 1. Export all responses 2. Verify the export is complete 3. Delete responses from FormVox 4. Store the export for records
Form File Backup¶
Remember: The .fvform file itself contains all data:
- Form structure
- All responses
Backing up the file backs up everything.
Troubleshooting¶
Large Exports¶
For forms with many responses: - Use date range filters to export in batches - Choose CSV (smaller file size) - Allow extra time for download
Encoding Issues¶
If special characters appear incorrectly: - Ensure UTF-8 encoding when opening CSV - Use Excel's "Import" feature instead of double-clicking - Try the Excel (.xlsx) format instead
Missing Data¶
If responses are missing: - Check date range filters - Verify "include partial responses" if needed - Check form permissions
Next Steps¶
- Review Results Analysis features
- Learn about API access
- Configure Security settings