How to separate submission fields in excel sheet?

  • Profile Image
    Ernest DeBose
    Asked on November 18, 2016 at 11:20 AM

    See attachment

     

    When I download a excel spread sheet these text boxed are all in the same column. I want each child, gender and age in separate columns.

  • Profile Image
    Nik_C
    Answered on November 18, 2016 at 12:15 PM

    Since you are using multiple text boxes widget, that field comes out as one field in excel. I'm not sure how you want that field to show, but did you consider using regular text fields because they will map in excel properly then:

    And this is how it will show in Excel:

    Because each field is then integrated independently with Excel so it will appear in a separate cell.

    Hope this helps.

    If you have further questions please let us know.

    Thank you!