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, click 'Responses Organised by Respondent' on your consultation dashboard.
You can then 'Download all responses', 'Download all responses including analyst fields' and 'Download all documents'.
Download responses for a question
To download all responses to a specific question, click 'Responses Organised by Question' on your consultation dashboard.
Click on the relevant question that you want to download responses for.
Select 'Export (.xlsx)' to download a file containing the responses to the question.
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.