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

    Can I manipulate how the responses are put into the Excel sheet?

    Asked by kerrimcdougal on February 10, 2017 at 05:28 PM

     For example, the data currently goes in row format, but I would like it to report in Excel a specific way. I would like the student's name, ID#, and grade to repeat in the first three columns and eight rows, then I would like each elective choice listed in the fourth column in the order of preference (1st Choice Elective listed first, then Second Choice Elective, etc.:

    Kerri McDougal 123456 10th  Intro to Culinary 

    Kerri McDougal 123456 10th  Band 

    Kerri McDougal 123456 10th  Audio Video 2 

    Kerri McDougal 123456 10th  Intro to Graph and Design 

    Kerri McDougal 123456 10th  Psychology

    Kerri McDougal 123456 10th  Sociology

    Kerri McDougal 123456 10th  Team Sports 

    Kerri McDougal 123456 10th  Health 

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

  • Profile Image
    JotForm Support

    Answered by Kevin_G on February 10, 2017 at 07:37 PM

    Unfortunately, you can only choose which fields will be used in the Excel generated report, there is not a way to order data and customize it as you need. 

    Here's also a guide about creating an Excel report: How-to-Create-an-Excel-Report

    You could also take a look on our other reports, you may find of them that would work as you need: How-To-Create-Form-Reports-in-JotForm

     

  • Profile Image
    JotForm Support

    Answered by Kevin_G on February 10, 2017 at 07:39 PM

    You may also take a look to the Zapier integration with JotForm and Excel, you may find the feature you need there: 

    https://zapier.com/zapbook/zaps/12670/add-new-jotform-submissions-to-excel-as-rows-in-a-table/ 

    https://zapier.com/zapbook/zaps/11158/add-new-jotform-submissions-as-excel-spreadsheet-rows/ 

    Hope this helps.