Download Response Data

About Response Data Downloads

You can download all your survey responses from Enalyzer for several purposes. You can use the file for analysis in other software, share it with your team, or import it to another Enalyzer survey.

Available File Formats

You can download your responses in the following formats:

Excel

Export your data to an XSLX format, which can be opened in Excel. This file format cannot be imported back into Enalyzer.

CSV

A file format that can be opened as a spreadsheet in Excel. If you plan on importing this data back into a survey, this is your best option.

SPSS

This file format is compatible with SPSS, a popular software used for statistical analysis, and the go-to tool for researchers and students. You need SPSS to be able to open this file.

Supported Data Formats

You are able to specify the data format for each variable and question when you download your response data. The data formats available are:

Text

This format displays the data as the response option text. In the case of an open answer question, it will be the given open answer.

Value

This format displays the data as the value of the response.

Label number

This format displays the data as the numeric label of the selected response.

It goes without saying that not all variables and questions support all formats. Here's an overview of the supported data formatted by variable and question type:

	Text	Value	Label number	Default
Background variable - text				Text
Background variable - numeric				Value
Background variable - email				Text
Background variable - date				Value
Background variable - selection list				Text
Multiple choice - single selection				Label number
Multiple choice - multiple selection				Value
Rating scale				Label number
Open answer				Text
Image choice - single selection				Label number
Image choice - multiple selection				Value
Image upload				Text
File upload				Text
Matrix multiple choice - single selection				Label number
Matrix rating scale				Label number
Ranking				Value
Point distribution				Value
Input field - text				Text
Input field - numeric				Value
Input field - email				Text
Input field - custom				Text
NPS				Value
Recommendation score				Value

Specified data formats are only saved for the browser you are working in. When collaborating with others on the survey, data formats have to be set separately by each user.

Customize Variable Labels

You are able to specify the label for each background variable or survey element that is shown as header of your response data. By default, Enalyzer auto-generates a label, based on the name of the background variable or the survey element number. The option Data labels generates a label that by default is based on the name of the background variable or the survey element name. You are also able to fully customize these data labels.

Your data labels are defined under your survey settings, all you have to do is:

1. Go to the surveys area () and open your survey.
2. In the side menu, click on settings.
3. Under data settings, click on data labels.
4. You'll see an overview of all survey variables (background variables and question elements) on the left side. On the right side, you'll see your data labels. By default, the data labels are auto-generated, based on the corresponding background variables/survey elements, however, you can define your own values.

Data labels have to be unique, cannot contain special characters, and are limited to 100 characters.

Data labels can only be defined for background variables and questions but not response options.

Data labels are not copied when copying questions, but they are copied when copying surveys or when the survey is shared as a template.

Download Response Data

To download your responses, you have to:

1. Go to your survey and select responses from the side menu.
2. Open the actions dropdown and select download.
3. Select the file format you want to download: Excel, CSV, or SPSS.
4. Click on edit formats to specify the data format for each question and variable for your download. Find all the supported formats for each question and variable here.
5. When you edit formats, you'll see the survey variables and questions on the left side and the format on the right side. To edit a format, simply click on the dropdown menu and select the format you want. If it is not available, it is because the variable/question does not support the format you're looking for.
   

   You're only able to edit 100 formats for your response data download.

6. Once you're done editing formats, click the save button and this will save your changes and be applied to all future downloads.
7. Define your download by enabling the options you'd like to include.
   
   • Background variables: Enable this option to include any background variables you've created, as well as the survey metadata, such as survey invitation time and survey startup time. If you want to download respondents' names and email addresses, enable this option.
   • Open answers: If you've added an open answer question or enabled open answers for your question, enable this option to download them.
8. Once you've defined your file, click the download button.

Background Variables

If you include background variables in your download, you'll find the following metadata:

Invitation time

The date and time you invited the respondent to answer your survey. This only applies to respondents who received an email invitation. The dates are shown in UTC time.

If your date columns in Excel contain ######, make the columns wider. Excel uses # symbols when a date won’t fit.

The invitation time is not available in response data downloads for anonymous surveys.

Start time

The date and time when the respondents started answering your survey. The dates are shown in UTC time.

If your date columns in Excel contain ######, make the columns wider. Excel uses # symbols when a date won’t fit.

Response status

Refers to the status of the response: completed, incomplete, not answered, and refused.

Respondent ID

The ID Enalyzer uses to identify each response in the database. This ID is used when updating background variables and generally does not have a use in data analysis.

Username and Password

The username is a unique ID for your survey. The username is dependent on the method you chose to invite respondents, e.g. if you invited respondents via email and link there will be a unique ID for each method. There is a unique password per respondent.

You can send the username and password to respondents so they can log into their unique session at www.surveys.enalyzer.com. 

You can also use them to create unique URLs for your respondents. This can be useful when you don't have email addresses. 

Language

Shows the survey language code, i.e. the language code the respondent viewed the survey in. The available languages in Enalyzer are:

ar	Arabic	nl	Dutch	de	German	km	Khmer	pl	Polish	es	Spanish
bn	Bengali	en	English	el	Greek	ko	Korean	pt	Portuguese	sps	Spanish (LATAM)
bg	Bulgarian	et	Estonian	hi	Hindi	lv	Latvian	pa	Punjabi	se	Swedish
my	Burmese	fa	Farsi	hu	Hungarian	lt	Lithuanian	ro	Romanian	th	Thai
zh	Chinese	fi	Finnish	id	Indonesian	ms	Malay	ru	Russian	tr	Turkish
cs	Czech	nld	Flemish	it	Italian	ml	Malayalam	sd	Sindhi	ur	Urdu
da	Danish	fr	French	ja	Japanese	no	Norwegian	sl	Slovenian	vi	Vietnamese

Respondent IDs, usernames, and passwords are not available in SPSS downloads.

Understanding Your Excel Download

If you download an Excel file, you'll see that the file is organized into language tabs and a data tab. The number of language tabs depends on the number of languages in your survey. For example, if your survey is in three languages, English, Spanish, and German, the Excel file will have a tab for each containing the survey questions.

The language tab contains your survey questions. Your survey responses are under the data tab. The CSV file does not have a language tab.

Each row is a different survey response (although not necessarily different respondents, if you let people answer multiple times). Each column is a type of survey data, i.e. questions and variables.

Automatic Download and Integration

You can activate a download link that allows anyone who has it to download your response data as a CSV file outside of Enalyzer. All you have to do is:

1. Go to your survey and select responses from the side menu.
2. Open the options menu and select CSV link.
3. Start by enabling the link.
4. Click on edit formats to specify the data format for each question and variable for your download. Find all the supported formats for each question and variable here.
5. When you edit formats, you'll see the survey variables and questions on the left side and the format on the right side. To edit a format, simply click on the dropdown menu and select the format you want. If it is not available, it is because the variable/question does not support the format you're looking for.
6. Once you're done editing formats, click the save button and this will save your changes and be applied to all future downloads.
7. Define your download by enabling the options you'd like to include.
   • Time period for latest updates: You can define the time period for your download. If you want all your data, from the beginning of data collection, keep this option disabled.
   • Background variables: Enable this option to include any background variables you've created, as well as the survey metadata, such as survey invitation time and survey startup time. If you want to download respondents' names and email addresses, enable this option.
   • Open answers: If you've added an open answer question or enabled open answers for your question, enable this option to download them.
   • Completed respondents: Enable this option to download respondents that have completed your survey. Any imported responses are registered as 'completed'.
   • Incomplete respondents: Enable this option to download respondents that have partially completed your survey.
   • Not answered respondents: Enable this option to download respondents that have not answered your survey.
   • Refused respondents: Enable this option to download respondents that have refused to participate in your survey. Respondents can only be marked as refused if you add the refuse URL in your survey invitation message.
8. Copy that link and share it or set up an integration.

To revoke access and permanently delete the link, disable the CSV link feature. This action is permanent and cannot be undone. If you reenable the feature a new and unique link will be created.

INTEGRATE USING THE CSV DOWNLOAD URL

The link will download the CSV file containing the data you specified above (step 4). The survey data can be fetched by an external system over HTTPS using the link provided, allowing you to integrate with third-party apps.