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

    Separating products data into separate columns in excel

    Asked by Steve Breeden on September 22, 2014 at 03:03 PM

    We are currently running a Homecoming event with many single events held within it. http://www.jotformpro.com/form/41793566198975. Currently, it is dumping all the individual event information under one column of cells called "Events: Products. This means we have to look by hand to see which events the customer is signed up for and how many are attending each event. I need this information to be listed separately by each event and number attanding each event. Can this be done?

    This is a re-post of a comment on How to Create an Excel Report?

  • Profile Image
    JotForm Support

    Answered by Mike_T on September 22, 2014 at 04:08 PM

    Unfortunately, this is not currently possible to split the products data in JotForm. However, we do have plans to add that option at some point. I have attached a feature request ticket to this thread to make sure that you will be updated once that option is available.

    In the meantime, you might consider a work around from the following thread:

    How to separate payment product data into separate excel columns

    Thank you.