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

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

    Asked by vttschool 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.)

    Page URL:
    https://form.jotform.ca/70377658188269

  • Profile Image
    JotForm Support

    Answered by candy 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.