This browser does not support basic Web standards, preventing the display of our site's intended design. May we suggest that you upgrade your browser?

WebSurvey System

Exporting Survey Results

The WebSurvey System allows you to export the results of your survey in a format that allows further analysis. This document describes the export options available and how to export the results of your survey.

return to topExport Options

The WebSurvey System offers numerous options when exporting the results of your survey. These allow you to select the format and fields that will make for easy and efficient analysis of your data.

Text Export

A text export results in a file that can be opened in Excel. Respondent answers are in text format. For example, responses to a Yes/No question appear as Yes or No.

Standard Text Export
Responses are in rows by respondent. In other words, each row represents one completed survey. In this format, it is easy to filter or sort on a particular question.
Example: Standard Text Export

Alternative Text Export
Each response is in its own row. For example, if the first question of your survey asked for the respondent’s name and you had 15 responses, the first 15 rows after the column headings would show the names of your respondents. Then, the responses to question 2 would begin. In this format it is easy to copy or view all responses to an open-ended question. You can also filter by question or response ID
Example: Alternative Text Export

 

Numeric Export

A numeric export results in a file that can be opened in Excel and is suitable for other analysis software such as SPSS. Responses are in rows by respondent. In other words, each row represents one completed survey. Responses are in numeric format. For example, responses to a Yes/No question appear as 1 or 2.
Example: Numeric Export

If you choose a numeric export, you will need to export the legend as well. In the example just mentioned, the legend tells you that 1 = yes and 2 = no.
Example: Numeric Export Legend

Response Data

All of these fields except for Username and IP Address are captured automatically and can be exported along with the responses to your survey. In order to export the Username or IP Address, you have to have set up your survey to capture this information.

User Data

Your survey must have been set up to capture this information in order for you to select it for export.

Hidden Fields

If you created hidden fields in your survey, you can select them for export.

return to topExporting Survey Results

The results export file is a .csv file that can be opened in Excel.

NOTES:
For surveys with multiple pages, export results include responses for incomplete surveys.
You can not export survey results while a filter is active. For information on working with or deactivating filters, refer to Using Filters.

  1. From the My Surveys page, for the appropriate survey, click ANALYZEAnalyze button
    The Survey Results – Overview page appears.

  2. Click EXPORT DATAExport Data button
    The Export Survey Data page appears.
    Export Survey Data page

  3. Select the desired export options

  4. Click EXPORTExport button
    The File Download dialog box appears.
    File Download dialog box

  5. To open the file for viewing,
    1. Click OPEN
      A security warning dialog box appears.

    2. Click YES

  6. To save the file,
    1. Click SAVE
      The Save As dialog box appears.
    2. Using the Save in pull-down list, navigate to and select a location for the file
    3. In the File name text box, type a name for the exported results

    4. Click SAVE

Excellence. Our Measure. Our Motto. Our Goal.