Forum Discussion

livliv's avatar
livliv
Copper Contributor
May 02, 2026

Automatically sort from newest to oldest date

I have an excel sheet that imports my leads that are applying so I can keep track and sort them. The date that they applied also goes into the sheet. right now, when i click to import a lead, it automatically puts the newest on the bottom. I can click to sort by newest to oldest, but I have to do that every time I import leads. Is there a way that I can make the newest leads always go to the top when I import them? 

excel
Formulas and Functions

2 Replies

  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    May 04, 2026

    Another option is to accept the input data however it arrives and then use a formula to sort, filter or otherwise transform the raw data.  Calling the data 'table' and assuming you wish to sort descending based upon the first column

    = SORT(table,1,-1)

     

     

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    May 03, 2026

    That depend on how you import them. With PowerQuery you can connect to the data source and perform all sorts of transformation step, one of which could be to sort by date in descending order. Output the transformed data to Excel and you'll not have to resort again.

    But, having said that, is it really that much effort to sort by date manually? How often do you need to do that?