How can I sort the submissions in Excel by date?

  • tevitol
    Asked on April 8, 2015 at 10:51 AM
     SECOND, in EXCEL file newest submissions were at the top, but now oldest submission is at the top, how can I change the Submission ORDER?
  • Carina
    Replied on April 8, 2015 at 10:51 AM

    To order the cells you can select all the contents and then click sort and filter > sort newest to oldest:

    The Sort & Filter button on the Home  tab Screenshot 10

     

    You can see here more details.

    Let us know if we can assist you further.   

  • tevitol
    Replied on April 9, 2015 at 2:06 AM

    Hi Carina,

    of course I know how to sort in excel

    my question is when I saved submissions to excel file from jotform submission page, before it was showing new submission at the top row of excel

    but now I am saving submissions to excel file from jottform, after saving excel file, when I open the excel file, the oldest submission at the top row

    I know it is not a big problem but why something changed without doing anything..

    thanks Carina

     

  • Carina
    Replied on April 9, 2015 at 10:03 AM

    Sorry, I didn't mean to provide useless information. Maybe it is connected with the file error of the original thread, as I was able to download a submission's list with the correct order:

    How can I sort the submissions in Excel by date? Image 1 Screenshot 20

    I will update the ticket.

    If you need further support please let us know.