Hello! How can we help?

Search our knowledge base for loads of useful advice and answers to common questions

If you're still stuck you can always submit a support request and we'll get back to you ASAP

Responses - how do I download or export responses from my consultation?

Support -

You can download both responses to individual questions or all responses to the whole consultation.

Downloading all responses

Step 1

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.

Responses organised by respondent link on the consultation dashboard.

Step 2

In 'Responses Organised by Respondent' you can then 'Download all responses', 'Download all responses including analyst fields' and 'Download all documents' as well.

  Download all responses links on the responses by respondent page.

Download responses for a question

Step 1

To download all responses to a specific question, select 'Responses Organised by Question' on your consultation dashboard.

Responses organised by question link on the consultation dashboard.

Step 2

Select the relevant question that you want to download responses for.

Responses by question page.

Step 3

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.

Export screen message: Generating your export, please do not refresh or leave the page. Screenshot.

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.

Successful export message: Export ready for download. Screenshot.

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.

 Respondent list of individual PDF responses to download. Screenshot.

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.