← All text tools

CSV Row Filter

Keep or remove CSV rows with up to three conditions on columns, such as equals, contains, greater than, empty or a regular expression, joined by AND or OR.

  • Free
  • No sign-up
  • Works on any device

About CSV Row Filter

Pull the rows you need out of a CSV, or throw away the rows you do not want, using rules instead of manual deletion. Each of up to three conditions picks a column, a test and a value, and you choose whether all of them must match or any one of them. Tests include equals, contains, starts with, ends with, greater than, less than, empty and a regular expression. Number tests understand values such as 1,250 or $9.50, and the case can be ignored. The result shows how many rows were kept out of the total and previews them in a table.

How to use CSV Row Filter

  1. Paste the CSV and choose whether to keep or remove the rows that match.
  2. Set the first condition, and add a second or third if you need them, choosing AND or OR to combine them.
  3. Check the kept row count and the preview, then copy or download the filtered CSV.

Why use this tool?

Also known as

Frequently asked questions

How do I match rows that contain either of two words?

Use a regular expression such as red|blue on the column, or add two contains conditions and combine them with OR. Both ways keep the same rows.

What does a number test do with a cell that is not a number?

The cell never matches a greater-than or less-than test. This keeps text like n/a from being counted as zero, but it also means those rows are dropped when you keep matches.

Is the regular expression case sensitive?

Only if Ignore upper and lower case is switched off. The syntax is JavaScript regular expressions, and an invalid pattern gives an error message instead of a result.

Is CSV Row Filter free?

Yes. CSV Row Filter on Toolipedia is free to use, with no sign-up and no watermark.

Is it safe to use?

Yes. Everything is worked out in your browser, and nothing you enter is sent to our server.

Does it work on my phone?

Yes. It works in any modern browser on Android and iPhone, as well as on tablets and computers. There's nothing to install.

Do I need an account?

No. Just open the page and use the tool. There's no sign-up and no email needed.

Can I put CSV Row Filter on my own website?

Yes. Use the Embed on your site button under the tool to copy a short piece of code and paste it into your page. It is free, needs no account, and the tool keeps working inside your page.

Related tools