How can I separate multiple selections from a checklist once exported to Excel?

  • Profile Image
    Asked on August 09, 2016 at 02:25 PM

    There's a checklist option on the form I am using. When the data is exported to Excel, all the checked options generate into one long line of text with no spaces or characters between them. How can I either a) separate out selected options with a special character or b) have the checked options show up in separate cells?

  • Profile Image
    Answered on August 09, 2016 at 04:03 PM

    Sorry, but unfortunately there is no easy way to separate the selected values of a check box in different cells. You would need to do this manually with excel formulas.

    If you like, you can create hidden fields for each selection. Using the FORM CALCULATION widget, you can capture the selected value and place it in a hidden field. Each hidden field will be placed in its own cell. This could be a workaround for you.