Filter TSV Files Online

Filter rows in TSV files by column value, directly in your browser. Your data stays on your device.

How to filter TSV files

Drop your file onto the upload area. It is loaded into the in-browser engine and the first 200 rows are shown.
Pick the column to test from the Column list. It defaults to the first column in the file.
Choose an operator: =, !=, >, <, >=, <=, LIKE, IS NULL or IS NOT NULL. Type the comparison value, unless you picked IS NULL or IS NOT NULL.
Click Apply Filter. The tool shows how many rows match and previews the first 200 of them.
Click Download to save the matching rows in the same format you uploaded.

Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.

Worked example

A bike-share operator wants to review only the longer trips from one morning's log, meaning rides of 30 minutes or more.

Input (TSV)

trip_id	start_station	duration_min	member
501	Harbour St	12	true
502	Park Ave	47	false
503	Harbour St	31	true
504	Mill Rd	8	false
505	Park Ave	30	true

Settings

Column: duration_min
Operator: >=
Value: 30

Result

trip_id	start_station	duration_min	member
502	Park Ave	47	false
503	Harbour St	31	true
505	Park Ave	30	true

duration_min is an integer column, so the value 30 is compared as a number, not as text. Three of five rows match. Trip 505 is kept because >= includes the boundary; with > it would be dropped. Matching rows keep their original order and every column is carried through unchanged.

Frequently Asked Questions

Can I combine several conditions, such as region = "EU" and amount > 100?

Not in one pass. The tool applies a single condition. Download the result and filter it again for the next condition, which gives the same result as AND. For OR logic or several conditions at once, use the SQL Query tool.

How does the LIKE operator work?

LIKE matches a pattern. % stands for any run of characters and _ for exactly one, so Park% matches every value starting with "Park". Without a wildcard, LIKE behaves like =. The match is case-sensitive.

Does filtering change the original file?

No. Your file is read in the browser and never modified. The matching rows are written to a new file that you download.

Related Tools

Sort CSV Files Online

Sort CSV files by any column, ascending or descending, directly in your browser.

Count Values in CSV Files Online

Group and count rows by any column in CSV files directly in your browser. Sort by frequency or value to find the most common entries — no upload required.

Aggregate CSV Files Online

Group and aggregate CSV files by any column directly in your browser. Calculate sum, average, min, max, and count for any numeric column — no upload required.

Filter CSV Files Online

Filter rows in CSV files by column value, directly in your browser. Your data stays on your device.

Filter Excel Files Online

Filter rows in Excel files by column value, directly in your browser. Your data stays on your device.

Filter Parquet Files Online

Filter rows in Parquet files by column value, directly in your browser. Your data stays on your device.

Filter JSON Files Online

Filter rows in JSON files by column value, directly in your browser. Your data stays on your device.

TSV Viewer Online

View and inspect TSV files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.