Filter CSV rows by a value

For isolating a useful segment inside a large export, Filter a CSV File keeps only the rows that meet the selected value.

Keep only CSV rows that match the value you need, reducing a large table to the relevant records. You get the result directly in your browser.

How to use

Bring your table into the page, either by choosing a CSV or TXT file or by typing the rows straight in.
Make sure the separator the page read matches the one your file really uses, and correct it by hand if not.
Choose the column to question, then type the value that should appear in the rows you want to keep.
Run the filter: the produced table shows only the records that answer your criterion.
Glance at how many rows came back and compare that with what you expected before using the result.

Example

To pull just the orders from one region out of a yearly export, name the column that holds the region and type the value you are after. The produced table then narrows down to the matching rows, which makes the file shorter to read and quicker to pass on.

Limits and formats

Matching is exact, so a capital letter, an accent or a stray space can hide a row you expected to see.
One value is handled per run; there is no combined condition and no numeric range.
Nothing is calculated on the rows that survive, you simply get the selection as it stands in the file.
Spot-check a few rows in the result, especially when the filtered column holds values that look alike.

Where processing happens

Filtering is done by the browser itself: no row of the table is sent anywhere and nothing survives the closing of the page.

Frequently asked questions

Can I filter on several values at once?

Not from this page: one criterion is applied per run. To cover more values, filter once, keep that result, then either filter the surviving extract again or prepare the values ahead of time in a spreadsheet.

Why are some rows I expected missing?

The value you typed probably does not match the cell exactly, because of a space, a capital letter or an accent. Open the source file, fix the wording and run the filter again on the same column.

Is my original file changed?

No. The filter builds a fresh table and leaves your source file untouched. You can go back to the original text at any time and start again with a different value as long as the page stays open.