Sort an Excel file and keep the top rows
Sorting is easy; sorting and then keeping only the top ten means selecting and deleting everything below, which is where the accidents happen. Ask for both at once.
The instruction to paste
Example instruction
Keep the three rows with the largest Amount, from largest to smallest
What comes back
| Region | Product | Amount |
|---|---|---|
| EMEA | Alpha | 1200 |
| APAC | Beta | 340 |
| EMEA | Gamma | 890 |
| AMER | Alpha | 1500 |
| EMEA | Delta | 260 |
| Region | Product | Amount |
|---|---|---|
| AMER | Alpha | 1500 |
| EMEA | Alpha | 1200 |
| EMEA | Gamma | 890 |
How it works
- 01
Upload the file — .xlsx, .xls or .csv, up to 100 MB.
- 02
Paste the instruction, changing the column names to the ones in your own file.
- 03
Download the result. Whatever was cut comes back on a separate tab, so nothing is lost.
Other ways to ask
The instruction is read as a sentence, not filled into a form. These all work on the same file.
Sort by Region A to Z, and by Amount from largest to smallest within each region
Keep the top five rows by Amount for each Region separately
The rows and values in your file are never sent to an AI model — only the column headers and your instruction ever leave our servers.
Questions
Can I sort by more than one column?
Yes. Name them in priority order and say the direction for each.
What if several rows tie at the cut-off?
Say what to do — keep them all, or break the tie with a second column. Without that the file order decides.
Do the rows below the cut-off disappear?
They move to the separate tab every result carries, so you can still see what was left out.
Related tasks
See everything you can ask forTry it on your own file
Create an account, upload your spreadsheet and paste the instruction above.