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.
How to display the submission data of the "Configurable List" widget in separate columns of excel spreadsheet?Asked by photobysky on April 28, 2015 at 08:46 AM
Hi We love Jotform and it has made our lives so much better. In our forms, we use a widget that collects a fair amount of information. (Time, Date, Name, class, & multiple iterations, etc).
Upon download to excel. it ALL goes to one cell (whether xls or csv)
Is there another widget that would download the info to separate cells? Or a setting we are missing....
Our account is Kat@photographybysky.com
I did check your form and found that you have added "Configurable List" widget.
Unfortunately, it is not possible to achieve your requirement. Please be noted that every question of your form will be displayed in a separate column. Example: If you have a textbox or a widget, it will always be displayed in one cell per question. Displaying it in multiple cell be be confusing as a configurable list widget can have multiple rows.
Let me send a feature request to our back end team and they should be able to figure out some solution to display the widget data in separate columns.
For now, you may like to take a look at the following thread where one of my colleague have explained a workaround solution: http://www.jotform.com/answers/526726-Separate-Values-of-Configurable-List-Widget-in-another-Excel-Sheet
Thank you sooo much for having a look at this for us! We will look at the work-around!
You are welcome.
We will get back to you as soon as we have any update form our back end team on this feature request.