How do I ensure my payment options end up in separate columns on an Excel spreadsheet?

  • Profile Image
    vttschool
    Asked on June 07, 2017 at 08:11 AM

    I am building a summer camp registration form. Parents can choose from a number of options. As some of the programs occur on different days, parents can select more than one option. When they do, I want to ensure that the back end (i.e., Excel spreadsheet) records the data in separate columns. When I have created registration forms in the past, all the data appears in one field which makes it very difficult to then sort the information by class. Here is a sample of what I've created in the past:

    https://form.jotform.ca/70377658188269

    Unfortunately, all the data then appears in one cell, but I need different cells for each program (e.g., gymnastics should appear in one column, chess should appear in another column, etc.)

  • Profile Image
    candy
    Answered on June 07, 2017 at 09:54 AM

    Hello,

    I have cloned your form named "Vancouver Talmud Torah After School Registration Form, Term III" in order to test. As I have understood the issue, the payments appear inside one cell in the excel spreadsheet as seen below:

    As far as I understand, you want to make the payment options appear in different columns in the excel spreadsheet. Unfortunately, it is not possible currently in JotForm.

    However, you can use some Excel tools in order to separate the columns as you can see in the following guide: https://support.office.com/en-us/article/Split-text-into-different-columns-with-the-Convert-Text-to-Columns-Wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7 

    I hope this helps.

    Thanks.