Filter rows in a CSV

Keep CSV records whose named column meets a comparison or text-matching condition.

freeworks offlinenothing uploaded
ToolCSV Filter
Input
Output
—
Put this on your own site

The frame below runs the same code as this page, in the reader's own browser. Nothing is sent to us, and nothing is sent to you.

Pick a dark background and the text and panels follow it, so the frame stays readable on a dark page.

Preview

How it works

The parser reads quoted records, converts numeric-looking cells, and evaluates one column with equality, ordering, or case-insensitive contains, startsWith, or endsWith operators. Matching rows are written back with the selected delimiter.

  • Comma and a header row match conventional exports.
  • The starter age > 0 condition demonstrates numeric filtering without assuming a dataset.

Worked example

Filter employees with salary above 80k
Keep only rows where the salary column is greater than 80000
Input
											name,age,department,salary
Alice,32,Engineering,95000
Bob,25,Marketing,62000
Carol,41,Engineering,110000
Dave,28,Sales,58000
Output
												name,age,department,salary
Alice,32,Engineering,95000
Bob,25,Marketing,62000
Carol,41,Engineering,110000
Dave,28,Sales,58000

When to use this

Finance exports trim transactions, CRM lists narrow regions, and log extracts select error rows.

Edge cases

  • A comma inside quotes remains one field instead of splitting the row.
  • A missing comparison column has no numeric match rather than an invented value.
  • An unsupported expression currently matches every row, so review the condition before export.

References