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.
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
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
You may also take a look to the Zapier integration with JotForm and Excel, you may find the feature you need there:
Hope this helps.