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

    Split data from Configurable List Widget in Excel.

    Asked by BarryPlant on October 05, 2016 at 11:44 PM

    Hi, 

     

    I would like use the configurable list widget in for the forms we use in our group.  The only issue is when we need to download the information into Excel it put all the information into 1 cell so we may have 5 different questions that need to be answered and we can't have them all in the same excel cell.

     

    Is there a way we can have use configurable list but have the information in different cells.

     

    Kind Regards 

     

    Georgie 

    Page URL:
    https://form.jotform.co/62787146562869

    configurable list list widget configurable excel different same all
  • Profile Image
    JotForm Support

    Answered by Chriistian on October 06, 2016 at 01:38 AM

    Unfortunately there is no option to automatically have the data from the configurable list stored into different cells. Each widget in the form is considered as one field, so even though the configurable list can have multiple data, it is still considered as one field, and as such these data will still go in a single cell in the Excel file. 

    The only way you can have the data into multiple cells is to manually split them after you have downloaded the Excel file. You can achieve this by using the Convert Text to Columns feature from Excel. Here's how: Split text into different columns with the Convert Text to Columns Wizard

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

  • Profile Image

    Answered by BarryPlant on October 06, 2016 at 01:40 AM

    Thanks for this, would you have happen to know a widget we could use that will allow multiple entries on on the same line where the information is split in excel automatically?

     

  • Profile Image
    JotForm Support

    Answered by Chriistian on October 06, 2016 at 01:57 AM

    Unfortunately all the widgets that allow multiple entries will have the information in one cell only. There is no widget available that lets you automatically split the information into multiple cells.

    If you want the data to be stored in multiple cells in Excel, you will have to use the regular form fields (textbox, textarea) found in your form builder.