| On this page: | |
- Opening Excel exports
- Opening HTML exports
- Exporting open-ended comments, times and dates
| |
| Trouble shooting links: | | | |
|
Opening Excel Exports:
| | Step:  | Open the Download History page for the results by clicking the [View Download History] button from the Download Responses page. |
| | | 
|
| | | |
| | Step: | Click the [Download] button for the requested Export from the Export History page to open the compressed file with your decompression software. |
| | | 
|
| | | Select to open the compressed files: 
|
| | Step:  | Double click or select the Excel file to open the exports formatted for Excel. |
| | | |
| Step:  | Double click or select the export file, Sheet_1, to open in Excel. |
| | |  |
| | | |
| | | |
 Opening HTML Exports |
| | | To open the HTML export, select to "Extract all files" from the Folder Tasks menu. This will open the Extraction Wizard to open the HTML export correctly. File > Extract All... |
| | |  
|
| | Step: | Click [Download] from the Download History Page for the export. |
| | | |
| | Step: | Click Extract all files:
|
| | |
| | Step: | Click Next to open the compressed files with the Extraction Wizard. |
| | |  |
| | | |
| | Step: | Click Next to extract the files.  |
| | | |
Step: 
Click Finish to continue and open the folder containing the extracted files.
Step: 
Select the HTML file titled SurveySummary to open the Results Summary of your export. You can then click the [View] button to see the open ended questions if you have selected to export them with your summary results.
Click Next for the Sharing Survey Results
Viewing Open-Ended Responses Times or Dates in Export:
The best way to open the survey to display open-ended responses, time and date formatting correctly is to use the .csv format.
How to open CSV file in excel
When using the Excel exports, you must format the columns to display the data correctly for time and date question types. Please format the start and end date to see the minutes and seconds in results. To do so, select the column and format cells.
Format options in Excel:
Date, Time, or Custom
Viewing Minutes and Seconds with Start and End Dates:
To view the time with the start and end date, right click the column and select Format Cells; then select the "Date" Category. From the type selection, select the type that includes the time and click OK. The column will then be formatted to include the time the survey had been taken. To view the seconds, select Time from the Category menu when formatting the cells.
| Start and End Dates Don't Match! We store all start and stop dates and times in UTC (Universal Coordinated Time) (aka GMT) within the database. So, all results export in UTC which may be different than the dates and times you see when browsing responses in your account. The start date and time when browsing responses displays the local time you have set for your account, but the data exports in UTC. |
|
|
| |
Common Questions:
How do I Correlate the Respondent Number to the response in the All Responses Export?
As ranked by start date, the most recent responses appear at the top of your export. The last response received, most recent start date, is listed first in your export. For example, if the first response of your export is on row three, the response in row three will be the same response as the last respondent when you are browsing your results.
| The order in the Excel sheet is reversed. The most recent response is at the top of the list. This is the most recent person to respond to the survey and the response that opens when you click Browse Response. That means, if you have 100 responses, response #100 would be listed at the beginning of the Excel file, in row 3, but would be listed as respondent 100 of 100 respondents under Browse Responses. |
|
|
| |
Expand Columns to see details of Start and End Date in export