Filter an Excel file by a column value
AutoFilter hides rows rather than removing them, and the moment the condition spans two columns you are writing a helper formula. Describe the condition instead and get a clean file back with only the rows you wanted.
The instruction to paste
Example instruction
Keep rows where Region is EMEA (case-insensitive) and Status is not cancelled
What comes back
| Region | Product | Amount | Status |
|---|---|---|---|
| EMEA | Alpha | 1200 | paid |
| APAC | Beta | 340 | cancelled |
| EMEA | Gamma | 890 | overdue |
| AMER | Alpha | 1500 | paid |
| emea | Delta | 260 | cancelled |
| Region | Product | Amount | Status |
|---|---|---|---|
| EMEA | Alpha | 1200 | paid |
| EMEA | Gamma | 890 | overdue |
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.
Keep rows where Amount is over 500 and Status is either paid or overdue
Remove rows where Region is empty, and keep the rest
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
Does the case of the text matter?
Only if you want it to. Say "case-insensitive" and EMEA, emea and Emea are all treated as the same value; leave it out and the match is exact.
What happens to the rows that did not match?
They come back on a separate tab of the same workbook. You do not have to ask for it — every result is built that way, so a condition that was too aggressive costs you nothing.
Can one instruction combine several conditions?
Yes. AND and OR in any combination, across as many columns as you need, in one sentence.
Related tasks
See everything you can ask forTry it on your own file
Create an account, upload your spreadsheet and paste the instruction above.