Can I customize my data export?

  • WVUPiKapp
    Asked on August 9, 2015 at 7: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.

     

  • Ashwin JotForm Support
    Replied on August 10, 2015 at 1:00 AM

    Hello WVUPiKapp,

    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!

  • WVUPiKapp
    Replied on August 11, 2015 at 8:56 PM

    ashwin

     

    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.

  • Ashwin JotForm Support
    Replied on August 12, 2015 at 12:26 AM

    Hello WVUPiKapp,

    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.

    Thank you!

  • WVUPiKapp
    Replied on August 12, 2015 at 7: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!

  • Welvin Support Team Lead
    Replied 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.

    Thanks

  • iStore
    Replied on December 7, 2016 at 3:26 PM

    We also need the ability to arrange report columns and save it that way so we don't have to rearrange them every time we refresh the page.
  • BJoanna
    Replied on December 7, 2016 at 6:24 PM

    @iStore

    I have moved your post to separate thread and we will provide you an answer there shortly.

    https://www.jotform.com/answers/1006292