How To Export Survey Results

Overview

SurveyToGo enables you to export the data of a survey at any point, to a number of different formats. Furthermore, additional export providers can be written easily to support additional formats. Currently, the supported formats include MS Excel, MS Access, SPSS & XML, Word, Quantum and IBM Dimensions DDF. When exporting, you have complete control on the order of the exported columns, enabling you to separate the way the survey is presented from the way the data is to be exported.

The Export Wizard

There are two ways of opening the export wizard

  1. Using the collected data node – Double click on the “Collected Data” Node in the relevant project:

     

    On the screen that opens you have the choice of exporting the interviews or the actual survey structure. Choose the “Export Results” option and select the relevant survey, then click “Export”:

    Please note only active surveys will be displayed in the list. If your survey is marked as “Draft” or “Closed” then it will not be shown. If you need to export results of closed surveys, simply uncheck the Show Only Active Surveys checkbox and it will appear

  2. An alternative way to export results of a given survey is to Right click it – right click on the desired survey in the tree and choose the ‘Export Results’ option

    In the "Export Wizard" window chose the ‘Export results' option:

Using either option you should now be viewing this screen in the Export Wizard:

Exporting Formats

As mentioned above there are several exporting formats that are supported:

Supported formats include: CSV, MS Excel, MS Access, Simple Export, SPSS, XML, Word, Quantum and IBM Dimensions DDF

Most formats are straight forward (such as Excel for example). We created dedicated short guides on the more advanced one:

Important Note regarding SPSS export: When exporting to spss, questions variable names cannot contain any special characters such as &,$, etc. Also, they must begin with a letter (not a number or any other character). You also need to ensure the names are not reserved words such as DATE, TIME etc so to ensure you do not have variable conflicts always apply your own naming such as S_DATE for example. 

Please Note:  The Simple Export Provider will export the data to XML but with less information then is exported using the XML Provider. 

Exporting options

SurveyToGo allows you to control in various ways what data do you want to export and in what format.

The first set of options can be configured through the Export Wizard while other settings are part of the survey script. We will review below the available options.

  1. Extra STG Columns tab

     
    To see a list of all the fields and their descriptions please click here: List of all fields and descriptions 
    When done you can either click the columns order tab to change the columns order settings, or click next to continue.

  2. Columns Order tab

    The columns order screen allows you to define the exact order of the columns you would like to have when exporting the survey results. You can choose to export all or only a subset of the columns available, or even export a column more than once. Both the left list and the right list support multiple selections (by using the Shift and or Control keys) and are completely sort able by any column you desire.

    When you are done configuring the order and number of columns you need to export, simply click the options tab or click Next to continue the export process.

    Note: export settings are saved on your computer for the when you need to export the same survey again.

Option

Description

Left list – Source columns

Contains all the available columns. You can select one or more columns from this list to move to the output columns list. Internal columns, like the ‘duration’ column etc have a yellow background while survey specific columns have a white background. The list supports multiple selections & sorting. To sort, simply click the column of the list you would like to sort by.

Right list – output columns

Contains all the columns that will be included in the output export file. The order of the columns is the actual order of the exported file. To change the order of the columns you can press the up/down arrows. To create a copy of a column, right click that column:

Up/down buttons

Control the actual order of the columns. You can select either one or more columns and press the up down buttons to move these columns up or down.

Left/right buttons

Control the movement of columns between the left and right list. 

3. Options screen
The options screen allows you to configure the following to determine what will be exported and how:

  • Date ranges (per uploaded, submitted and ended)
  • Interview Statuses
  • Interviews Status (Test/Production)
  • Include Filtered Interviews

When you are done, simply click the Next button to continue

Option

Description

Include Filtered Out subjects

Subjects who participate in your survey can be filtered out from the survey due to certain conditions. If checked filtered out subjects will also be included in the exported file, and an additional column – “Filter” is added to the exported data. The “Filter” column contains the index of the question the subject was filtered at.

Export only results submitted between… and …

Enables you to specify a date range for the exported results. If specified, only results from the specified range are included in the export.

Swap rows and cols

If checked, the results are exported so that each subject is a column, and each question is a row, instead of the regular format where each subject is a row and each question is a column.

Include only results in status

Determines results with which status will be included in the export file, by default is set to Approved, therefore only approved interviews will be exported by default . You can choose manually which statuses to export .

Col title format

Enables you to chose the type of column info that will be exported: $SID- exporting the question using it’s short id, $T- exporting the questions text etc.

Ignore Null

Sometimes we conduct interviews with questions that are being skipped, therefore, some questions are left without an answer.
If you tick this box those un-answered questions will be hidden when you export your survey results. 

Export setting via the STG studio

There are a few main things regarding exporting that can be modified within the survey:

  1. You can change the way that answers are exported to be exported as answer text instead of code per question- http://support.dooblo.net/entries/22388577-How-to-export-the-text-of-an-answer-instead-of-the-code-

    Or you can change it (and other settings) for several questions by right-click on the survey name in the designer -> Edit question props


    check the relevant single choice questions you want -> enable the “Export as text” check-box -> enable the “Change export as text” check-box -> click Apply and close the window

2. You can choose different ways to export ‘multiple selection’ questions –http://support.dooblo.net/entries/22811563-How-to-export-Multi-Selection-questions-in-different-ways

3. You can change some of the exporting properties through the survey properties tab, just click on the survey name in the tree and choose the ‘Survey Properties’ tab.

  • Multi selection questions default to Export Null as missing (ticked by default) – When exporting a multiple selection question using the ‘Export to Check/Unchecked Variables’ option, if this box is ticked then a multiple selection question that was coded with zero answers will have zero in all its columns in the export file unlike a multiple selection question that was skipped (and therefore null) that will have ‘missing value’ in its columns in the export file.
  • Use coding format for iteration export – if the loop chapter is defined to iterate by scale then this option will change the columns for the iterations in the export file to be ‘i_CodeName_QuestionsVariableName’ instead of ‘ScaleVaribaleText_ QuestionsVariableName’ 

Finishing the export process, File name selection screen

The file name selection screen allows you to enter the name of the output file name. When you are done, click the finish button to continue.

 

Option

Description

Export Data File

This is the file name that will be filled with all the results according to your selection

Include result attachments

If you specify this option and select a folder location, any picture attachment that was included in the results will be placed in this folder. The name of the picture will be according to the relevant SubjectID field in the results file.

Include attachment list

If checked, you can choose a csv file that will receive a list of links to the various pictures that were included in the results. This is useful if you need links to the attachments instead of the actual pictures.

 After you click the finish button, you will see the following screen:

Answer Yes in order to open the exported file using its associated application, or no to continue without opening the external application. 

Appendix

More exporting resources can be found here:

  1. Generating automatic exporting – http://support.dooblo.net/entries/22388623-How-to-generate-automatic-exporting
  2. Exporting the survey itself – http://support.dooblo.net/entries/23228061-How-To-Export-A-Survey

Visit us at: http://www.dooblo.net

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.