|
We provide you with the ability to download the Raw Data in a CSV format (which can be imported into Excel spreadsheet). You can then create charts and do detailed analysis offline with your results.
Go To:
- Login » Surveys » Reports » Reports
- The Excel file will be emailed to the email address specified under your User Profile (as an attachment). You can also download it from the Download Center page.
| Screenshot |
 |
When saving/downloading the file offline please rename the file.
What different options are available for downloading?
Following are the options available:
- Include Open-Ended Text Data: When enabled Open-Ended Text Data is included in the file. This option is enabled by default.
- Include Raw Data: A separate Raw Data sheet is included in the Excel file. This option is enabled by default.
- Display Question Codes instead of Text: Check this option if your question has large amount of text or includes Images/HTML. Instead of Question Text Question Codes will be downloaded for easier understanding of the Reports.
- Display Answer Values: By default answer option text / values are not included in the reports. To download answer option text enable this option.
- Report Options: You can either download the entire data set along with analysis or only the Overview Analytics.
- Data Filter - Time: You can filter the report based on time so data for only a particular time period is included.
- Data Filter - Response Status: You can download data based on the Response Status.
The downloaded file does not contain Text Data
Please make sure you select the check box for : Include Open-Ended Text Data>
The downloaded file does not contain Raw Data / Individual Responses
Please make sure you select the check box for : Include Raw Data
I get an error when opening the file in Excel
Excel has certain limitations such as:
- Column Limit: 255
- Row Limit: 64k
- cell contents (text): 1,024 Characters
In addition to this there are also other limitations because of which excel may be unable to load the file. The solution for this problem is to download a CSV-Raw Data file or the SPSS (.sav) file use that file.
SurveyConsole cannot do anything about these limitations. These are limitations imposed by Microsoft/Excel not SurveyConsole.
| 
