Enalyzer Help Center

Download Response Data

On this page you'll find:

 


AVAILABLE FORMATS

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 survey. You can download your responses as 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.

back-to-top.png


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 options dropdown and select download.
  3. Select the format you want to download: Excel, CSV, or SPSS.
  4. Define your download by enabling the options you'd like to include.
    • Time period: 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.
  5. Once you've defined your Excel file, click the download button.

back-to-top.png


UNDERSTANDING YOUR 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.

BACKGROUND VARIABLES

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

Survey 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.

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

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 https://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

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

back-to-top.png


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 dropdown and select download.
  3. Select CSV.
  4. Define your download by enabling the options you'd like to include.
    • Time period: 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.
  5. Once you've defined your Excel file, click the activate link button.
  6. Copy that link and share it or set up an integration.
tip.png To revoke access to those with the link, click on reset link.

INTEGRATE USING THE CSV DOWNLOAD URL

The link will download a CSV file, so you can set up parameters to pull the CSV data from the link.

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk