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.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Translation of options from webform to excel

    Asked by Hans Douma 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 ?

    Page URL:
    http://www.jotform.com/form/11560113135

    Screenshot
  • Profile Image
    JotForm Support

    Answered by NeilVicente on June 24, 2011 at 05:39 AM

    Hi,

    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.


    Neil