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

    Comma separated values

    Asked by navarac on August 21, 2015 at 03:48 AM
  • Profile Image
    JotForm Support

    Answered by beril on August 21, 2015 at 04:02 AM

    Hi friend,

    It seems like you have submitted your question too early, could you please provide us more details of your concern? We'll wait for your response.

  • Profile Image

    Answered by navarac on August 21, 2015 at 04:40 AM
    Sorry, I thought I was searching for a similar question, not submitting one. What I was looking for is a way to separate multiple values in a dropdown box or a text area (where multiple items are entered using a carriage return between each value) with a comma (or some other delimiting character) on the Excel output. Currently, everything comes across as a continuous text stream so the information is difficult if not impossible to parse. I’ve seen an example using checkboxes rather than dropdowns for multiple selections that may work, but that won’t solve my problem for the text area responses.
    Any ideas?
  • Profile Image
    JotForm Support

    Answered by Welvin on August 21, 2015 at 07:11 AM

    The selected options are wrap in the excel output by default. Isn't that what you get in the excel file? Here's the example output:


    If this output won't work for you, please try using our asmSelect Widget: http://widgets.jotform.com/widget/asmselect. This is the only widget that I've found so far that can give you a comma separated values.

    Here's -How-to-Add-a-Widget-to-your-Form.