JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Split data from Configurable List Widget in Excel.Asked by BarryPlant on October 05, 2016 at 11:44 PM
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.
configurable list list widget configurable excel different same all
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.
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?
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.