Filter Datasets and Spreadsheets Online
Apply logical operators to instantly filter your CSV and Excel files. Keep or remove rows based on exact mathematical conditions.
How to Filter Data
A complete guide to configuring your data pipeline.
Step 1: Selecting the Evaluation Column
After uploading your dataset into the interface, open the Filter tool. Use the first dropdown menu to select the specific column you wish to evaluate (e.g., 'Status', 'Price', 'P-Value').
Step 2: Assigning the Logical Operator
Next, define the mathematical or logical condition for your filter:
- Equals (==): Retains only rows where the cell exactly matches your input.
- Not Equal (!=): Drops rows that match your input, keeping everything else.
- Greater Than (>) / Less Than (<): Evaluates numerical thresholds. Non-numeric data in the targeted column will be automatically ignored during this mathematical comparison.
Step 3: Inputting the Comparison Value
In the final textbox, type the value you want to compare the column against. For example, selecting 'Status', 'Equals (==)', and typing Completed will instantly purge all pending or failed records from your dataset, leaving a clean matrix of completed entries.
Technical Specifications & Use Cases
Data filtering is the most frequent computational operation performed in quantitative research and business intelligence. However, processing large-scale conditional logic in standard spreadsheet software often causes memory overflow or UI freezing.
flowingTable sidesteps browser limitations by executing vectorized boolean indexing directly via the Python backend. Whether you are filtering a genomic dataset for statistical significance (e.g., P-Value < 0.05) or isolating regional sales data for financial modeling, the conditional masks are applied instantly. This ensures absolute computational accuracy and prevents the accidental data displacement commonly seen when manually hiding or deleting rows in Excel.
Frequently Asked Questions
Can I apply multiple filter conditions at the same time, such as filtering by both date and status?
The current Filter tool applies one condition at a time. To achieve multi-condition filtering, you chain two sequential filter operations: apply the first filter (for example, Status equals 'Completed'), then apply the second filter on the resulting output (for example, Revenue greater than 10000). Because each filter operation is applied to the active table in the pipeline, the final result is the intersection of both conditions — equivalent to a SQL WHERE clause with an AND operator.
What happens to cells containing non-numeric text when I apply a Greater Than or Less Than filter?
When a numeric threshold operator (Greater Than, Less Than, or their inclusive equivalents) is applied to a column that contains text values, the engine evaluates only the cells that can be successfully coerced to a numeric type. Cells containing non-numeric strings are treated as non-matching and excluded from the result automatically, without throwing an error. This behavior is intentional and prevents mixed-type columns (a common artifact in raw exports) from halting the filtering pipeline.
Does filtering a CSV file permanently delete the excluded rows from my original file?
No. The filter operation is non-destructive on your source file. The tool reads your uploaded file into an in-memory DataFrame, applies the boolean mask to generate a filtered view, and only affects the downloadable output. Your original file remains completely unchanged on your device. This means you can safely experiment with different filter conditions and download multiple output variants from the same source file without any risk of data loss.
How do I filter for rows that contain a specific word anywhere inside a cell, not just an exact match?
Use the 'Contains' operator (where available) in the operator dropdown. If your dataset requires pattern-based filtering — for example, retaining all rows where the 'Product Name' column includes the word 'Pro' anywhere in the string — the Contains operator performs a case-insensitive substring search across the column. For more advanced pattern matching, such as filtering cells that start with a specific prefix or match a complex format, you can first use the Substitute tool with a Regex pattern to standardize the column values before applying the exact-match filter.