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 customize my data export?Asked by WVUPiKapp on August 09, 2015 at 07:38 PM
Is there a way for me to rearrange the way my form submissions appear in the .csv I download?
The info is currently in the order I asked the questions, however the way I store and use the data isn't in the same order. I can't figure out a way to order the data automatically. For now i am rearranging the columns when I download them, but that is getting very tedious.
Submissions CSV rearranging rearrange
Please be noted that when your download your form's submission in excel, it displays the column in the same way your form fields are placed.
Though you can select the field you want to display in excel file but it is currently not possible to change the order of columns in excel report. To achieve your requirement, you will have to actually rearrange the questions in your form.
Hope this answers your query.
Do get back to us if you have any questions.
Thank you for your reply. I was afraid that was the case. The questions flow more intuitively the way they are, but the data is better represented in spreadsheet form in a different manner, if that makes sense. I may rearrange a few things to make it a little easier when I do import though.
I'll just add that this would be a great future enhancement :)
Otherwise, this is a great resource and we are seeing huge returns with our forms.
I completely agree with you. Allowing the columns to be rearranged in excel report be a great feature.
Let me send a feature request to our back end team. We will get back to you as soon as we have any update form them.
That would be great!
JotForm has been AWESOME for our needs. Just upgraded to Premium as we are far exceeding the responses we expected. I suspect that a simple, professional form is one reason. Keep up the great work, you've got a customer for life here!
You're welcome and thank you for the great feedback :)
If there are updates on the request, we will make sure to let you know here right away.