Filter rows based on custom criteria and conditions
Filter CSV rows by condition, keep only the rows where a column equals, contains, is greater than, or matches a pattern you define. Think of it as a WHERE clause for your CSV.
Initializing in your browser…
From a global orders file you only want EU rows with a total above 100 for a regional report.
Filter
region == "EU" AND total > 100
Output
8,431 of 52,107 rows kept; original untouched
Multiple conditions combine with AND/OR across columns, so you carve the exact subset without a spreadsheet formula or SQL. The match count is shown immediately so you can sanity-check the filter before exporting.
Filter CSV rows by condition, keep only the rows where a column equals, contains, is greater than, or matches a pattern you define. Think of it as a WHERE clause for your CSV.
Pull out rows for a specific date range, region, or status from a larger dataset.
Filter out rows with empty required fields or values outside acceptable ranges.
Yes. Add as many conditions as you need and choose whether rows must match all of them (AND) or any of them (OR).
Yes. Select the regex operator and enter a JavaScript-compatible regular expression pattern.
Rows and columns are parsed and transformed in memory in your browser. No record ever reaches a server.