Skip to main content

Decipher Support

All the topics, resources needed for Decipher.

 

FocusVision Knowledge Base

Data Downloads and Formatting Options

Overview

After running a standard or a custom report in the Portal, you have a variety of options available for downloading your data.

About Data Filtering

The automatic downloads provided will reflect the same base as your report. For example, if you have a base of 600 in your report, the data downloads will all show a base of 600. If you have various segments with various base amounts in your report, our system will create multiple files for you to download.

Accessing Data Downloads

To access the data download options for your survey, click "REPORT" in the navigation bar. Then click "Data Downloads" and select either "Excel" or "SPSS". If you would like to export to another format, click "Other Data Formats".

If you click "Other Data Formats", the Data Downloads window appears, where you can select your preferred output format from a list of every available download option:

Data Download Options

Note: Some download types are not available for use with custom data layouts. Those downloads appear in grey and cannot be selected.

Click on a download name to jump to the description.

Most Popular

Quick links to the most popular downloads we offer. The downloads listed in this section are repeated in other categories. For example, the Excel download option listed within the 'most popular' section is exactly the same as the Excel download listed in the 'vendor-specific' section.

Stacked Data

Downloads specific to surveys with loop elements.

Open Formats

Downloads offering the complete, raw data in various open formats.

Open-Ended Responses

Downloads tailored for reports with open-ended content.

Tracking Files

Downloads with stored information incremented by your survey.

Download Details

Download type Description
Column-Binary

Download to computer

Downloads in zipped file containing one column-binary file per segment, datamap in both HTML and text versions, and a readme file.

Column-Binary (Text)

Opens in browser

Column-binary converted to text format.

Comma-Separated (CSV)

Download to computer

Similar to the tab-delimited format, this is a text based file separated by commas.

Coverage

Opens in browser

Outlines answered vs. shown counts per question. For more information, click here.

Datamap (All)

Opens in browser

Datamap containing all variables.

Datamap (Fixed-Width)

Opens in browser

Datamap in fixed-width format.

Datamap (JSON)

Opens in browser

Datamap for all variables in JSON format.

Datamap (OE)

Opens in browser

Datamap containing open-ended variables.

Deleted Respondents

Opens in browser

Tab-delimited file containing respondents who have been deleted.

Excel 2007

Download to computer

The Windows 2007 Excel file (.xlsx) downloads in a zipped format. The file contains the data, along with an extra tab containing the datamap.

Excel 2007 with Text

Download to computer

The Windows 2007 file (.xlsx) downloads in zipped format. The file contains the data, along with an extra tab containing the datamap. The ordinal data values are replaced with report text. For example,  an answer to a gender question will appear as "Male" instead of "1". The responses to multi-select questions appear as "Answer" (instead of "1") or "NO TO: Answer" (instead of "0").

Excel

Download to computer

The Windows 2003 Excel file (.xls) downloads in a zipped format.  The file contains the data, along with an extra tab containing the datamap.

Field Debug Dump

Opens in browser

List of variables with internal debug information.

Fixed-Width

Download to computer

Fixed width file downloads in a zipped file containing the .dat data file, marginals, datamap in both HTML and text versions, and readme file.

Fixed-Width (unicode)

Download to computer/Opens in browser

Unicode-aware fixed-width download for open-end data.

Flat

Download to computer

Flat data downloads in a zipped file containing a .txt data file where each row in the file is single variable from the survey (e.g. Q1r1, Q1r2) for a single respondent.

Net-MR Datamap

Opens in browser

Datamap for Net-MR in tab-delimited format.

Net-MR Datamap (CSV)

Opens in browser

Datamap for Net-MR in CSV format.

OE Data (Excel)

Download to computer

Open-ended data in Excel format.

OE Data (Flat Form)

Download to computer

Open-ended data in tab-delimited format.

OE Data (Tab-Delimited)

Download to computer

Open-ended data in a tab-delimited text file.

OE Excel (by Sheet)

Download to computer

The Excel file downloads in a zipped format.  The file contains one sheet for each open-ended variable, along with an extra tab containing the datamap.

OE Excel (w/ Blanks by Sheet)

Download to computer

The Excel file downloads in a zipped format.  The file contains one sheet for each open-ended variable with blank data included, along with an extra tab containing the datamap.

Pipe-Delimited

Download to computer/Opens in browser

Pipe-delimited "|" text file downloads in a zipped format or opens in browser.  Zipped file includes the data, both HTML and text versions of the datamap and a readme file.

Pipe-Delimited with Text

Download to computer/Opens in browser.

Pipe-delimited "|"  with Text downloads in a zipped format or opens in a browser.  Zipped file includes the data, both HTML and text versions of the datamap and readme file.

Quantum

Download to computer

Downloads in zipped format and includes the data formatted for Quantum software, both HTML and text versions of the datamap, marginals, and a readme file.

Quantum script

Opens in browser

Datamap for Quantum software.

SAS

Download to computer

Downloads in zipped format and includes the data formatted for SAS software, marginals and a readme file.

SAS Script

Opens in browser

Datamap for SAS software.

SPSS (.sav)

Download to computer

The native file format for SPSS data files.

Note: We use a newer library to generate SPSS *.sav files at twice the speed. Those files are all generated as “unicode” which requires SPSS 16+ if your survey has non-English characters (e.g. accented chars, the € symbol). The SPSS 16+ downloads will give you that file, and a SPSS 15 download will give you the SAV file in the legacy Windows-1252 format.

SPSS (Data+Script)

Download to computer

Different than the complete .sav download, this is a zipped set of files, including the .sps syntax file, data file and readme file.  The syntax, when run, will create a full SPSS file, including value labels.  This option has the same results as downloading the .sav file, however, it is a good option when download bandwidth is an issue, as the syntax files are much smaller.

SPSS (Fixed-Width)

Opens in browser

A fixed-width SPSS datamap.

SPSS (Tab-Delimited)

Opens in browser

A tab-delimited SPSS datamap.

SPSS (.sav) with OE

Download to computer

Similar to the .sav file above, but with open-ended data.

Tab-Delimited

Download to computer/Opens in browser

The tab-delimited text file downloads in a zipped format and includes the data, both HTML and text versions of the datamap and a readme file. The direct to browser option shows data in tab-delimited format.

Table

Opens in browser

An HTML table of all data.

Triple-S

Download to computer

Downloads in a zipped format and includes the data formatted for Triple-S software, marginals and the Triple-S XML datamap.

Triple-S XML

Opens in browser

Datamap for Triple-S XML.

Uncle

Download to computer

Syntax formatted for Uncle software.

Uncle Tables

Opens in browser

Datamap for Uncle.

Wincross (.job)

Download to computer

Syntax file for Wincross tabulation software.

Tracking Files

All Seen Variables

Opens in browser

The record, UUID and status of all respondents that have started the survey.

Random Order

Opens in browser

Tab-delimited file showing the tracked order for all randomized attributes in your survey.

  • Was this article helpful?