You can download your survey data in a range of formats—Word, CSV, Excel, SPSS, JMP, PowerPoint, and more—from the Export panel on your Results page. Which formats you see depends on your survey's question types, your account's features, and how you're signed in.
In This Article
- Export Availability
- Exporting Your Survey Data
- Research Analyses Exports
- Exporting Verbatim Responses
Export Availability
Export formats aren't the same for every account. Each format is controlled by your subscription and your account's feature settings, so a format can be fully available, available with limits, locked, or hidden entirely.
Respondent-level exports—CSV, Excel, SPSS, and JMP—are the most commonly gated. If raw individual data is turned off for your account, every per-respondent format is disabled and the panel will direct you to your account owner.
How you're viewing the results matters too. If you're opening results through a share link or as a guest, you won't see the analysis exports or the data quality options at all. Sign in to your account to get the full set.
Exporting Your Survey Data
All exports start from the same panel, and they all follow the same pattern: pick a category, choose your options, then download.
- Open the Results page of your survey.
- Click the Export icon in the left sidebar to open the Export options panel.
- Choose a category from the dropdown at the top of the panel.
- In the sub-panel that opens, select the file type and any options you want.
- Click Download file.
Export Categories
The dropdown lists only the categories that apply to your survey. A tracker study, a Concept Lab test, and a standard survey will each show a different set.
| Category | What you get |
|---|---|
| Questionnaire | Your survey structure as a Word document—no response data. Choose Survey draft or Survey draft with comments. A Print survey draft link also produces a .docx. |
| Response level data | One row per respondent, in CSV, Excel, SPSS, or JMP. See the file types below. |
| Summary data | Aggregated data tables rather than individual responses. Available as Excel summary. |
| Presentation | An aytm-branded summary of your results with graphs in your chosen color palette and links back to the live data. Available in PDF, PPTX, and Keynote, with options for which sections to include and which template to use. |
Depending on your survey's question types, the panel also lists question-specific analysis exports—Conjoint Analyses, Concept Lab, Concept Mapping, Tracker Mapping, Impression Dial Analyses, Ecommerce Events, and TURF Analyses. See Analysis Exports below.
💡 Tip: Response level data and Summary data are easy to mix up. Use Response level data when you need one row per respondent for your own analysis, and Summary data when you want the aggregated data tables.
Response Level File Types
| File type | Details |
|---|---|
| CSV | An unformatted copy of your coded data, with question text included. |
| Excel | Choose a Data type: Answer text for the labels respondents saw, or Numerically coded with labels for coded values alongside their labels. |
| SPSS | A .sav file for import into statistical analysis software. |
| JMP | A .jsl file for import into statistical analysis software. Tick the option to include question text in the variable name if you want longer, more descriptive variable names. |
Additional Export Options
Depending on the category you choose and what's in your survey, the panel may also offer these checkboxes:
- Apply active filters—limits the export to the data left after the filters currently applied to your results.
- Exclude OE Code Columns—leaves the open-ended code columns out of the file.
- Hide aytm Logic—strips Logic out of the text in your export. Only appears if your survey actually contains Logic.
Hide aytm Logic
This option cleans Logic out of your question text, answer text, and column headers. Your response data isn't affected.
| What's in your text | What the export shows |
|---|---|
A Logic block, e.g.
[qualify]
|
Removed entirely |
A piping reference, e.g.
[Q1]
|
Replaced with a literal
[...]
so you can see where the piped value sat
|
An alias, e.g.
[@alias]
|
Removed entirely |
Escaped brackets, e.g.
[[text]]
|
Unescaped to
[text]
|
Research Analyses Exports
Analysis exports are question-specific: each one covers a single question and produces one file.
| Export | What you get | Format |
|---|---|---|
| Banner tables / Crosstabs | Significance-test matrices covering every question by every banner group. The workbook has three sheets—Index, Tables, and Legend—with the confidence level shown in the title row. | .xlsx |
| Conjoint Analyses | The underlying data behind a Conjoint question—utility scores, ranked packages, or the design sheet. See Conjoint Analyses below. | .csv |
| Concept Lab | An Insight Mapper workbook for one Concept Lab question. The single Current view sheet reproduces exactly what's on your screen at the moment you export—slides, tables, and formatting included. | .xlsx |
| Concept Mapping | The same workbook, built from a Concept Mapping instead. | .xlsx |
| Tracker Mapping | The same workbook for a Tracker Mapping, rendered as a time series across waves. | .xlsx |
| Impression Dial Analyses | The dial timeline in long format—one row per respondent, scale, and timepoint. Columns are always RespondentId, Scale text, Time(s), and Value. Files get large quickly: a five-scale question with 30 respondents across 60 timepoints produces 9,000 rows. | .csv |
| Ecommerce Events | One row per timeline event for a single shelf or Ecommerce question, each prefixed with the respondent ID. The download button reads Raw Events. Columns come from the data itself, so two surveys won't necessarily have the same columns in the same order. | .csv |
| TURF Analyses | Top-box TURF output for an eligible question. See TURF Analyses below. | — |
In addition to exports available from the Export panel MaxDiff and Choice Based Conjoint Segmentation have their own exports directly from the results.
MaxDiff
In the results of a MaxDiff that uses Hierarchical Bayes (HB), click Download Individual Statistics & TURF and select an option. If TURF isn't enabled for your account, the button reads Download Individual Statistics. MaxDiff studies that don't use HB don't have this export.
Choice Based Conjoint Segmentation
In the results of a Conjoint with Segmentation, click the export icon to the right of the personas and choose a CSV download:
- Utility Scores
- Ranked List of Packages
- Stacked choice data
- Download Design Sheet by aytm (CSV)
Below the Conjoint results, you can also add packages and download the Market Simulator as an Excel file.
These are separate from the Conjoint Analyses category in the Export panel, which offers a different set of files. See Conjoint Analyses above.
Conjoint Analyses
If your survey includes a Conjoint question, you can export its underlying data from the Export panel. This is separate from the export icon on the Conjoint results themselves—see Analyzing a Conjoint test.
- Click the Export icon in the left menu to open the Export options panel.
- Click the category drop-down and select Conjoint Analyses.
- Click the second drop-down to choose a Conjoint question. If the survey has only one, it's selected for you and shown as a label instead of a drop-down.
- Select the data set you want:
- Raw Utility Scores—the utility coefficient for every attribute level (Conjoint SegmentationSM only)
- Ranked List of Packages—every package scored and sorted from best to worst
- Design Sheet by aytm—the conjoint design used in your survey, as an attribute and level table
- Click Download file. All three exports download as CSV.
TURF Analyses
Certain question types also generate a TURF Analysis, which you can export from the Export panel.
- Click the Export icon in the left sidebar.
- Select TURF Analyses.
- Use the second dropdown to select a question. If only one question is eligible, it appears as a fixed label instead of a dropdown.
- Select TURF TOP 1 box (A1) or TURF TOP 2 box (A1 & A2).
- Click Download file.
Making an Export Appear
If an analysis export isn't listed in the panel, it's usually because the underlying analysis hasn't been created yet, or your survey doesn't contain the specific question type required for it. Here's where each one comes from:
- Concept Lab—go to the Analysis tab in the sidebar and click Concept Lab. An Infoview compare-items block will also surface it.
- Concept Mapping—go to the Mapping tab, click Create new mapping, then Concept Mapping.
- Tracker Mapping—same tab, then Tracker Mapping.
- Impression Dial Analyses—your survey needs an Impression Dial question whose results aren't flagged as bad data.
- Ecommerce Events—your survey needs an Ecommerce question whose results aren't flagged as bad data, plus the Ecommerce export feature enabled on your account.
- Conjoint Analyses—your survey needs a Conjoint question whose results aren't flagged as bad data, plus the Conjoint export feature enabled on your account.
- TURF Analyses—your survey needs either a Checkboxes or matrix-style question with enough answer options, or an advanced HB MaxDiff with TURF enabled for your account.
Exporting Verbatim Responses
There are two ways to download verbatim responses along with their codebook and codes: one question at a time, or for the whole survey.
By Individual Question
- Scroll to an open-ended question on your Results page. This works on Open Ended, Forms, and Conversation AI questions.
- Click the Export icon on the question to open its menu.
- Select All verbatim (CSV) or All verbatim with codes (CSV). If the question is displaying a word cloud, the menu also offers the word cloud as a PNG, PDF, or EPS.
For the Entire Survey
To get verbatim responses together with their codebook and codes, use Response level data: choose CSV, or choose Excel and set the data type to Numerically coded with labels. Pick Excel with Answer text if you'd rather see the raw response text without codes.
- Click the Verbatim button from the header.
- Click the Export icon.
- Choose a category and your options, then click Download file.