Skip to main content

CSV filtering problem

Filter CSV Rows by Value Without Missing Matches

Filter CSV records using explicit text, numeric and date rules while preserving headers and documenting excluded rows.

Use the matching tool

Filter Rows

Open Filter Rows

What the error actually means

Filtering fails when displayed values differ from stored text, case and whitespace are inconsistent, or numbers are compared as strings. A reproducible filter states the column, operator, normalization and treatment of blanks.

Likely causes

  • Case or trailing spaces prevent an exact match.
  • Numeric values contain symbols or grouping separators.
  • Dates are compared as strings.
  • Blank and missing values are treated as equivalent without review.

Explicit filter rule

Problem

Keep rows that “look active”

Correct pattern

Trim status, compare case-insensitively to active, and report blank statuses separately

A safe repair workflow

  1. 1Profile distinct values in the target column.
  2. 2Choose the correct comparison type.
  3. 3Apply the filter to a copy.
  4. 4Save or count excluded records for reconciliation.

How to verify the result

A file that downloads successfully is not automatically a correct file. Check the result at both the structural and business-data levels:

  • Included and excluded counts sum to the source.
  • Boundary values behave as intended.
  • The header appears once.
  • A sample of excluded rows confirms the rule.

Read the deeper guides

How to Clean CSV Data Without Hiding the Original ProblemsLearn practical techniques to clean messy CSV files. Remove duplicates, fix formatting, and standardize data without Excel crashes or complex scripts.How to Prepare CSV Files for Python PandasPrepare CSV files for reliable pandas imports by making encoding, delimiters, nulls, dates, identifiers, and column types explicit.