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

    I need to separate Style, Quantity, Size, Price to make a dynamic table in Excel. How I can do this when I build my template?

    Asked by aalleexx77 on November 10, 2016 at 10:17 PM

    WHEN I CONVERT MY DATA IN MY EXCEL FILE, IT IS NOT CLASSIFIED, I CAN NOT QUANTIFY ANYTHING AND MAKE A DYNAMIC TABLE, CAN YOU HELP ME ?

    excel table and excel file
  • Profile Image
    JotForm Support

    Answered by Chriistian on November 11, 2016 at 12:24 AM

    I see that you want to separate the payment field's product data into multiple columns/cells in excel. Unfortunately that feature is currently not available. The products and details in a payment field are designed to output into one cell only in Excel. However, you can still split the data into multiple columns by using the Convert Text to Columns feature of Excel. You can follow this guide on How to Split text into different columns with the Convert Text to Columns Wizard.

    Another workaround would be to use regular fields for the product choices instead of putting the products in the payment integration. That way, when you export to excel each field will be on their own columns/cell. I checked your Shirt Order Form and I can see that you have done exactly that. Now all you need to do is to perform the calculation and pass it on to your payment integration. Please see the guides below.

    To perform the calculation, you will need to add a Form Calculation widget to your form. Please follow this guide on How to Perform Calculation in the Form?

    Then to pass it on to the payment field, you can follow our guide here: How to Pass a Calculation to a Payment Field.

    Here's a demo form so you can see it in action: https://form.jotform.com/63150716749965. You can also clone it to your account to see my setup.

    If you need further assistance, please let us know.
    Regards.