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

    Configurable List widget: Ability to separate submission data into columns in excel reports

    Asked by laciezahradnik on November 17, 2016 at 11:06 AM

    HI 

    I need all of the data (including the data on the configurable lists) to be automatically put into columns when I download it in Excel.  

     

    Also, my widgets in this same form need to be reformatted.  

     

    Thanks

    Page URL:
    https://form.jotform.com/62275867952975

    excel excel file configurable list widgets data same cell separated columns columns text to columns download excel file submissions data entry
  • Profile Image
    JotForm Support

    Answered by Mike_G on November 17, 2016 at 01:13 PM

    I need all of the data (including the data on the configurable lists) to be automatically put into columns when I download it in Excel. 

    I'm afraid this can only be achieved manually.

    You can refer to the guide below to learn how to split text from a single cell to columns.

    https://support.office.com/en-us/article/Split-text-into-different-columns-with-the-Convert-Text-to-Columns-Wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7?ui=en-US&rs=en-US&ad=US

    Video tutorial: https://youtu.be/8lkEH0IHE7Y

    I will still forward a feature request regarding this to our developers. However, I cannot give you any guarantee that this will be implemented soon since they will still need to check its feasibility. You will just be notified via this thread for updates if there are any.

    Also, my widgets in this same form need to be reformatted. 

    Regarding this concern, I would like to apologize, I'm not sure I understand what you mean exactly when you said your widgets need to be reformatted. Can you help us understand your concern by giving us more information, please?

    We will wait for your response. Thank you.