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

    Re-arrange the fields before exporting to Excel

    Asked by dtplisney on September 18, 2014 at 08:48 AM

    Is it possible to change how fields are ordered before exporting to Excel or Google Sheets?

    fields order arrange fields
  • Profile Image

    Answered by seanmccthy on September 18, 2014 at 10:53 AM

    Hi dtplisney,

    Based on my checks, you can make changes to the order fields are being displayed in the preview section for Submission by dragging the column in the position you would like it to be. But, when the Excel file is exported, it defaults to the same order as the form. Sorry to say, I have concluded that you cannot save the sort order online before exporting files. 

    A possible workaround that you can explore is sorting your fields for the form in the desired order you would like the excel file to be exported. If not, the sort order would have to be modified after the file is exported.

     

    Thanks!

  • Profile Image
    JotForm Support

    Answered by EltonCris on September 18, 2014 at 12:29 PM

    @dtplisney 

    We do not have such feature. A workaround would be arranging your fields in the form builder before exporting your submissions so you can get the desired output when its exported to Excel. After that, you can restore the arrangement of the fields in your form whenever you want. It's either you want to restore it on the form builder (press ctrl + z) or using the revisions history. http://www.jotform.com/help/294-How-to-View-Form-Revision-History

    Hope this still helps!