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.
Working locally…
Preparing the browser worker.
Complete
Your file is ready
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
Choose a CSV file
- 2
Select a column operator and comparison value
- 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