Export to Excel

What this feature is, why you should use it and when

Step by step implementation of this feature

This section explains what the "Export to Excel" is and why you should use it

What: This advanced feature allows you to export your survey results into Excel.

Why: This feature is used to export your survey report into Excel.

We are about to show you step by step how to implement this feature

To export your survey results into Excel click the Publish button next to the appropriate report and then:

1. Select the 'Export to Excel' option.
2. Select export options:
   • Select the 'Export labels only' to export the report with labels only.
     
   • Select the 'Export values only' to export the report with values only.
     
   • Select the 'Export values and labels' to export the report with both values and labels.
     
     
   • Select the 'Include Unique Survey URL' to export the unique survey URL of each respondent.
   • Select the 'Include links to Reports By Respondent' option to export link to 'By Respondent' report of each respondent
   • Select the Show Respondent Overall option to show respodents' actual sequence numbers within the report. This option is commonly used if you filter responses but need to keep their real sequence numbers.
   • Select the 'Export summary' option to export the total information on your survey report.
3. Click the Export To Excel button.
4. When the dialog box pops up click Open to open the document in Excel or click Save to save it in Excel format (.xls) to your computer.

While exporting survey report to Excel, the data will be arranged in the following way:

1. Each response (one respondents answers to all survey questions) appears in one row.
   Note:
   You can export reports to Excel that contain more than 256 columns; however, such reports are divided into several Excel spreadsheets.
2. The sequence of columns will be as follows:
   • 1st column : the respondent's sequence number;
   • 2nd column: the date and time the survey was submitted;
   • 3rd column: respondent's email address (if the survey was distributed via our email system and was not anonymous);
   • starting from the 4th column the sequence of columns is the same as the order of questions and answer choices in the exported report.
3. The number of columns used for each question depends on question type, number of answer choices, answer labels and values set.
   Accordance of questions and columns will be as follows:
   • 'Multi-Line Text Response' - one column per question. The column contains response text.
   • 'Single Line Text With Pre-Format Options' - a column per answer field. Each column contains corresponding response text or numeric value.
   • 'Compare One Against Another' - a column for each answer choice. The number in the column reflects how many times this answer choice has been selected.
   • 'Rate Different Items Along The Scale Of Your Choice' - a column per answer choice. Depending on the export options it shows label or value of the selected scale item.
   • '3D Matrix' - a column per answer choice. The heading of the column contains the matrix row and column names. For example, in the 'Goods - Prices' heading, 'Goods' is the name of the matrix row and 'Prices' is the name of the matrix column.
     The cells of 3D Matrix will be exported accordingly to their format:
     • 'Pick One', if the radio button has been selected the column will contain label or value depending on the exporting options, otherwise it will be empty.
     • 'Check All That Apply', if the check box has been selected the column will contain number '1', otherwise it will be empty.
     • 'Dropdown Box', if the answer has been selected the column will contain the order number of the selected answer, otherwise it will be empty.
     • 'General', if the text field has been filled in the column will contain the text, otherwise it will be empty.
   • 'Pick One or 'Other'' And 'Dropdown Box' - one column per answer. This column contains text of the selected answer choice.
   • 'Check All That Apply' And 'List Box' - a column per answer choice. If the answer choice has been selected, the column will contain text of the answer choice, otherwise it will be empty.
   • 'Numeric Allocation' - a column per answer field. Each column contains corresponding numeric value. Additional column is exported for the total sum of values.