Filter CSV rows by column

Keep the CSV rows whose selected column matches an exact value.

Text Stateless

The first row is kept as a header. Columns start at 1. Matching is case-sensitive. Formula-like output cells gain a leading apostrophe.

Quick guide

Try an example

You enter

CSV data
name,team
Ada,A
Lin,B
CSV separator
Comma
Column number
2
Exact value to keep
A

You get

name,team
Ada,A
How it works & limits

The first row is kept as a header. Columns start at 1. Matching is case-sensitive. Formula-like output cells gain a leading apostrophe.

Paste up to 1,001 rows and 100 columns, with at most 10,000 cells. Leave the value blank to match empty cells.

Related tool

CSV column extractor