Skip to content

CSV Filter & Sort

Filters rows with column conditions, sorts on several keys and picks the columns to keep.

Keep the rows that match conditions you build one at a time, sort on several keys, and drop the columns you do not need — then download what is left. It is the three things you would open a spreadsheet for, on a file too big to open in one.

🔒 Runs entirely in your browsercsvfiltersortquery

Drop a CSV or TSV

Read in this tab. Nothing is uploaded. Files from Korean, Japanese, Chinese and Western Excel (CP949, Shift_JIS, GBK, Windows-1252) are recognised.

How to use it

  1. Add a condition

    Column, comparison, value. Contains and is are the two you will use most; greater-than and less-than compare numbers as numbers when the column was read as numeric.

  2. Say how the conditions combine

    All means every condition has to hold; any means one is enough. With two or more conditions this is the setting that decides whether you get five rows or five thousand.

  3. Sort by clicking headers

    Shift-click a second header to sort within the first. Sorting is applied after filtering and after columns are dropped.

  4. Pick the columns to keep

    Under the disclosure at the bottom. Narrowing to four columns is often the difference between a file someone will read and a file they will not.

Common questions

Does a filtered download lose the other rows?

The download contains only what matched — that is the point — but your original file is untouched. Nothing here writes to disk.

My regex is not matching

It is JavaScript regex, unanchored, so "seoul" matches anywhere in the value. An invalid pattern is reported and that one condition is skipped while the others keep applying, so the table does not go blank while you type.

Why is 100 sorting before 20?

The column was read as text, and as text "100" comes before "20" the way "ab" comes before "b". Run the CSV cleaner’s number fix, or check whether the column has a stray non-numeric value forcing it to text.

Feed it from

CSV Viewer

Opens a large delimited file with type detection, column stats and sorting, without loading it all into memory.

Runs entirely in your browser

CSV Splitter

Splits a table by row count or by the distinct values of a column, into separate files with the header repeated in each.

Runs entirely in your browser

Workbook Splitter

Splits a workbook into one file per sheet, or one file per distinct value of a chosen column.

Runs entirely in your browser

Timezone Converter

Converts a moment across timezones and shows a shared-hours grid for scheduling across regions.

Runs entirely in your browser

Next

These accept what this tool produces, so the result can go straight in.

Quick Chart

Draws a bar, line, area, pie or scatter chart from a table with round-number axes and a legend, and exports it as SVG or PNG.

Runs entirely in your browser

CSV Splitter

Splits a table by row count or by the distinct values of a column, into separate files with the header repeated in each.

Runs entirely in your browser

SQL over CSV

Runs SQL against dropped CSV or TSV files in the browser — SELECT, WHERE, GROUP BY/HAVING, ORDER BY, LIMIT, CASE and a two-table JOIN — with the grammar on the page.

Runs entirely in your browser

CSV Viewer

Opens a large delimited file with type detection, column stats and sorting, without loading it all into memory.

Runs entirely in your browser

CSV Cleaner

Trims cells, normalises headers, fixes number and date formats and reports rows with the wrong column count.

Runs entirely in your browser

CSV Join

Joins two tables on a key column with inner, left, right or outer semantics and shows unmatched rows.

Runs entirely in your browser