How to Filter CSV Data by Value

By CSV Editor Team · Last updated: 2026-03-16

Filtering a CSV means keeping only the rows that match a rule such as Status = Active, Country = US, or Email is empty. The safest workflow is to filter by named headers, review the resulting row count, and export the filtered dataset as a new file rather than deleting rows from the original master copy.

Quick answer

  • Choose the correct column header first.
  • Pick the right condition: equals, contains, starts with, empty, or not empty.
  • Use AND for strict matches and OR for broader matches.
  • Review row counts and spot-check real records.
  • Export the result to a new CSV.

When filtering CSV data is useful

  • Creating a remediation list of rows with missing required fields.
  • Preparing a subset for CRM, email, or ad-platform import.
  • Reviewing only failed, pending, or high-priority records.
  • Auditing a column before bulk replacement or deletion.

Step-by-step: filter CSV by value safely

  1. Open the file in the Online CSV Editor and confirm the header row parsed correctly.
  2. Select the column to filter and choose a condition such as equals, contains, starts with, is empty, or is not empty.
  3. Enter the target value, such as Active, US, or @gmail.com.
  4. Add additional conditions if needed. For example, Status = Active AND Country = US creates a focused segment.
  5. Check the filtered row count and spot-check records from the beginning, middle, and end.
  6. Export the filtered result as a new CSV so your original dataset stays intact.

Example filters that teams use often

CRM cleanup: filter where Email is empty to create a remediation list for sales or operations.

Marketing segmentation: filter where Country = US AND Status = Activebefore an email export.

Support triage: filter where ticket_status = Failed or Pending to focus on the queue that needs action.

Common filtering mistakes and fixes

Filtering on the wrong column: fields like status and account_status can look similar but mean different things.

Using contains when you need exact match: broad matching can pull in unintended rows. Use exact match whenever practical.

Ignoring spaces or casing: values like Active, active, and active may need normalization before filtering.

Overwriting the original file: always keep the unfiltered source so you can revisit the logic or build another subset later.

Quick QA checklist before export

  • Correct column selected
  • Condition type matches the real intent
  • Filtered row count looks plausible
  • Spot-check passed on sample rows
  • Result exported as a separate file

FAQ

Should I filter before or after sorting?

Usually filter first to shrink the working set, then sort the matching rows for easier review.

Can I filter by partial text?

Yes. A contains rule works well for partial text, but it should be validated carefully because it can match more rows than expected.

How do I find rows with missing emails or IDs?

Use an is empty filter on the target field, then export those rows into a cleanup list.

Related guides

How to sort CSV by columnHow to find and replace text in CSVHow to remove duplicate rows in CSVCSV cleaning guide

Canonical: https://csveditoronline.com/docs/filter-csv-data-by-value