Export a modern report 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.

You can download raw activity report data to a CSV file. This allows you to analyze, share, and process your report data in third-party tools outside the Alida platform.

A row in the CSV file is included for each response to the activity. Filters applied to the report do not affect the CSV export; all live responses are included. Additionally, any banners, recodes, or other features applied to the report are not reflected in the CSV export. Test data is not exported.

Other/specify answers, Net Promoter Score℠ 1 follow-up questions, and other survey data marked as sensitive data is only exported for Admins, and other users with the Can access sensitive data permission. Columns containing sensitive data are omitted for users that do not have access to sensitive data.

  1. Open the modern report.
  2. On the report toolbar click Export > CSV (Response Data).
    Result: 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.
  3. 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.

    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.

    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 The stars selected. For example, "1 Star".
    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.
    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
    • Image Upload
    • Video Feedback
    • Appointment Booking
1 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.