Can I customize my data export?

  • Profile Image
    WVUPiKapp
    Asked 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.

     

  • Profile Image
    ashwin_d
    Answered on August 10, 2015 at 01: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!

  • Profile Image
    WVUPiKapp
    Answered on August 11, 2015 at 08: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.

  • Profile Image
    ashwin_d
    Answered 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!

  • Profile Image
    WVUPiKapp
    Answered 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!

  • Profile Image
    Welvin
    Answered 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

  • Profile Image
    iStore
    Answered on December 07, 2016 at 03: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.
  • Profile Image
    BJoanna
    Answered on December 07, 2016 at 06: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