Exporting survey results to other programs

You may very well wish to export the results of a survey to use in more powerful analytical software or to suppliment other sources of surveying. The export section is designed for this purpose.

Exports can be generated by going to the Analysis section on the left hand menu bar and selecting Export Results.

There are three types of export format, XML (eXtensible Markup Language), CSV (Comma Seperated Values) and Microsoft® Excel® format. The last two can be used natively by most spreadsheet software.

Results can also be categorised by Question or By User. That is to say that if they are by question we take each question in turn and output it's results. Results by user takes each user and displays their answers in turn. Once you have selected your options click on the Generate Report button.

If you are using Microsoft® Windows® XP Service Pack 2 or later you may be asked if you wish to Open or Save a file for XML formats, previously Internet Explorer would have opened it automatcally.

XML Exports

XML reports by User. From the example below you can see a visual grid representation of the exported XML file (this isn't the XML file itself, but a diagram of it's structure with results). You can see from this grid view that each user is segmented and then the results for each question contained within each user.

XML reports by Question. From the example below you can see a visual grid representation of the exported XML file (this isn't the XML file itself, but a diagram of it's structure with results). You can see from this grid view that each question is segmented and then the results given by each user within each question.

CSV Exports

CSV reports by User. From the example below you can see a the generated CSV file being used in Microsoft® Excel®. You can see from this file that each user's reponses are on a single row of the database and each question (and response) takes up a column. For example on Question 1 on Page 1, there are two possible responses of Option 1 and Option 2. If a user has answered Option 1 to that question the field will contains 1, if they haven't answered that question the field will contains a 0. If the question was a free text entry the field simply contains the text of the response.

CSV reports by Question. From the example below you can see a the generated CSV file being used in Microsoft® Excel®. You can see from this file that each question is segmented into groups and each persons response is listed on a single row, with the response id and the response description.

Microsoft® Excel® Exports

Excel® reports require $UsePear to be enabled in your config.inc.php file and the PEAR PHP library to be installed on your server.

XLS reports by User. The XLS export is almost identical in layout as that of the CSV format except the formatting of the page is enhanced. We have automatically calculated percentage results and totals for you for multiple choice questions. You can see from this file that each user's reponses are on a single row of the export and each question (and response) takes up a column. For example on Question 1 on Page 1, there are two possible responses of Option 1 and Option 2. If a user has answered Option 1 to that question the field will contains 1, if they haven't answered that question the field will contains a 0. If the question was a free text entry the field simply contains the text of the response.

XLS reports by Question. The XLS export is almost identical in layout as that of the CSV format except the formatting of the page is enhanced.