Configurable List Widget: field values into separate cells in Excel

  • Cammarata_Alessandro
    Asked on June 9, 2020 at 4:44 AM

    Dear Jotform team, 

    I hope you are well, I have a form with a configurable list that is connected to an excel sheet. 
    The responses of the configurable list are all in the same cell as per screenshot below. 

    I was wondering if it was possible to have every new row of a configurable list in a new row in excel? 


    Kindest regards,

    Alessandro1591692207Screenshot 2020 06 08 at 12 Screenshot 10

  • Anita_K
    Replied on June 9, 2020 at 7:34 AM

    Hi Alessandro,

    thank you for reaching out to us.

    Unfortunately, I don't think you can change this within the integration itself.

    However, you should be able to achieve this by using the 'Text-to-Column' function in Excel: https://support.microsoft.com/en-us/office/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

    I hope this helps, please let us know if you have further questions.