2.3.2.1. Export to Excel

Export of answers (Raw data)
You can export your project data to other systems, for example your personal system or contract system. It may also be a statistical tool such as Excel, SAS, or SPSS. It is common for these systems to import an Excel data file (comma-separated file). Therefore it is possible to export raw data from ESS in these output formats.

Raw data files are useful if you, for example, want to make your own calculations in SPSS or Excel, or if you want to see each respondent’s individual answers.

 

How to create a raw data file

  1. In order to create a raw data file, you have to specify your search criteria for respondents in the search/respondents page. To do this, go to launch, select search/respondents, specify your search criteria and click the search button.
  2. After doing so, click on the answers button under the export menu and a new window will appear.
  3. Here you can choose between five different output formats for your raw data file:
    • Microsoft Excel - Answers (Text)
    • Microsoft Excel - Raw data (numbers)
    • Semicolon separated file - Raw data (Numbers)
    • Semicolon separated file - Answers (Text)
    • SPSS

    Answers (Text) provides an export that contains text from the response options.

    Raw data (Numbers) provides an export that contains answers coded as numbers.

    You can also choose to export your raw data file in SPSS format. The export of raw data can for example be used if you want to import the answers to a statistical tool. It is through this option that you can choose the advanced settings. Your output should be in unicode, ANSI or UTP-8 Format.

    Enalyzer exports the files with element numbers for each question. Each response is either coded with the stated response (text) or with a number (raw data). The number states, which number the response option had in the survey.

    Example: The question 'Age' with the response options 'Below 50' and 'Above 50' will be coded the following way: If the respondent answers 'Below 50' the value will be 1 and if the respondent answers 'Above 50' the value will be 2. This is very useful if you want to import the responses to statistical programs that prefer numerical values. In other situations where you, for example, want to import the responses to your contact system you might want the response alternative as text instead.

    Choose the format by marking the wanted format in the drop down menu and press Save as... Enalyzer will now start generating the data file.

  4. If you want the respondents’ project-ids and passwords in the file you must select Extended Respondent data.

Note: If you want all the respondents’ data, you can just press search without specifying any criteria and then export your raw data file.


First you can see the respondents’ data, meaning their e-mail, first name and last name. Then you can see the respondents’ background variables and if there are any user-defined variables (UDV) they will also appear here.

After that two system background variables [TARGET GROUP] (contact group) and [LAUNCH] (Launch) will appear.

Finally you can see the respondents’ answers to the different questions.

Have more questions? Submit a request

Comments

Powered by Zendesk