What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

  • Profile Image

    Exporting check box answers in Excel does not work properly

    Asked by JChidester 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.

    excel report checkbox field
  • Profile Image
    JotForm Founder

    Answered by aytekin 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.