FileGizmo — Data & CSV tools

Filter CSV rows by a column

Keep CSV rows matching a column condition with text number and empty-value filters in your browser.

Never uploadedYour file stays on this device
Drop your CSV here or click to choose a file CSV file · processed on this device

Simple by design

Filter CSV rows in three steps

FileGizmo filters CSV records by one selected column without uploading customer lists, exports, logs, or research data. Choose a column, select an operator, and enter a comparison value when required. Text operators include contains, equals, starts with, and ends with. Numeric greater-than and less-than filters reject non-numeric values, while empty and non-empty filters need no comparison value.

Text matching is case-insensitive by default and can be made case-sensitive. The original header order and source row order are preserved, so the output is predictable and ready for another spreadsheet or database step. The result summary reports rows kept and removed. A valid CSV header row is required, and malformed input produces a clear row-level message instead of partial output.

Parsing and filtering run in a dedicated browser worker. The resulting CSV uses safe formula escaping and the frozen filename/MIME contract. Review filters involving whitespace, formatted numbers, or dates because the tool compares the stored cell text rather than applying spreadsheet display formats. For multiple conditions, filter the downloaded result again or use a database query tool.

  1. 1

    Choose a CSV file

  2. 2

    Select a column operator and comparison value

  3. 3

    Filter preview and download the result

Good to know

Frequently asked questions

Which filter operators are available?

Use contains equals starts with ends with numeric comparisons or empty and non-empty checks.

Can matching ignore case?

Yes. Text filters are case-insensitive by default with an optional case-sensitive setting.

What happens to invalid numbers?

Values that are not finite numbers do not match numeric comparison filters.

Is filtering performed on a server?

No. The CSV is parsed and filtered inside a browser worker.

Learn more

Related guides

Data & CSV guideHow to clean a CSV before importing itCheck delimiters, headers, identifiers, formulas, duplicates, encodings, and row shape before importing a CSV into Excel, a CRM, or a database.