No Login Data Private Local Save

CSV Row Filter & Query - Online WHERE Clause

6
0
0
0

CSV Row Filter & Query - WHERE Clause

Filter CSV rows using SQL-like WHERE conditions. Upload a file, paste your data, write a condition, and instantly get matching rows.

Upload CSV File
Max recommended size: 10MB
Paste CSV Data
WHERE Clause
Supports: =, !=, >, <, >=, <=, AND, OR, (), IS NULL, IS NOT NULL, LIKE '%text%', NOT LIKE, IN (val1, val2), NOT IN (...).
0 total rows, 0 matched

Frequently Asked Questions

It's a free online tool that lets you filter rows of a CSV file using a SQL-like WHERE clause. You can upload a CSV, paste data, write conditions like age > 30 AND city = 'London', and instantly see matching rows.

  • Comparison operators: =, !=, >, <, >=, <=
  • Logical operators: AND, OR, NOT
  • Grouping with parentheses: ( )
  • NULL checks: IS NULL, IS NOT NULL
  • Pattern matching: LIKE '%text%' (% matches any sequence, _ matches one character)
  • List membership: IN ('val1', 'val2'), NOT IN (...)

Column names are taken from the first row (header) of your CSV. They are case‑sensitive. Use the exact spelling from the header in your conditions, e.g., Customer Name = 'Acme' if the header is Customer Name (spaces allowed).

Use column IS NULL to match rows where the field is empty or missing. Use column IS NOT NULL for non‑empty fields. Note: the literal string “NULL” is not treated as a database NULL.

Yes, combine conditions with AND and OR, and use parentheses to control logic. Example: (price > 100 OR category = 'premium') AND status != 'cancelled'.

Absolutely. All processing happens directly in your browser. Your CSV data and filter conditions never leave your device – no upload to any server.

After applying a filter, click the “Download Filtered CSV” button that appears above the table. The file will be saved as filtered.csv.

The tool correctly parses CSV fields enclosed in double quotes, including commas, line breaks, and escaped quotes (""). Standard CSV rules are followed.
🔧 Related Tools