Need help? Looking for tips and tricks?

This knowledge base contains 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, click 'Responses Organised by Respondent' on your consultation dashboard.

Responses organised by respondent link on the consultation dashboard

Step 2

You can then 'Download all responses', 'Download all responses including analyst fields' and 'Download all documents'.

  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, click 'Responses Organised by Question' on your consultation dashboard.

Responses organised by question link on the consultation dashboard

Step 2

Click on 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.

Screen_Shot_2017-08-04_at_11.55.29.png

 

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.

 Individual_response_download.png

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.

Powered by Zendesk