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.


  • Profile Image

    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.

     

    Page URL:
    http://www.wvupikapp.org/update-info.html

    Submissions CSV rearranging rearrange
  • Profile Image
    JotForm Support

    Answered by ashwin_d 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

    Answered by WVUPiKapp 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
    JotForm Support

    Answered by ashwin_d 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

    Answered by WVUPiKapp 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
    JotForm Support

    Answered by Welvin 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