- WVUPiKappAsked 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.
- JotForm Supportashwin_dAnswered on August 10, 2015 at 01:00 AM
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.
- WVUPiKappAnswered on August 11, 2015 at 08:56 PM
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.
- JotForm Supportashwin_dAnswered on August 12, 2015 at 12:26 AM
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.
- WVUPiKappAnswered on August 12, 2015 at 07:40 PM
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!
- JotForm SupportWelvinAnswered on August 13, 2015 at 12:18 AM
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.
- JotForm SupportBJoannaAnswered on December 07, 2016 at 06:24 PM
I have moved your post to separate thread and we will provide you an answer there shortly.