 | Which Download Type or Format Should I Choose?The Download Responses page provides different options for downloading your results. The type and format of the export you choose depends on the data you need: Selecting the Export Format |
| | To choose the Download Format, open download responses and select the "Summary Report," or "All Responses Collected" export type as shown below. |
| | | | | | The Summary ReportProvides the results visible on the "Response Summary" page. The All Response Collected Report The “All Responses Collected" or entire results set includes all of your survey responses by respondents. This report type produces a single row in the export for each respondent that contains all of the response to every question by a single respondents. | | | | Optional: | Include Open-Ended Responses Select "included open-ended responses in download" to include the open-ended comments in the CSV, Spreadsheet, XML, and HTM summary exports. | Apply Existing Filter To apply an existing filter, first apply the filter to your results; then select that filter before requesting the download. With the filter applied to your results, you can select to apply the current filter to your results. |
|
How do I select the download type?
First, you'll need to open the survey results.
To open the Download Responses page, click the Analyze results icon 
for the survey and then the Download Responses button.
Available Export Formats
Summary View Export Options Explained
The Summary Report includes the results visible on the "Response Summary" page.
Optional: Include open-ended comments in select summary reports: CSV, Spreadsheet, XML, and HTM summary exports.
Format Options for Summary Results:
- CSV Format - formatted as a (CSV) file, comma separated values, to open with spreadsheet software. This export contains the summary file of the total response counts. The open-ended comments export in separate files when included.
- Spreadsheet Format - formatted to open with spreadsheet software. This export shows each question on a separate tab. The open-ended comments are shown under the question summary.
- HTML Format - provides the summary formatted in HTML, which can easily be posted on websites. Please click for assistance opening this export format.
Should I Include or Exclude Open-Ended Responses?
By default the Open-Ended Results will not be selected for inclusion in the Summary Export. To Include the Open-Ended Responses in the Summary Export, select the box to "Include Open-Ended Responses."
| |
| |
Entire Results Set - All Responses Export Type |
When you select “All Responses Collected,” the format for the complete export opens:
The Spreadsheet Format will be formatted for you to open with your spreadsheet software. It will be compressed. You will need to have decompression software like WinZip or Stuffit Expander to open the export. Learn more about 
reading your Entire Results Export
Spreadsheet Format
To export the Spreadsheet Format, select Spreadsheet Format and chose whether to have the Columns condensed or expanded from the first drop-down menu. Then chose the value for the Cells, actual choice text or numerical value, from the second drop-down menu.
Condensed versus Expanded export format:
- The condensed format exports each question into a single column. However, multiple answerer question types remain in the expanded format.
- The expanded format exports each answer choice into different columns. For example, each answer choice of a single answer question exports into a separate column. It is best for open-ended questions.
The Matrix Question formatting is the same in both export types. The main question heading exports into row one and the 'row' titles into row two. Each column choice created is listed in a separate column. For example, if the question has 5 rating choices or columns, you will see 5 columns with each rating choice indicated. For additional help reading your exportExplanation of Cell Values:
The Actual Choice Text exports your results with the answer choice text for the answer selections made. The Numerical Value assigns a number value to each answer. You can then access the Excel file to determine those number values and how they correlate to the actual survey answer. (Answers for row 1 in a matrix will be given a value of 1 and so on.) To see how to correlate the respondent number with the response
Apply Existing Filter
 | By default, your results are set to export completely, without the filters applied. To apply an existing filter when exporting your data, first apply the filter to your results; then select that filter before requesting the download. With the filter applied to your results, you can select to apply the current filter to your results.
 Use Current Filter Named "My New Filter" |
|
Request Download
Enter an Email Address to send the Results and click [Request Download] for the download to process, it is not necessary to enter and email address. This will open the Download History Page. To return to the Download Page, click [Back to Downloads].
The downloads are compressed files. You will need to have decompression software like WinZip or Stuffit Expander to open exports.
If the link delivered to your email does not work, please try opening the file directly from the Down Load History page. To do so, click the [View Download History] button, top right of the download request page.
Next for assistance opening exports.
| | Trouble shooting links: | | | - File is blank or seems corrupted - The Downloads are Compressed. Use decompression software like WinZip or Stuffit Expander to open the export.
- Auto-Date issue, when responses open in date format instead of the numerical values entered for response.
- Excel opens multiple files: Please note that if the exported data cannot fit in less than 255 columns, it will be split into multiple files.
|
|