To download the results of a query, click the Download tab on the results page. Note that the data downloaded here includes only the data returned by the query. To download all of the survey data, see Downloading Data.
Downloading Results
To download data:
- Click the Download tab on the Results page.
- Choose the type of data to download. Summary data includes only statistics about the results, such as counts and percentages. Raw data includes all of the actual responses that participants have submitted.
- Choose a file format. These are explained in more detail below.
- Click Download.
File Formats
A number of different file formats are available. SPSS and SAS data can be viewed in the raw data format only. Summary data are not available for SPSS and SAS. Data can be downloaded raw or summary data in Excel, HTML, Tab Delimited text, or XML.
- HTML – This is suitable for formatted display in most current browsers, including Internet Explorer and MozillaFirefox.
- XML – This is suitable for applications that can manipulate XML.
- SPSS (.sav) – This format will import the scale code and label for questions with text datatype/scale codes. There is no limit to the length of the scale code. The maximum length of text data is 32767.
- SPSS Syntax – This is suitable for import into newer versions of SPSS.
- SPSS (Short Names) – This is suitable for import into newer or older versions of SPSS.
- SAS (zip) – The ZIP file contains a syntax or program file and a separate data files. Contains all the features outlined in the SAS download section. The separate data file allows text data to be as long as 32760 characters. The data file is encoded using UTF-8 (Unicode) so non-ASCII chars are preserved.
- SAS (raw data only) – This is suitable for import into SAS.
- Double quote values (“) are preserved in text values.
- The pipe character (|) is replaced by an asterisk (*) in text values.
- Have output formats for date (DATE9), time (TIME8), and date/time (DATETIME18) data types. Without an output format, these values display as a numeric value which is not very human readable.
- The text “informat” length is calculated and based on the maximum length contained in the data set for each specific text property.
- Text data is truncated at 958 characters.
- Tab Delimited – This is suitable for unformatted viewing in Microsoft Excel or in any text editor. In addition,many SQL databases will import data from tab-delimited text files.
- Excel – This is suitable for formatted display in Microsoft Excel.
- MS SQL – This produces a SQL script that will
-
-
- Create the necessary tables in SQL server
- Insert data into the tables.
-
The SPSS (Short Names) format limits all variable names to eight characters, to comply with naming restrictions in older versions of SPSS. The other SPSS format leaves your survey variable names intact, and is compatible with newer versions of SPSS.
To import data into a SQL database other than Microsoft SQL Server, download using the MS SQL format and run the CREATE TABLE statements in the file. Import the data by removing or replacing the GO statements, or by downloading the tab-delimited data and import that into the newly created database tables.
Summary Data Format
The summary data format displays the aggregate values that can be calculated from the participant data (Count, Percent, Max, Min, Mean, etc). With summary data it is easy to see the breakdown of responses for a particular question. With questions that allow for free-form text responses, such as a comments, aggregate values cannot be calculated. Only the number of the responses can be calculated. If you would like to view text-items in a list instead of viewing only the number of responses to this type of question, choose the “list text items” option. This will provide an overall report that includes summary data for questions with scale values and raw data for text-entry questions.
NOTE: If there are a large number of responses, the list of comments may be long in the report.
Raw Data Format
The raw data format displays questions in a large table. This is your standard spreadsheet layout where each column is a question, and each row is a participant’s response. Each cell of the table is a participant’s response to a particular question. To run reports outside of the Data Manager, download the raw data and import them into other statistical packages.
SAS and SPSS
SAS and SPSS download formats may include only raw data. The options to List Text Items and Include Value Labels do not apply to these formats. Because these formats can only include raw data, the text items are always part of the download. In addition, the downloads include not only the data, but a data dictionary SAS and SPSS automatically import. This means that the value labels always come with the SAS and SPSS downloads and will be present when you import the data into SAS or SPSS.
List Text Items Option
Summary results include no useful information about text items. Because text questions are open-ended, permitting an almost unlimited range of responses, Illume does not calculate counts, percentages, or other statistics for these questions.
If the List Text Items option is checked, the download will include raw data for each of the text questions in the survey. For example, if 100 participants typed in their first names, the download will include all 100 first names.
Include Value Labels Option
The Include Value Labels option adds value labels next to the value codes in the data you download.
For example, a question called GENDER may have two response options: 1 = Male and 2 = Female. When you download the raw data, the GENDER column will be a list of 1’s and 2’s.
If Include Value Labels is checked, each entry in the GENDER column will be either 1:Male or 2:Female.
This option makes the data more readable to humans, but it hinders applications such as Excel from processing the data in a purely numeric way.
The Include Value Labels option applies only to Raw data in formats other than SAS and SPSS.