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 yes.png     Text
Background variable - numeric   yes.png  

Value

Background variable - email yes.png     Text
Background variable - date   yes.png   Value
Background variable - selection list yes.png   yes.png Text
Multiple choice - single selection yes.png   yes.png Label number
Multiple choice - multiple selection yes.png yes.png   Value
Rating scale yes.png yes.png yes.png Label number
Open answer yes.png     Text
Image choice - single selection yes.png   yes.png Label number
Image choice - multiple selection yes.png yes.png   Value
Image upload yes.png yes.png   Text
File upload yes.png yes.png   Text
Matrix multiple choice - single selection yes.png   yes.png Label number
Matrix rating scale yes.png yes.png yes.png Label number
Ranking   yes.png   Value
Point distribution   yes.png   Value

Input field - text

yes.png     Text
Input field - numeric   yes.png   Value
Input field - email yes.png     Text
Input field - custom yes.png     Text
NPS yes.png yes.png yes.png Value
Recommendation score yes.png yes.png yes.png Value

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 optionsdropdown 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.
    • 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. 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.

CourseEvaluation.gif

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 download.
  3. Select CSV link.
  4. Start by enabling the link.
  5. 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.
  6. 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.
  7. Once you're done editing formats, click the save button and this will save your changes and be applied to all future downloads.
  8. 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.
  9. 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.

Was this article helpful?

1 out of 2 found this helpful