Re-arrange the fields before exporting to Excel

  • Profile Image
    dtplisney
    Asked on September 18, 2014 at 08:48 AM

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

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