CanDoYa
All tools
Saved toolsYour favorites

Add to favorites

Saved in this browser only.
Private browser utility / Developer

Free CSV Filter

Runs entirely in your browser - no upload, no sign-up.

Live workspaceLocal processing

CSV source

Paste data or open a CSV, TSV, or text file.

or drop a file here
10 MB and 100,000 data rows max

Filtered rows

Load CSV data to beginYour typed filter rules and row preview will appear here.
Share this tool
csv filter / browser utility
01 / Overview

What is a CSV filter?

A CSV filter keeps or removes rows according to conditions you set on specific columns. Paste data or open a local file, combine text, number, date and boolean rules, preview the matches, then download a valid CSV containing the full filtered result. Processing stays in your browser.

02

How to use

  1. 01
    Add the CSV

    Paste CSV or TSV text, choose a local file, drag it into the source panel, or load the worked example.

  2. 02
    Check the structure

    Confirm the detected delimiter and whether the first record contains column names, then load the data.

  3. 03
    Build the filter

    Choose a column and comparison for each rule, add values, then combine rules with all or any logic.

  4. 04
    Export the result

    Review the match count and preview, copy the filtered CSV, or download every matching row as a new file.

03

Who it's for

  • Operations teams isolating orders by region, status and revenue before sharing a smaller export.
  • Analysts selecting numeric ranges or ISO date windows without writing a script.
  • Developers trimming test fixtures and log exports while preserving quoted multiline fields.
  • Researchers keeping or excluding records from a local dataset without uploading it to a service.

A global search can find a word anywhere, but it cannot express tasks such as Region equals Europe and Revenue is greater than 1,000. This filter detects each column's value type and offers the comparisons that fit it. You can require every rule or accept any rule, then switch between matching and nonmatching rows.

Quoted commas, embedded line breaks, doubled quotes and UTF-8 text are parsed without splitting valid cells. Comma, semicolon, tab and pipe delimiters are detected automatically or selected manually. Files stay on your device, and exports include every filtered row rather than only the preview page.

FAQ

Is my CSV file uploaded?

No. The file is read, parsed, filtered and exported in your browser. Its rows are not sent to a conversion endpoint or stored by CanDoYa. If the data is sensitive, you should still use a trusted device and follow your organization's local data-handling rules.

Is this CSV filter free?

Yes. You can paste or open a file, combine multiple typed rules, preview the result, copy it and download a filtered CSV without payment or an account. The browser safety limits are displayed in the widget before you load data.

How large a CSV file can I filter?

The tool accepts up to 10 MB and 100,000 data rows. Those bounds keep parsing, live rule changes and export responsive in an ordinary browser tab. For files beyond either limit, use a streaming command-line tool or database instead of splitting an export invisibly.

Can I filter CSV by multiple columns?

Yes. Add rules for any available columns, then choose All rules to require every condition or Any rule to accept a row when at least one condition matches. You can also show the nonmatching rows, which is useful for creating an exception list.

Which CSV filter conditions are supported?

Text columns support contains, equals, starts with, ends with and their common negative forms. Numeric and ISO date columns support equality, ranges and ordered comparisons. Boolean columns support true or false equality. Every type also supports empty and not-empty checks.

Does it handle commas and line breaks inside quoted fields?

Yes. Delimiters and line breaks inside a double-quoted cell remain part of that cell, and doubled quotes become literal quote characters. An unclosed quoted field or invalid text after a closing quote produces a specific error instead of a partial export.

Are CSV filters case sensitive?

Text filters are case insensitive by default, so Europe and europe match. Turn on Match case when capitalization is meaningful. Numeric, date and boolean comparisons do not use that setting because they compare normalized typed values rather than letter case.

Does the download include only the previewed rows?

No. The table preview is paged to stay readable, but Copy CSV and Download CSV include the full filtered result. The export uses standard CSV quoting, CRLF record endings and a UTF-8 byte-order mark so non-Latin text opens reliably in common spreadsheet apps.