How to: Advanced Export

Introduction

The Advanced Export function in the Responses page gives users additional export options for further flexibility and applications.

For example, the option to breakdown the export of a data set by the answers to a specified question, outputting a separate file for each available answer. This can be a useful feature when the answer to a question separates respondents into actionable groups, for example the geographic area in which the respondent is resident.

Exporting a coded version of the response data is also available and can be useful when using third party software. Additionally API exports can be set-up for importing data into other software packages.

Steps to Download a Coded CSV

1. Navigate to the Responses page and select the Responses tab.
2. Select [Advanced Export].
3. Select [Download coded CSV]. (As with other response exports, the export is sensitive to any active filters you may have applied to the table.)

Steps to exporting response data, broken down by question answers

1. Navigate to the Responses page and select the Responses tab.
2. Select [Advanced Export].
3. A dialogue box will appear prompting you to “Select a question to split responses by.”
4. Open the Filter Question menu and select he desired question (for example, geographic location).
5. The above text will now change to detail the number of files the filter will generate.
6. The export is sensitive to any active filters you may have applied to the table. You may wish to apply filters prior to your export to further refine the data (for example using dates or filtering by completed responses). Do this using the toolbar above the table. Alternatively, de-activate any filters to include the full data set.
7. When ready, select [Download csv files] button in the dialogue box to download the files. You may need to grant permission to your browser before downloading multiple files.
8. Once all of these steps have been followed you will have downloaded the files. Please note that the title of the files indicates the answer used to split the data.

API Export

Where API export is enabled, there is an additional button to show the API settings.

The API settings include a url for GET requests, together with the settings for the Authorization header. These settings allow data import into any package that supports REST style HTTP requests. For R, the httr package, together with the jsonlite package can be used to import data from the API. The rlist package can sometimes be useful, depending on the processing requirements. Data from the responses API is provided as an array of keyed objects. The keys corresponded to the question IDs.