Loading...
Loading...
Select a column, set a condition, and extract only the rows that match. The header row is always included in the output.
The filter supports six conditions. "Equals" matches only rows where the cell value is an exact case-insensitive match. "Contains" matches rows where the cell value includes the filter string anywhere within it. "Starts with" matches rows where the cell value begins with the filter string. "Greater than" and "less than" compare values numerically, so a price column can be filtered to rows where the price exceeds a threshold. "Is empty" matches rows where the selected column has no value, which is useful for finding incomplete records.
Matching is case-insensitive for text conditions. A filter on a country column for "germany" will match rows containing "Germany", "GERMANY", or "germany" in the same way. For exact-case matching, there is a case-sensitive toggle that changes the behaviour of "equals" and "contains".
Extracting customer records by country from a full CRM export is a frequent task. Select the Country column, choose "equals", and type the target country name. The output is a CSV of just those customers, with the same headers as the original, ready for a regional team or a country-specific import.
Filtering sales data by date range requires two passes: one filter for rows where the date is "greater than" the start date, and a second filter on the output for rows where the date is "less than" the end date. This gives you a date-bounded extract without needing to write a script. For cleaner date comparison, make sure date values are in ISO 8601 format (YYYY-MM-DD) so that lexicographic comparison aligns with chronological order.
Finding incomplete records in an import-ready file is another use. Run "is empty" on a required column to pull out all rows missing that value. Fix or discard those rows before importing, rather than discovering them as errors during the import process itself.
Can I filter by multiple columns at once?
The tool filters on one column per operation. To filter by two columns, apply the first filter, download the output, load it back in, and apply the second filter.
Is the original file modified when I apply a filter?
No. The filter produces a new CSV containing only the matching rows. The original file is unchanged in your file system.
How many rows can the filter process?
The filter runs entirely in the browser and can handle files with hundreds of thousands of rows, subject to available browser memory. For files over 100 MB, performance depends on the device.