What file formats does the Data Filter tool support?
The Data Filter tool supports both CSV and JSON file formats. You can upload files up to 10MB in size. The tool automatically detects the format and parses the data for filtering.
Filter and query large datasets with advanced conditions and conditional logic
Upload data and create advanced filters with multiple conditions
Drag & drop a CSV or JSON file here, or click to select
Supports CSV and JSON files up to 10MB
The Data Filter tool supports both CSV and JSON file formats. You can upload files up to 10MB in size. The tool automatically detects the format and parses the data for filtering.
Click the Add Filter button to create a new condition. Each filter lets you select a column, choose an operator (equals, contains, greater than, etc.), and enter a value. You can chain multiple filters together using AND or OR logic to create complex queries.
The tool provides 11 operators: Equals (=), Not Equals (≠), Contains (⊃), Starts With (↦), Ends With (↤), Greater Than (>), Less Than (<), Greater or Equal (≥), Less or Equal (≤), Is Empty (∅), and Is Not Empty (∄). These operators work with text, numbers, and empty values.
When you have multiple filters, each condition (except the first) can use AND or OR logic. AND means all conditions must be true for a row to pass. OR means at least one condition must be true. You can combine both to create sophisticated filtering rules.
Yes! The tool has three view modes: Filters (to create and edit conditions), Preview (to see the original unfiltered data), and Results (to view filtered data with search capability). Switch between these tabs to compare before and after.
After filtering your data, click the Download button to export filtered results as a CSV file. You can also click Copy Results to copy the filtered data to your clipboard in CSV format. Both options preserve your filter results.
The Filter Statistics panel displays four key metrics: Total Rows (original dataset size), Filtered Rows (results matching your conditions), Active Filters (number of conditions applied), and Pass Rate (percentage of data passing filters). These update in real-time as you modify filters.
Absolutely! All data processing, filtering, and exports happen entirely in your browser using JavaScript. No data is uploaded to servers or transmitted anywhere. Your files remain completely private and secure on your device throughout the entire filtering process.