Data & CSV
Filter CSV rows
Keep rows matching a literal text or numeric condition.
A clear answer. Here’s how.
Text comparisons are literal and case-sensitive. Numeric comparisons require a finite comparison value and exclude blank or non-numeric cells. Uses a one-based column position and preserves row order. CSV export protects potential formulas.
See a worked example
Worked example
A fixed demonstration, separate from the values you enter above.
- CSV data
Name,Group,Score Alex,A,72 Sam,B,85 Jo,A,91
- Column position (starts at 1)
- 3
- Condition
- Number greater than
- Compare with
- 80
Example result
| Name | Group | Score |
|---|---|---|
| Sam | B | 85 |
| Jo | A | 91 |
2 of 3 rows matched.