Survey analysis

  • Profile Image
    MatthewR2
    Asked on January 04, 2022 at 05:05 PM

    Hi,

    When responders select more than one answer (via checkboxes) the csv/excel uploads all answers into 1 cell. Is it possible to separate them? On the jotform dashboard, the multiple answers are in separate colours - so there must be a way to differentiate?

    Thanks

  • Profile Image
    Kenneth_C
    Answered on January 05, 2022 at 12:31 AM

    Thank you for reaching support,

    Can you please share a screenshot of the fields you are referring to as well as the output?

    Here is how: https://www.jotform.com/help/438-how-to-post-screenshots-to-our-support-forum/.

    Please note that inputs are placed under the fields they're associated with.

    Awaiting your response.

    Best.

  • Profile Image
    MatthewR2
    Answered on January 05, 2022 at 07:49 AM

    Here's an example of the fields in jotform:

    1641386709_61d592d566e83_Screen Shot 202

    Here's what the excel looks like:

    1641386729_61d592e9dcb0d_

    Notice how the answers in jotform are separated by different colours, yet in the excel output they are bunched in the same cell. Having them output into different cells would be a lot better for analyzing responses.

    Thanks

  • Profile Image
    ashwin_d
    Answered on January 05, 2022 at 08:48 AM

    Unfortunately, no, it is not possible to display the checkbox options in a separate column of the exported Excel file.

    Since you are downloading the submissions in Excel file, I would suggest you to use Excel features to split the data of checkbox field in a separate column. You may like to take a look at the following guide should help you:   https://www.extendoffice.com/documents/excel/1786-excel-split-text-by-space.html 

    Hope this helps.

    Do get back to us if you have any questions.