When exporting survey data, you can control which columns are included, their order, and their names. This saves time by producing exports that are ready to use without additional editing.
Enabling column customization
To customize which columns appear in your export, you first need to enable the feature:
- Open your survey and go to the Responses tab
- Click the Export button
- Enable the Customize column order and names toggle
- The column configuration panel will appear
Column customization is available for the Excel, CSV, SPSS, SAS, and Stata file types.
Selecting columns
Once customization is enabled, you can choose which questions and metadata fields to include:
- Review the available columns and selected columns
- Move columns between the "Available Columns" and "To be exported" lists
- Click Download
Only the selected columns will appear in the downloaded file.
Reordering columns
With column customization enabled, drag and drop columns to change their order. The exported file will follow the order you set, so you can arrange columns to match your analysis workflow or reporting template.
Renaming columns
You can set custom column headers that will appear in the exported file instead of the default question titles. To rename a column, click its name in the "To be exported" list and type the new name. This is useful when:
- Question titles are too long for spreadsheet columns
- You need specific column names to match an existing data model
- You want abbreviated headers for easier data manipulation
You can also set a permanent Column Header for each question via Additional Settings on the Setup page, which applies to all export formats.
Saving column presets
Your column configuration is saved per survey, so you do not need to reconfigure it each time you export. If you regularly export with the same settings, your preferences will be remembered.
Default columns
By default, exports include all questions in the survey along with standard metadata fields such as the entry ID, page count, upload date, a link to the response, notes, source filenames, print batch, and tags. Surveys with web surveys enabled also include a collection method column (paper or web), and graded quiz surveys include a total score column.