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

    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

     

    Thanks!

    Page URL:
    http://form.jotformpro.com/form/50755762182964?

    JotForm excel CSV name
  • Profile Image
    JotForm Support

    Answered by ashwin_d 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!

  • Profile Image

    Answered by photobysky on April 30, 2015 at 07:30 AM

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

  • Profile Image
    JotForm Support

    Answered by ashwin_d on April 30, 2015 at 08: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!