Data export

Topic
Survey tools and settings
Contents

Data export is saving collected data from a service into a file or another system, to analyze it elsewhere, share it or keep a copy. For surveys it usually means downloading responses as a table with one row per respondent and a column per question.

The format depends on where the data goes next: CSV for any system, XLSX for Excel, SPSS (.sav) for statistics, PDF or Word for a readable report. Before analysis, open answers often need coding, and comparing groups needs cross-tabulation.

How it works in SurveyNinja

  • In Results, the Responses tab downloads CSV, XLSX, DOC and SPSS files on every plan, including Free.
  • For CSV and XLSX you choose how multiple-choice answers are written (one column, or a column per option), the separator, and whether to add the time spent on each question.
  • The file follows the open tab, your selection and the applied filters. Filters are on Basic and higher.
  • The report downloads as PDF or DOC.
  • For automatic export, use Google Sheets or webhooks (Basic and higher) or the API (every plan), which returns responses as JSON, CSV or Excel.

Help: Viewing and downloading survey responses, Viewing the survey report, Google Sheets, API.

Common mistakes

  • A filter is still applied, so the file has fewer responses than expected. Check the filters above the list.
  • Responses over the plan's monthly limit are hidden and don't get into files.
  • All selected options sit in one cell, which makes them hard to count. For analysis, use a column per option.
1