CSV Filter & Query

About CSV Filter & Query Tool

CSV Filter & Query Tool is a powerful online data filtering tool that lets you search, filter, sort, and query CSV and JSON files. Use simple filters with dropdown options or write SQL queries for advanced data analysis—all in your browser without uploading data to a server.

What filtering options are available?

The tool offers two filtering modes: Simple Filter (with search text, column filters, operators like contains/equals/starts with, and sorting) and SQL Query (write custom SQL queries for complex filtering, aggregation, and joins). Both modes work on the same dataset and can export results to CSV or JSON.

How do I use the Simple Filter?

Simple Filter provides intuitive dropdowns: select a column, choose an operator (contains, equals, starts with, etc.), enter a value, and apply sorting if needed. You can also use the search text field to find rows containing specific text across all columns.

Can I combine multiple filter conditions?

Yes. The Simple Filter supports stacked conditions: click 'Add Condition' to add as many column + operator + value rows as you need, then choose Match ALL (AND) so every condition must pass, or Match ANY (OR) so a row passes if it matches at least one. For example: status = active AND region = EU AND amount > 1000, or tier = gold OR tier = platinum. The global search text is always applied as an additional AND filter. Greater/less comparisons detect numbers and dates automatically and fall back to lexical order otherwise.

How do I write SQL queries?

Switch to the SQL Query tab and write standard SQL queries. Your data is available as a table named 'data' with column names from your CSV headers. Example: SELECT * FROM data WHERE age > 18 AND city = 'New York' ORDER BY name. The tool uses AlaSQL for SQL processing.

Is my data secure?

Yes. All filtering and querying happens locally in your browser using JavaScript. Your files never leave your device, ensuring complete privacy for sensitive datasets like customer lists, sales data, or confidential records.

What file formats are supported?

CSV Filter supports CSV files (with various delimiters: comma, semicolon, tab, pipe) and JSON files (arrays of objects). Both formats can be filtered, queried, and exported to either CSV or JSON format after processing.

Can I export filtered results?

Yes. Once you've applied filters or run a query, use the Download CSV or Download JSON buttons to export only the filtered results. This is useful for creating subsets of large datasets or extracting specific records for further analysis.

Are there row limits or performance considerations for large files?

Filtering and querying run on your full dataset entirely in your browser, so the practical limit depends on your device memory rather than a server cap. For responsiveness, the results table previews up to the first 500 matching rows, but Download CSV and Download JSON always export the COMPLETE filtered set, not just the preview. Quoted fields with embedded commas, newlines or quotes are parsed per RFC 4180, and the delimiter is auto-detected (or you can pick comma, semicolon, tab or pipe).

Which SQL features does the query tab support?

The SQL tab is powered by AlaSQL and runs entirely in the browser. Your data is exposed as a single table named 'data' (column names come from your CSV/JSON headers), so there is no second table to JOIN against. Supported queries include projections (SELECT name, age FROM data), filtering (WHERE), ordering (ORDER BY), LIMIT, aliases (SELECT price AS amount), and aggregation with GROUP BY plus functions like COUNT, SUM, AVG, MIN and MAX (e.g. SELECT city, AVG(price) AS avg_price FROM data GROUP BY city). The result table and exports adapt to whatever columns or aggregates your query returns.