Free CSV Filter & Query Tool

The CSV Filter & Query Tool is a free online tool that filter csv rows by column conditions with and/or logic. download filtered results. It runs entirely in your browser with no installation or sign-up needed.

Equals, not equals, greater than, less than, contains, starts with, and ends with.

Yes — combine filters with AND or OR logic.

Yes, completely free.

Absolutely. The CSV Filter & Query Tool processes everything client-side in your browser. No data is uploaded to or stored on any server. Your content remains private on your device at all times.

Yes, the CSV Filter & Query Tool is fully responsive and works on smartphones and tablets. You can use it on any device with a modern web browser -- no app download required.

No account or registration is needed. Simply open the CSV Filter & Query Tool in your browser and start using it immediately. There are no sign-up walls or usage restrictions.

Simply enter your input in the provided field, adjust any settings to your preference, and the tool will process it instantly. You can then copy the result to your clipboard or download it.

The CSV Filter & Query Tool works in all modern browsers including Chrome, Firefox, Safari, Edge, and Opera. For the best experience, use the latest version of your preferred browser.

AND and OR control how multiple filter rules combine. Under AND, a row must satisfy every rule to appear, so it narrows results — for example, status equals shipped AND region equals EU returns only shipped EU orders. Under OR, a row qualifies if it matches any single rule, which widens results and is the right choice when you want several categories or regions gathered in one pass, like category equals Electronics OR category equals Hardware. A common mistake is using AND when you meant OR and getting zero matches because no row can equal two different values at once. This tool gives you a single AND/OR toggle that applies to all your rules, and the live row counter updates the instant you switch, so you can flip between the two and see which logic produces the slice you need.

The greater than and less than operators are numeric only when both the cell value and the value you typed parse as numbers — so price greater than 50 correctly keeps 100 and drops 9. If either side is not a clean number, the comparison falls back to alphabetical order, where text is compared character by character. That fallback is why a column mixing numbers with units or symbols, like "$50" or "50 kg", may behave unexpectedly, since the leading symbol or trailing text prevents a numeric reading. To get reliable numeric filtering, make sure the column holds plain numbers with no currency signs, commas, or units. Strip those out first, then apply your greater than or less than rule above and the row counter will confirm you are filtering on true numeric value.

To keep rows matching several values in one column — say every order from the US, UK, or Canada — add one rule per value and set the logic toggle to OR. Create a country equals US rule, a country equals UK rule, and a country equals Canada rule, then switch from AND to OR so a row qualifies if it matches any of them. AND would return nothing here, because a single cell cannot equal three different countries simultaneously. If the values share common text, the contains operator is an even shorter route: one contains rule can catch a partial match across many entries. You can add as many rules as you need and delete any on the fly, and the live counter shows how many rows survive. Stack your value rules above and download the combined result.

No. Every text comparison in this tool is case-insensitive, so Active, active, and ACTIVE are all treated as the same value. This applies to all seven operators — equals, not equals, contains, starts with, ends with, and the alphabetical fallback of greater than and less than. The benefit is that you do not have to know exactly how a column was capitalized to filter it; a rule like status equals shipped catches Shipped and SHIPPED too. The trade-off is that you cannot use case alone to distinguish two values, so if a dataset uses capitalization as a meaningful flag, this tool will not separate those rows. For the vast majority of real exports, where casing is inconsistent anyway, case-insensitive matching is what you want. Paste your data above and your filters will match regardless of letter case.

The download always contains every matching row, not just the preview. To stay fast, the on-screen table renders only the first 100 matching rows and shows a note when there are more, but that limit is purely visual. When you click Download, the tool writes a filtered.csv containing the header line plus all matching rows, with commas and quotes properly escaped so the file opens cleanly in Excel, Google Sheets, or any spreadsheet app. The live counter above the table — for example 42 of 500 rows — tells you exactly how many rows the export will hold before you save it. So even if the preview caps at 100, a result of thousands of rows downloads in full. Build your conditions above, confirm the counter, then download the complete filtered file.