Configurable List Widget: field values into separate cells in Excel

  • Profile Image
    Cammarata_Alessandro
    Asked on June 09, 2020 at 04: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.15

  • Profile Image
    Anita_K
    Answered on June 09, 2020 at 07: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.