How to export survey results in CSV format

In some cases, you may need to export the survey results in CSV format. You can follow this step-by-step guide to complete the setup correctly and avoid common issues.

Create a custom report to extract detailed survey data

Exporting individual survey responses isn’t available directly. However, you can easily build a custom report for survey events in Analyses > Reports. It allows you to include user identifiers and download detailed results for further analysis.

Below are the steps to create such a report: 

1) Create a new report

1. Go to Analyses > Reports
2. Click Create report.

2) Remove the default metric

1. Click the bin icon next to the pre-filled metric.

2. You should now see an empty report canvas.

   

3) Add a customer identifier to the rows

1. You can go to the Drill down section.

2. Click into the field and select Customer property > email (or any other identifier you need to use, for example, customer_id).

   

4) Add survey questions and answers to the rows

1. Click on "Drill down in Rows by".
2. Select Event > survey > question.

3. Click again and add Event > survey > answer.

   

Your rows should now be drilled down by:

• email (or other identifier)
• question
• answer

5) Filter the report by your specific survey

1. Click Report filters.
2. Choose Event filter.
3. Click the + Add an event attribute button.

4. Add survey_id or survey_name. Then select the desired survey.

   

6) Set the date range

1. Below the canvas, open the calendar.

2. Set the date range to Lifetime to include all submissions.

   

7) Preview and save the report

1. Click Preview in the top right to verify your results.

2. If the data looks correct, click Save.

   

8) Export the results in CSV format

1. Click the three dots in the top right of the report.

2. Select Download CSV.

   

To learn more about how Surveys work, please take a look at the Surveys documentation.