How to display the submission data of the "Configurable List" widget in separate columns of excel spreadsheet?

  • photobysky
    Asked on April 28, 2015 at 8: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

     

    Thanks!

    Page URL: http://form.jotformpro.com/form/50755762182964?
  • Ashwin JotForm Support
    Replied on April 28, 2015 at 11:30 AM

    Hello photobysky,

    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!

  • photobysky
    Replied on April 30, 2015 at 7:30 AM

    Thank you sooo much for having a look at this for us! We will look at the work-around!

  • Ashwin JotForm Support
    Replied on April 30, 2015 at 8:51 AM

    Hello photobysky,

    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.

    Thank you!

  • rugbynit
    Replied on April 19, 2017 at 10:12 AM

    Any solution to this? I love the Configurable List Widget (easier than individual fields) but really need the data collected using this widget to end up in separate cells. Or at least an easy way to get it into separate cells.

     

    Thanks!

  • Ashwin JotForm Support
    Replied on April 19, 2017 at 10:34 AM

    Hello rugbynit,

    I have moved your question to a new thread so that we can address it separately. You will be answered in the following thread:  https://www.jotform.com/answers/1123133

    Thank you!