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

  • kerrimcdougal
    Asked on February 10, 2017 at 5: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 

  • Kevin Support Team Lead
    Replied on February 10, 2017 at 7: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. 

    Can I manipulate how the responses are put into the Excel sheet? Image 1 Screenshot 20

    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

     

  • Kevin Support Team Lead
    Replied on February 10, 2017 at 7: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.