Filter CSV data by column and value
A large CSV file often contains more records than you need for a report or import. A row filter lets you keep the records that match a condition in one field, while leaving the other values in each matching row together. This online CSV Filter creates a separate result file; it does not delete or alter the source.
Choose a column and condition
Select a column, then choose how its cell should match your search. Contains finds the value anywhere in the cell. Equals keeps exact matches, and Starts with checks the beginning of the cell. Use Is empty or Is not empty to check whether a cell has content; those conditions do not need a search value.
For example, filtering a Status column for “contains” active can keep rows with values such as Active or Inactive. Use “equals” when you want only a complete cell match such as Active.
Case sensitivity and matching
Text matching ignores letter case by default, so a search for north also matches North. Turn on Match case when uppercase and lowercase should be treated differently. The match is performed only in the selected column; it does not search other fields in the row.
Headers, blanks, and result rows
The first row is kept as the column header and is not evaluated as data. Every remaining row is checked against the chosen condition. Empty cells in the selected column can be included or excluded with the blank conditions. Rows that do not match are left out of the new CSV, while the order and contents of rows that do match are retained.
How to filter a CSV file
- Upload a
.csv,.tsv, or.txtfile, or paste delimited data. - Select the column and condition to apply.
- Enter a match value if the condition needs one, then choose whether to match case.
- Select Filter rows, review the complete result table, and copy or download the filtered CSV.
The tool detects common comma, semicolon, tab, and pipe separators. Quoted fields can include delimiters, quotation marks, and line breaks. The downloadable result is comma-separated CSV. Files up to 50 MB are read and filtered in your browser; they are not uploaded to RomitCSV.
Frequently asked questions
Does the filter keep the header row?
Yes. The first row remains the header in the result, even when no data rows match.
What is the difference between “contains” and “equals”?
Contains matches a search phrase anywhere inside a cell. Equals requires the entire cell value to match the search text.
Are text matches case-sensitive?
They are case-insensitive by default. Enable Match case to distinguish uppercase and lowercase letters.
How do I find rows with missing values?
Select the column to check and choose Is empty. Choose Is not empty to keep rows where that field contains text.
Can I filter data that uses semicolons or tabs?
Yes. The tool detects common comma, semicolon, tab, and pipe separators when it reads the input.
Will filtering change the original file?
No. It creates a separate filtered CSV for copying or downloading.
Is my file uploaded?
No. The selected data is processed in your browser.
Related tools
Sort records with CSV Sorter, clean rows with CSV Cleaner, or explore all CSV tools.