Translation of options from webform to excel

  • Profile Image
    Hans Douma
    Asked on June 22, 2011 at 06:40 AM

    I have a webform containing a list of options of which a user can pick more than one. When I look in the Excel generated from the submissions, I see these options as a concatenated string in a single field. This makes it rather tedious to translate this into e.g. a pivot table showing the number of respondents choosing a particular option. I would have expected each option to be a seperate column in Excel showing an "X" or so in the chosen options.

    Is there a way to do this ?

  • Profile Image
    Answered on June 24, 2011 at 05:39 AM


    It's a little odd seeing that my test resulted into a different format for the selected checkbox values.

    As you can see, the values were separated by a line break in the Excel file. I think it's your Excel's settings that removed the line breaks and made the values appear concatenated.

    Regarding your other question:

    I do not think it's possible to move the checkbox options to their own respective columns for the reason that it would be way too confusing if the options are changed. What would happen to the old options? Will they still stay in the columns or be replaced by the new options? I think the way it is right now is perfectly fine.