Favorite places of your favorite city
Home
Add to preferred sources on Google

CSV Row Filter

Find the rows you need in a CSV file. Keep or exclude matches based on text in the columns you choose.

CSV and conditions

Filtered rows

Read a CSV table and set conditions to see the filtered rows.

Your browser processes the table on this device. Input limit: 5 MiB and 5,000,000 UTF-16 code units. Output limit: 8 MiB.

Filter a CSV table

  1. Paste a table or choose a local UTF-8 file. Set its separator and whether the first row is a header.
  2. Read the CSV, choose columns and add conditions. Choose whether all or any conditions must match.
  3. Keep or exclude the matching rows, then review and download the result.

How matches are found

Each condition uses the original column position, including when header names repeat or are blank.

Text comparisons distinguish uppercase and lowercase and keep spaces. A cell containing a space is nonempty.

Matching rows and kept rows can differ. Exclude matches keeps the remaining data rows in their original order.

Examples

Keep rows whose Status equals paid and whose Location contains Centro.

Find incomplete records by selecting Is empty for either the Email or the Order ID column.

Input and output

Use a rectangular UTF-8 table up to 5 MiB. An unquoted first record such as sep=; produces an input error because it looks like a spreadsheet separator directive.

The download uses comma-separated fields and preserves decoded text, including leading zeros and line breaks inside cells. Reopening the file here applies the input limits and separator directive rule. For example, a retained sep=; field can become the first record and be rejected when reopened here.

Local filtering

Your browser reads and filters the table on your device.

CSV row filter questions

Yes. Choose the column by the position shown beside its header.

With First row is a header enabled, the initial record is kept in the output and excluded from matching and row totals.

Yes. The CSV stores the same cell text. Choose text import in your spreadsheet if it usually converts IDs to numbers.

In Exclude matches mode, the kept rows are the data rows that did not match the selected conditions.

Sources

These references describe CSV record syntax and the positional structure of tables.

References checked on 19 November 2026.

JSON to CSV Converter

Convert flat JSON records to delimited text with first-seen columns, original number spellings and explicit empty-value rules.

Open tool — JSON to CSV Converter

CSV Column Editor

Select, reorder and rename columns from a local CSV table.

Open tool — CSV Column Editor

CSV Delimiter Converter

Convert CSV separators, preview real columns and spot import problems. Works locally with CSV, TSV and text; values remain unchanged.

Open tool — CSV Delimiter Converter

Compare Two CSV Files

Match rows by a key column and find added, removed and changed records.

Open tool — Compare Two CSV Files

CSV Duplicate Finder & Remover

Find exact duplicate CSV rows or repeated IDs. Review conflicting values, keep original data and download retained, removed and unresolved records.

Open tool — CSV Duplicate Finder & Remover

CSV Merger

Combine rows from several CSV files by exact column name. Preview alignment and download CSV with a merge report.

Open tool — CSV Merger

CSV to JSON Converter

Convert CSV text or UTF-8 files to JSON objects or arrays, keeping cells as strings without guessing data types.

Open tool — CSV to JSON Converter

CSV Splitter

Split a CSV by rows or exact file size. Keep headers and download each part.

Open tool — CSV Splitter
View all tools in this category