Exporting responses allows you to download all of your responses in a format that you can then view or manipulate on your own machine. There are currently two formats supported, HTML Table or Comma Separated Values. When exporting the values of a response, our software will first check if an answer has a value associated with it. Many question types allow you to set both an answer text (viewed and selected by the respondent) and then an optional answer value. If an answer value exists, that will be the data exported for that answer. Otherwise, our software will export the answer text that was displayed to the respondent. For any fields where a respondent has entered open ended information, those responses will be exported exactly as entered. In the case of a File Upload question, only the names of each file uploaded will be exported.
Web Page Table (HTML)
This format is excellent to use in the case where a person needs to view and interpret the exported responses. Each response item will be listed in its own column and there may be several rows of headers in order to explain fully what each column contains.
If there is no response for a specific cell, the value will be . This will render as an empty cell within the web browser or if you are parsing the HTML for other means, you can consider this an empty response value. If any HTML is entered by the user or is contained with your normal answer text or answer value, it will be escaped. This will prevent any malformed HTML from breaking the export table.
In the event that your survey contains numbered loops, the responses to an individual question will appear as a table embedded within the table cell in the order they appeared within the survey response. When that is the case, the outer table cell will contain the class "loops" attached to it.
Comma Separated Values (CSV)
This format is excellent for use by machines when you wish to parse the exported responses or import them into popular programs such as Microsoft Excel or OpenOffice.org Calc. Almost any program that is meant to handle data will be able to read a CSV file format and you can then use that program to perform further analysis of your survey response data.
In the event that your survey contains numbered loops, the responses to those questions that appear within the numbered loop will all be compressed into a single column. That questions' column will contain a CSV record of each response given to that question during the numbered loop.