Export survey responses
As a survey manager, you can export the responses in the CSV or Excel format.
How to export survey responses?
Basic
Click the “Download responses“ dropdown menu.
Choose your desired export format (CSV or Excel).
The “Download responses“ button is only visible when there is at least one response to the survey.
Advanced
Click on the “Display responses” button.
Scroll until you reach a table that contains all responses.
You can play around with the order of fields/columns or hide some of them. (A dropdown list will appear on top of the table to restore all hidden fields.)
Click on either of the export buttons that appear on top of the table to start an export in the respective format (CSV or Excel). Only the visible fields will be exported.
What data is being exported?
The data is organized into a table where fields (columns) constitute of questions from the survey and meta-fields that contain general information about the response. The first row is a header that indicates the field names. Each of the remaining rows represents a submitted response.
General information / Metadata
The metadata is not available in anonymous mode.
The first few columns contain some general information about the response. If the survey is anonymous, the columns do not appear in the export.
User id: The key Confluence uses internally to identify its users. It is used in the Survey macro to have a unique and consistent way to identify the users.
Username: The username of the person who responded to the survey. This is the same one that is used to log in to Confluence for example.
Full name: The full name of the person who responded to the survey.
Email address: The email address of the person who responded to the survey. This field may be empty in Cloud instances if the participant chooses not to disclose this information in their Confluence privacy settings.
Last submission: Time and date of the latest submission. After responding to the survey, participants can still change their response until the survey is closed.
Responses to questions
The remaining fields (columns) contain the response itself. Generally, each field (column) is a question, with the first row containing the question title (question name if title is unspecified) and each remaining row containing the respective participant’s response to it.
Most questions are represented by just one field (column). If the question’s answer consists of many items, they should be listed within that column. With the exception of matrix-like questions where a multitude of fields could be assigned depending on the question type.