You can download both responses to individual questions or all responses to the whole consultation.
Downloading all responses
To download all responses to your consultation, select 'Download all responses' or 'Download all responses including analyst fields' from your consultation dashboard.
Alternatively, you can select 'Responses Organised by Respondent' on your consultation dashboard.
In 'Responses Organised by Respondent' you can then 'Download all responses', 'Download all responses including analyst fields' and 'Download all documents' as well.
Download responses for a question
To download all responses to a specific question, select 'Responses Organised by Question' on your consultation dashboard.
Select the relevant question that you want to download responses for.
Select 'Export (.xlsx)' to download a file containing the responses to the question.
Generating the export
Whether you've chosen to download the export of all responses or an export of individual questions or filters, you'll be taken to a screen showing you that your export is preparing and then saving.
Once complete, the export will automatically download to your computer. If for any reason it doesn't, there's also a link provided so that you can download your export using that.
Downloading individual responses
In 'Responses Organised by Respondent', consultation admins and analysts can download a PDF copy of each individual response. This is identical to the PDF receipt emailed to respondents on submission of their response (if they supply their email address) and is useful if:
- a respondent contacts you to request a copy of their response, e.g. if they didn't receive an email receipt; or
- you would find it useful to print and review an individual response in a 'clean' format.
If necessary, admins can also export an individual response as a Microsoft Excel Open XML Format Spreadsheet (or .xlsx file). From the dashboard, select 'Responses Organised by Respondent' and add a filter for 'Response ID'. Enter the Response ID of the required consultation response into the search bar and it will appear below. You can then use the button 'Download filtered responses' to export this single response in an .xlsx file format.