Filter & Extract
Pull only the rows you need from a CSV or Excel file. 14 operators, AND/OR logic, and an optional second file with the rows you filtered out (Pro).
By Operelio team
On this page7
What it does
Filters your file down to rows that match one or more rules. The output contains only the matching rows. On Pro, Team, and Agency, you can also get a second file with the rows that did not match.
Available operators
An operator is the comparison the rule runs against the column you picked. Each rule has one column, one operator, and one value (or two values for between). Pick the operator that matches the question you're asking. For example, "is this row's country the UK?" uses equals, while "does this email end in .com?" uses ends with.
| Operator | Example | What it checks |
|---|---|---|
| equals | city equals "London" | Cell matches the value exactly. |
| does not equal | status does not equal "closed" | Cell does not match. |
| contains | email contains "@gmail" | Value appears anywhere in the cell. |
| does not contain | notes does not contain "test" | Value is absent. |
| starts with | phone starts with "+44" | Cell begins with the value. |
| ends with | domain ends with ".com" | Cell ends with the value. |
| is blank | company is blank | Cell is empty or missing. |
| is not blank | email is not blank | Cell has a value. |
| greater than | revenue greater than "50000" | Numeric comparison. If both sides are non-numeric (e.g. text codes), falls back to A-to-Z order. Strip currency symbols first for accurate numeric compare. |
| less than | age less than "18" | Numeric comparison. Same A-to-Z fallback as greater than when values aren't numeric. |
| between | score between "70" and "100" | Inclusive range. Matches values from the low number up to and including the high number. Enter two values (low and high). Works with numbers; for ISO dates (YYYY-MM-DD) it works with text too. |
| is one of | country is one of "US, UK, DE" | Cell matches any value in a comma-separated list. To match values that contain commas, use multiple equals rules joined with OR. |
| is not one of | source is not one of "test, demo" | Cell does not match any value in the list. Same comma caveat as is one of. |
| matches pattern | sku matches pattern "^[A-Z]{2}-\d{4}$" | Advanced patterns, written in standard pattern syntax. Pro only. Maximum 500 characters per pattern. Invalid patterns are skipped and reported on the results page. |
AND / OR logic
When you add multiple rules, you choose how they combine. With AND, a row must match every rule. With OR, a row matches if any rule is true.
On Pro, Team, and Agency, you can group rules into nested groups. Each group has its own AND/OR logic, and groups themselves combine with AND or OR. This lets you build rules like: (country is US OR country is UK) AND (revenue greater than 10000).
How to use it
Upload your file
Any supported format.
Add a rule
Pick a column, choose an operator, and enter a comparison value.
Add more rules
Free lets you add up to 3 rules joined with AND or OR. Pro removes the cap and adds nested rule groups for more complex logic.
Preview
See the count of matching vs. non-matching rows before running.
Run
Click Run. Download the filtered file.
Non-matching export (Pro)
In the Output section, tick "Also output the rows that don't match as a second file" to get a second download with every row that did not pass your filter. This is useful for splitting a file into two groups based on a rule, like separating US customers from everyone else. Available on Pro, Team, and Agency.
What the results show
The results page shows: total rows in the original file, rows that matched your filter, rows that did not match, number of rules applied, and the logic used (AND/OR). The Rules applied list renders each rule with its column, operator, and value so you can confirm what ran. If any pattern was invalid or over the 500-character cap, a warning banner lists the rules that were skipped.
Frequently asked questions
Is matching case-sensitive?
By default, no. Matching is case-insensitive. You can toggle case sensitivity on if needed.
What plan do I need?
Every operator except advanced patterns is free, plus AND/OR logic. Free gets up to 3 rules. Pro, Team, and Agency add unlimited rules, advanced patterns, nested rule groups, and a second file with the rows you filtered out.
Ready to get started?
Upload a file and run your first transformation. Free, no credit card required.