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

    Configurable List: Can we split data into multiple columns in generated report?

    Asked by markcarlock on February 01, 2017 at 10:55 AM

    I have the configurable list widget on my form and when I download the submissions in excel I'm wondering if there is a way to separate each field such as item, cost, total cost, in it's own column in excel.  Right now it puts it all together so I can really get much data from the way it's laid out.  Maybe there is a better widget to use for this?  Also is there a way for the total cost to calculate automatically? 

    Page URL:
    https://form.jotform.com/70256383866162

  • Profile Image
    JotForm Support

    Answered by Mike on February 01, 2017 at 11:36 AM

    Unfortunately, we do not have any built-in option to split the Configurable List widget data into multiple columns in Excel. Some basic calculations are available within a Spreadsheet widget, but submitted data will be still in one column.

    To get separate columns and calculations you might consider using standard fields.

    How to Perform Form Calculations

    Thank you.

  • Profile Image

    Answered by markcarlock on February 01, 2017 at 12:56 PM

    Ok thanks.  Is there an option with the standard fields for the user to add another line?

  • Profile Image
    JotForm Support

    Answered by Kevin_G on February 01, 2017 at 01:14 PM

    If you need the info to be separated in columns in Excel then you will indeed need to use basic or quick fields, there is not a way to multiply these fields and you will need to add all the set of fields manually. 

    You could add a radio button, for example, and ask your user if a new set of fields will be added and then based on the answer you could show the new set of fields. 

    Here's a guide that will help you to achieve this: How-to-Show-or-Hide-Fields-Base-on-User-s-Answer

    Hope this helps.