From time to time you may want to download individual responses, or groups of responses. This might be to archive responses prior to deletion in order to manage your organization's storage quotas. Or you may want to analyse a large quantity of response data as a spreadsheet.
Download individual responses
To download an individual response:
Go to your form > Responses.
Search for the response you’re looking for using the available filters in the list of responses.
Choose Default response PDF to download a PDF summary of the response
You can configure what’s included in this PDF. See Set up the response PDF for more information
Alternatively, if you’d like to package any files the respondent has uploaded with their submission or any custom documents generated from the response, alongside the default response PDF, choose Advanced export.
And select which items you’d like to package with your download.
If you’ve included respondent uploads in your advanced export, we’ll let you know when you begin your export if any of these are still pending a virus scan.
Export multiple responses
To export multiple responses as an excel or CSV file:
Go to your form > Responses.
Search for the responses you’re looking for using the available filters in the response list
If you’d like to export all of the responses for a particular form, skip this step.
Select Bulk Actions.
Select Export Responses.
This option will reflect the number of responses you will be exporting
Choose whether to download the response data as a Microsoft Excel or CSV file.
If you’ve chosen to download your response data as a Microsoft Excel file, you can also include respondent uploads and custom documents that have been generated from your response data in your export.
These will be included in separate folders in your ZIP file. Respondent uploads will be linked in your Excel spreadsheet so you can easily find them when analyzing response data.
Custom documents will be exported to their own folders in your package sorted by response number.
If you’ve included respondent uploads in your bulk export, we’ll let you know when you begin your export if any of these are still pending a virus scan.
Select Begin export.
OpenForms will start packaging your response export. If your export includes a lot of responses, respondent uploads or custom documents this can take a while.
Make sure you don’t close the download window while your export is being prepared, or your progress will be lost.
We’ll let you know once your export is ready.
Select Download to save it to your computer.
The default response PDF is not included in bulk exports as this is generated on demand and may increase your wait time if you’re downloading a lot of responses.
If you’d like to export multiple response PDFs, consider setting up a response email for your form with the default response PDF attached. This will automatically send a PDF summary of responses to the recipient whenever a response is submitted.
You might also want to schedule email reports about responses to keep an eye on response traffic for important forms.