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

    Separate payment field and widget data into multiple columns when exported to Excel

    Asked by USTAPNW on February 27, 2016 at 12:22 AM
    I have the same problem! I have two areas that I want to separate. One is the two-product payment area. The other is a question in the form that has four fields in a widget. I have tried to separate with the delimited method and it has not worked. In fact, I lost data; only the first product remained listed.
  • Profile Image
    JotForm Support

    Answered by EltonCris on February 27, 2016 at 12:31 AM

    Unfortunately, this is the only method that I know when separating data from a single cell into a separate column. So for now, we suggest to re-download your form submissions to Excel so you can try this method again. This should work like anybody else. Have you considered checking the video tutorial http://screencast.com/t/DWOvVgveXM4? 

    If you continue to encounter problems when separating your form data into columns, please let us know the form in question so we can provide you an example out of your form data.

    Thank you!

  • Profile Image

    Answered by USTAPNW on March 01, 2016 at 01:46 PM

    I was successful in downloading and manipulating the data to acquire reports we need. Our office will be doing this same format for eight groups in the next few months. We are wondering if JotForm could develop an output report for our needs. We are willing to pay an additional fee. The initial form developed is at: https://form.jotform.com/USTAPNW/2016_Sectionals-Adult55. If there is a possibility of that, I can send the desired output report format.  Thank you.

  • Profile Image
    JotForm Support

    Answered by david on March 01, 2016 at 03:15 PM

    I will submit a feature request to allow for separating widget and payment field data in to more than one field, however, we do not currently have a paid feature system.  New functionality is usually added based on demand.  When more users request a certain feature, it is much more likely to be added.  Though I cannot say if or when this functionality will be added, we will let you know via this thread is there is any new information regarding the request.