Data
Analyzer
Viewer
ConverterCSV Filter & Query
Filter, search, and query CSV/JSON files with simple filters or SQL queries. Sort, export filtered results instantly in your browser.
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 (or search all columns), 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.
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.
