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 can I export my data from my jotform in the format I require?

    Asked by Suzuki98 on June 08, 2017 at 04:24 PM

    Hello, 

    I have a jotform that does the following:

    - Registers families for camp and gathers generic information per family such as family address/phone number/which of the 3 accommodations they wish to stay in, etc.

    - Registers each child in each family and gathers specific information per each child, such as what instrument they play, what music piece they play, can they read music, etc.

    I have not tried it yet, but what I guess when I export the jotform data to xls (Excel) I will get a spreadsheet that contains columns for all the entered information and one row for the one registration?

    What I need is an Excel spreadsheet that contains one row for each kid that is registered and all the same family data (address/phone number/accommodation/etc) can be repeated for each kid in the family.

    Any suggestions on the best way to create the xls to achieve what I need?  I am hoping to not need to split this into 2 different jotforms: one for generic info (filled out once per family) and once for student specific info (filled out one per kid).   It is easier for parents if they only go to one jotform.  (But maybe it is possible to embed a form within a form?)

    In any case, please let me know what options I have to create the xls we need.  (As we need to have an xls where we can sort on instruments or sort on reading level, etc... and so need 1 kid per row.)

    Thank-you!

     

    Page URL:
    https://www.jotform.com/build/71400751036142

  • Profile Image
    JotForm Support

    Answered by david on June 08, 2017 at 06:05 PM

    When exporting form data each column is populated with a form field in the order the fields are in the form.  Each submission will be on its own row with the field data populated into each column.  If you need one kid per row, you would need one submission per child.

    https://www.jotform.com/help/44-How-to-Export-Form-Data-to-Excel

    This is essentially the same format in which the data is stored in your JotForm account:

    https://www.jotform.com/help/269-How-to-view-Submissions