Skip to main content

locacsv.comKeep Only CSV Rows That Match Your Conditions

Keep rows that match conditions

Keep Only CSV Rows That Match Your Conditions

Combine column comparisons in nested AND/OR groups to create a CSV containing only the rows you need. Processing stays in your browser.

How to useSpecifications & limits

CSV processing stays in your browser

Your files are not uploaded to a server.

File selection

Choose 1 CSV file up to 50 MiB. Its name and contents are never sent outside your browser.

Drag and drop a CSV file here

1 CSV file, up to 50 MiB

Import settings
Auto-detection covers only UTF-8 and Shift_JIS. For CSV files from mainland China, Korea, Taiwan, or Western Europe, select the matching encoding manually.

How it works

Keep only rows for the New York store

Export only rows where Store equals New York to a new CSV.

Input example

2 columns · 2 rows
Input example
StoreAmount
New York1200
Chicago850

Output example

2 columns · 1 row
Output example
StoreAmount
New York1200
The left table shows the input, and the right table shows the output.

Only matching rows are saved to a new CSV. The original CSV is not changed.

Filter CSV rows with AND/OR conditions

Export matching rows using text, numeric, or blank-value conditions.

Features

  • Use equals, contains, starts with, ends with, and blank checks.
  • Nest up to 100 conditions in as many as eight levels of AND/OR groups.

How it works

  1. Choose a CSV and review its headers and data.
  2. Set each column, type, comparison, and value, then add AND/OR groups as needed.
  3. Run, verify input, excluded, and output counts, then download.

Before you start

  • For numeric comparisons, remove thousands separators and currency symbols.
  • Blank and not-blank checks need no comparison value.
View FAQs for this tool

After filtering, select columns or sort the remaining rows.

Related guide