CSV row filter
Keep CSV records matching text or numeric conditions in a selected column.
Bookmark this page
Keep this page handy for next time.
- On a computer
- Press Ctrl + D, or Command + D on a Mac.
- On a phone or tablet
- Open your browser's menu or Share menu and look for Add Bookmark, Bookmark or Add to favourites.
A bookmark saves the page link. Save any tool results separately.
How to use this tool
- Choose an exact column heading.
- Select a text or numeric condition.
- The header and matching data rows are returned as CSV.
Things to know
- Numeric comparisons require finite numeric values. Empty or invalid numeric cells are rejected rather than coerced to zero.
- Each CSV input accepts up to 25 MiB, 100,000 data rows, 10,000 columns and 1,000,000 cells. Expanded tables also count empty cells.
- Generated CSV text is limited to 25 MiB in total, including all split files.
You might also need
More in data & csvCSV sorter
Sort CSV records by a named column while retaining all row values.
XML formatter and validator
Check XML syntax and format element structure without fetching resources.
CSV joiner
Join two CSV tables on a shared key using inner or left joins.
CSV and JSON converter
Convert CSV records to JSON and JSON records to quoted CSV.
CSV transpose
Swap the rows and columns of a CSV table, including its heading row.
CSV viewer and editor
Inspect CSV as a table and edit an individual cell by row and column.
CSV splitter
Split CSV data into smaller files while repeating the original headings.
CSV deduplicator
Remove duplicate CSV records using all columns or selected key columns.
CSV column organiser
Select, reorder and rename CSV columns.