Exporting modern report response data to CSV

Export your report data as a comma-separated values (CSV) file to see how each participant answered the activity, question by question. This export type is useful if you want to review raw response-level data.

Exporting all responses or filtered responses

You can choose from two options when you export responses to CSV:

All responses

Think of this as the raw data export option.
The export includes the raw survey responses collected by the application.

Filtered responses

Think of this as the more user-friendly export option.
The export includes the responses that match the filter currently applied to the report. If you want to include all responses, remove the filters.
The export also includes other data such as profile variables and tags. Tags are included if they were applied to responses or added to the report as data tiles.

Note:

For both export options, text tiles and tiles inserted using the AI Assistant are excluded from the export. Additionally, if a question or profile variable data tile is used multiple times in the report, only the first instance where it occurs is included in the export.
Profile variables are only included in Filtered responses exports, not All responses exports. In Filtered responses exports, profile variables are included if they were present in the report (for example, used in banners or added as data tiles).
CSV exports in modern reporting support live data only. If you try to export test data, the CSV file will appear blank.

How sensitive data is handled by the CSV export

The following restrictions are applied to protect sensitive data;

Other/specify answers for Single Choice and Multiple Choice questions, and individual responses for Tree Test questions, are always treated as sensitive data and these responses are always excluded from the export.
If an open-ended question (Short Answer, Long Answer, Email , Zip / Postal Code, and Phone Number) or Net Promoter Score℠(NPS®)¹ question is flagged as sensitive data in the survey builder, the individual responses can only be exported if the user exporting the CSV is an Admin, or a Power User or Author with the Can access sensitive data permission. Columns containing sensitive data are omitted for users that do not have access to sensitive data.

Response metadata included in the CSV export

The following metadata is included for each response:

ID: The unique identifier for the exported row.
ResponseID: The unique identifier for the response.
MemberID: The unique identifier for the member.
Response Started Time: The timestamp for when the user started the activity. The timestamp is in UTC format.
Response Completed Time: The timestamp for when the user completed the activity. This field will be blank if the response is not completed. The timestamp is in UTC format.
Response Status: The status of the participant's response at the time the report was exported. The possible values are Completed, In Progress, Disqualified, and Over Quota.
DisplayType: The device (desktop or mobile) the participant used to participate in the survey.
UserAgent: The browser the participant used to participate in the survey.
RespondentLocale: The language the participant used to respond to the survey.

How questions are formatted in the CSV export

Questions are exported in columns from right to left in the order of the report tiles from top to bottom. Questions are formatted in the following ways based on the question type:

Question Type	Export format
Single Choice	The column is the question name and the rows include the answer text. If the Make answer other/specify option is applied to an answer, a separate additional column is added with the other/specify answer text. For example, if the other/specify answer is named Custom color, a column is added named Custom_color.
Single Choice Grid	The answer text for each statement. A column is included for each statement, formatted as `QuestionName_Statement`.
Multiple Choice	A numerical value with 1 indicating that the answer was selected or 0 if not. A column is included for each answer, formatted as `QuestionName_Answer`.
Multiple Choice Grid	A numerical value with 1 indicating that the answer was selected or 0 if not. A column is included for each answer and statement combination, formatted as `QuestionName_Statement_Answer`.
Rating	For Rating questions displayed in Single Choice tiles, the stars selected. For example, 1 Star. For Rating questions displayed in Number tiles, the numerical value of the rating. For example, "1" for 1 star.
Card Sort	The answer text for each statement. A column is included for each card, formatted as `QuestionName_Statement`.
Net Promoter Score℠	A column is included for each component: A column with the numerical value between 1 and 10 for the NPS®, formatted as `QuestionName_Value`. A column containing a string with the NPS® category (Promoter, Passive, Detractor), formatted as `QuestionName_Category`. A column with the text of the participant's feedback, formatted as `QuestionName_Feedback`.
Allocation	A column for each allocation item with the numeric value allocated, formatted as `QuestionName_Item`.
Rank Order	A column for each rank order item with a numeric value corresponding to the rank position, formatted as `QuestionName_Item`.
Image Upload	The column is the question name and the rows include the identifier for image associated with the response. The format for the uploaded image is `{"fileName": "<image_filename>"}`
Short Answer	The column is the question name and the rows include the answer text.
Long Answer	The column is the question name and the rows include the answer text.
Number	The column is the question name and the rows include the number.
Date	The column is the question name and the rows include the date. The date is in UTC format.
Email	The column is the question name and the rows include the email address.
Zip / Postal Code	The column is the question name and the rows include the zip code or postal code.
Phone Number	The column is the question name and the rows include the phone number. The numbers are included without dashes or any additional formatting.

The following question types are not supported by CSV export:

Usability Task
MaxDiff
Choice-Based Conjoint
Highlighter
Video Feedback
Appointment Booking

Export from a modern report to CSV

You can export individual response data to a CSV file.

The CSV export enables you to analyze, share, and process your report data in third-party tools outside the Alida platform.

Open the modern report.
On the report toolbar click Export > CSV (Response Data).
In the Export CSV (Response Data) dialog, choose the export type and click Export CSV:
- All responses: Export all responses associated with the survey. Filter criteria applied to the report are ignored, and profile variables included in the report are not exported.
- Filtered responses: Only export the responses that meet the filter criteria applied to the report. If profile variables are included in the report they will be included the export.
The Active Exports dialog is displayed while the export file is created. You can wait for the file to become available to download or return to the dialog later by selecting Export > View Active Exports.
If sensitive data is being excluded from the export a message is displayed in the Active Exports dialog.
In the Active Exports dialog, click Download next to the report.
When the download is complete, you can open the file from your web browser, or from the folder where it is saved on your computer. For example, in Google Chrome you can access the download from the top-right corner of the browser.

¹ Net Promoter, NPS, and the NPS-related emoticons are registered U.S. trademarks, and Net Promoter Score and Net Promoter System are service marks, of Bain & Company, Inc., NICE Systems, Inc. and Fred Reichheld.