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

    How can I break out ticket information when I download submissions?

    Asked by bciwebadmin on March 31, 2017 at 12:41 PM

    I built a ticket sales form to sell four different "products". When I download the submissions in Excel or CSV, all the product data (ticket types and quantities and money collected) exports in one column, making it difficult (impossible) to total and summarize. Is there any way that the different products and totals could export into four (or more) different columns? Ideally there would be a column for the product, a column for thequantity, and then maybe even a third for the $$. 

    Page URL:

  • Profile Image

    Answered by KadeJM on March 31, 2017 at 02:35 PM

    From what I understand you're looking for a way to separate your form product details.

    We actually use to have it that way quite awhile back but, as far as I know it was changed to one cell for the opposite reason due to several complaints.

    You can split up the information with tags in an email notification but, it won't work outside that so I'm not so sure that doing so would benefit you here.

    Alternatively, you can try using an excel formula to copy and separate the data into other cells for you to then configure further.