ZapKit

CSV sort and filter

Pull out just the rows you need from a big export, in the order you need them, without opening a spreadsheet.

What is a CSV sort and filter tool?

A CSV sort and filter tool selects the rows of a table that meet your conditions and puts them in order, like a spreadsheet's filter and sort buttons but without needing a spreadsheet. It's handy for big exports, quick questions and preparing a subset to share.

Add conditions on any column, such as contains, doesn't contain, is, starts with, ends with, greater or less than, or empty, and choose whether rows must match all of them or any. Then sort by up to two columns in either direction. The matching row count updates as you type, and the result downloads as a new CSV.

How to use the CSV sort and filter

  1. 1.Paste or open the CSV

    Headers in the first row become the column choices.

  2. 2.Add conditions

    Up to eight, matching all or any of them.

  3. 3.Sort and download

    Order by one or two columns, then save the result.

Example: low-stock products

A six-product inventory, filtered to stock below 10 and sorted by price, highest first:

Standing desk
24,999, stock 3
Office chair
8,999, stock 7
LED strip
799, stock 0

Three items to reorder, most valuable first.

Comparisons that behave

Text conditions ignore capitals, so "pune" finds Pune. Greater-than and less-than compare numbers as numbers, including values with thousands separators or currency symbols, and fall back to natural text order for anything else, so ISO dates such as 2026-09-03 compare correctly too.

Sorting is natural as well: 2 comes before 10, and item9 before item10. Empty cells always go to the bottom whichever direction you choose, so they never crowd the top of a report.

Frequently asked questions

Can I combine conditions with OR?

Yes. Switch Match to Any condition.

Does it filter dates?

Yes for dates written year first, like 2026-11-16. Other formats compare as text.

How do I find blank cells?

Use the condition is empty on that column.

Is my data uploaded?

No. Filtering runs locally.

More Developer tools