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

    Is there a way to export the information on separate pages of a survey to separate rows in a spreadsheet?

    Asked by WCACArtsEd on October 25, 2016 at 01:53 PM

    I created an ordering form for teachers who need art supplies to teach their classes.  Each page of the survey is a different item.  My goal is to upload the info from the forms so that I get each item's info (each page of the survey) on a separate row.  When I tried uploading the data, it put the entire form data on a single line.

     

    Example of each page:

     

    What is the item you want to order:

    What class is it for:

    How many do you need:

    Price:

    Url of where to purchase:

     

    Ideally, I would like to gather this data like this, where each ROW represents info gathered from a different page of the form:

     

    column 1               column 2                        column 3         column 4         column 5

    Pencils              drawing class                        6                    $5                 www.amazon.com

    Paper               drawing class                        1                    $10                 www.amazon.com

    Charcoal           drawing class                        2                    $3                 www.amazon.com

     

     

    Anyone have any ideas?

    Page URL:
    https://form.jotform.com/62974653496169

    survey rows information in
  • Profile Image
    JotForm Support

    Answered by KadeJM on October 25, 2016 at 04:50 PM

    If I am understanding you correctly you mean that you want to reformat how your submission data is displayed and viewed in a spreadsheet.

    It seems to me that you want to have it stacked only showing the relevant data in your spreadsheet?

    The way it functions for excel currently is each column in your form is for your fields then each subsequent submission you receive will fill in your rows with the answers and there's not really a way to customize it unless you use a formula or copy and paste to change it.