Exporting check box answers in Excel does not work properly

  • Profile Image
    Asked on February 05, 2011 at 04:57 PM

    In one question on my "Request A Quote" form, I provided several statements from which the respondent could choose any number.

    The Excel report only lists one answer even if several were checked.

    In this type of question (choose all you wish), there needs to be a separate column for each possible answer choice so that frequencies can be determined on which choices were selected most often. It would be best to name the column heading with the answer choice and to report "Yes" under the heading for each respondent who checked that box.

    In a question that provides a list of radio-button choices (Chose one from many), a single choice would be reported in one column and the entry in the respondent row would be the answer.

    Thanks. This is a great program -- I'll be recommending it to many friends and clients. I have someone who hosts 12,000+ websites very interested in the Enterprise version.

  • Profile Image
    Answered on February 07, 2011 at 04:15 AM

    Tested this and it is not the case. It includes all checked fields, but it combines them in a single cell. So, the data is there but not separated into multiple columns as you need it. I added this to feature requests list. Thanks.