Filter CSV and Excel rows and columns
Filter CSV and Excel files in your browser, with no upload: keep the rows that match your conditions, such as amount greater than 100, and only the columns you need.
Process locally
Files stay in this browser session. Closing or clearing releases them.
Choose files
CSV, XLSX, JSON, one at a time
Drop files here, or
Adjust settings
Optional: Row conditions, Rows must match, Columns to keep and more
Run
Processes in this browser; cancel at any time
About this tool
Filter a CSV or Excel file down to the rows you need: orders above a given amount, customers in one city, or rows whose name contains a word. Combine up to 10 conditions, require all or any of them, and keep only the columns you need.
It runs in your browser and the file is never uploaded. Number columns compare as numbers, so 10 is greater than 9, and text conditions such as “contains” ignore letter case. A report shows how many rows were kept and removed.
How to use it
- Choose or drop one CSV, Excel (XLSX) or JSON file and check its columns in the preview.
- Under “Row conditions”, select Add row, then choose a column, a condition such as “greater than” or “contains”, and a value.
- Choose whether “Rows must match” all conditions or any of them.
- Optionally tick the “Columns to keep”; leave them unticked to keep every column.
- Pick the “Output format”, then select Run and download the result.
Formats and limits
- Input
- CSV, XLSX, JSON, one at a time
- Output
- CSV, XLSX, JSON
- Size limit
- 10 MB
- Settings
- Row conditions; Rows must match (All conditions, Any condition); Columns to keep; Output format (Same as the input, CSV, Excel, JSON); Encoding (UTF-8, GB18030); Delimiter (Comma, Semicolon, Tab, Pipe); First row is header; Worksheet
- Privacy
- Files stay in the current browser session. No file bytes are uploaded.
- Price
- Free, no sign-up
Common questions
How are numbers compared?
While “Store number columns as numbers” is on, a column whose values are all plain numbers is read as numbers, so “greater than 9” keeps 10 and 120. When the option is off, or the column holds text such as 1,000 or €5, the comparison is alphabetical.
Is “contains” case sensitive?
No. “contains” and “starts with” ignore letter case, while “equals” compares the exact value.
How do “is empty” and “is not empty” work?
They need no value: “is empty” keeps rows where the cell is empty, and “is not empty” keeps rows where it holds a value.
Can I filter by date?
Dates written as 2026-03-15 sort correctly as text, so “at least 2026-01-01” keeps the dates from that day on. Other date formats compare as plain text.
Can I remove columns without filtering rows?
Yes. Leave “Row conditions” empty and tick the “Columns to keep”.
Is my file uploaded to a server?
No. Rows are filtered in your browser, so the file never leaves your device.
Related tools
Clean CSV data and Excel sheets
Clean CSV data in your browser, with no upload: trim spaces, drop blank rows, change letter case, fill or drop missing values and set column types, with a count of every change.
CSV to Excel, Excel to CSV and JSON converter
Convert CSV to Excel, Excel to CSV, CSV to JSON or JSON to CSV in your browser, with no upload. IDs with leading zeros stay text and formulas never run.
Remove duplicates from CSV or Excel
Remove duplicate rows from CSV or Excel files in your browser, with no upload. Compare chosen columns or whole rows, keep the first or last copy, and get a count of removed rows.
Group and summarize CSV or Excel data
Group and summarize CSV or Excel data in your browser, with no upload: counts, sums, averages, minimums, maximums and distinct counts per group, like a simple pivot table.
HTML tag filter
Strip HTML tags to get readable text, or keep the tags and remove their attributes; chosen tags or attributes can stay. Scripts never run.
Text to HTML table
Turn CSV, tab-separated text copied from Excel, or text split by spaces or a custom character into an HTML table.