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

    Is there a way to separate fields of the Configurable List widgets in reports?

    Asked by bkbarnes on July 19, 2016 at 10:52 AM

    In our form we have a section entitled "family info" in which they add several bits of information...

    First Name, Last Name, Gender, Age, Volunteer Area

    When I run an Excel or CSV report all that information appears in one column on the report.   I need to be able to separate them into different columns.  Is there a way to do this, or rework the form to allow this.  You will notice that I also need to ability to dynamically add for "family members" as needed.

     

    Thank you,

    Bryan

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

    Reports csv report excel CSV Grid report
  • Profile Image
    JotForm Support

    Answered by Jan on July 19, 2016 at 02:54 PM

    I believe you are referring to the Configurable List widget. As I understand, you want to have a separate columns for each form field in the Excel Report. 

    Unfortunately, this is not possible in Excel or Google Sheets. The generated Excel file will create a column or a single cell for each form field. If you want to split it up into multiple columns/cell, please try using the Text-to-Columns function in MS Excel. Here's a related link: https://support.office.com/en-us/article/Split-text-into-different-cells-30b14928-5550-41f5-97ca-7a3e9c363ed7

    The Configurable List widget will show up in a table separated by columns if you use the Grid Report. Please check this guide on how to create a Grid Report.

    If you have any questions, let us know. Thank you.