Fidument Tools · Beta version

How do I filter CSV rows by selected columns?

Set conditions on selected CSV columns and download matching rows. The browser processes your file.

How do I filter CSV rows by selected columns?

How to use this tool

  1. Read the columns

    Choose a CSV, check the delimiter, and select Read columns.

  2. Set conditions

    Choose a column and a comparison such as Equals, Contains, or Is empty. Choose whether all or any conditions must match.

  3. Download matching rows

    Select Filter rows, check the match count, and download the CSV. Zero matches yields a header-only file.

All or any conditions?

All requires each condition to match the same row. Any keeps a row when at least one condition matches. A field containing a space counts as nonempty.

Who is it for?

  • People working with CSV exports and spreadsheets

Input

  • CSV UTF-8

Output

  • CSV

Capabilities

  • Choose a CSV, check the delimiter, and select Read columns.
  • Choose a column and a comparison such as Equals, Contains, or Is empty. Choose whether all or any conditions must match.
  • Select Filter rows, check the match count, and download the CSV. Zero matches yields a header-only file.

Limitations

  • UTF-8 CSV with unique headers up to 2 MiB, 20,000 rows and 100 columns. Up to eight conditions. Text matching is case- and whitespace-sensitive.
  • Formula-like fields may receive an apostrophe.

Example use

Keep orders with country PL and status “open” by requiring all conditions.

Questions and answers

Where is my file processed?

Your browser processes the file on your device.

Related tools

Remove CSV duplicates

Choose CSV columns to match rows. Keep the first or last record and download the cleaned file.

Split CSV by rows

Set the rows per file and download numbered CSV parts with headers in one ZIP.

Filter CSV

Check access and export conditions in the app. A product description does not grant access.