Query CSV with SELECT, WHERE & ORDER BY
Select, filter, sort, and limit CSV rows with SQL-like syntax
Use a focused SQL-like syntax to select columns, filter rows, order the result, and apply a row limit to one CSV file. Queries use the table name data, for example: SELECT name, email FROM data WHERE status = "active" ORDER BY name ASC LIMIT 100.
This is a lightweight browser query tool, not a full SQL engine. It does not implement GROUP BY, aggregate functions, subqueries, or JOIN. Use CSV Pivot for grouped summaries and CSV Joiner to match two files by key.
Drop your file here or browse from your device
Accepts CSV, TSV, TXT. Maximum input: 10 MiB. Files above this hard limit are rejected before local processing.
How to Use
- Upload or paste one CSV file
- Write a query using SELECT columns FROM data
- Optionally add WHERE, ORDER BY, and LIMIT clauses
- Review and download the query result
Features
- SELECT every column or a comma-separated list of columns
- WHERE filters with comparisons, LIKE, CONTAINS, and empty-value checks
- ORDER BY one column in ascending or descending order
- LIMIT the number of returned rows
- Preview and download the query result as CSV
Use Cases
- Select only the columns needed for an import or handoff
- Filter records by status, text pattern, number, or empty value
- Sort a filtered export and keep only the first N rows
Frequently Asked Questions
Is CSV Query free to use?
Yes. It is free to use with no signup or watermark.
Is my data private when using CSV Query?
Absolutely. All processing happens in your browser. Your data never leaves your device.
What query syntax is supported?
Use SELECT with * or named columns, FROM data, one WHERE condition, ORDER BY one column with optional ASC or DESC, and LIMIT. WHERE supports =, !=, <>, >, <, >=, <=, LIKE, NOT LIKE, CONTAINS, IS NULL, and IS NOT NULL.
Can CSV Query use GROUP BY, aggregates, or JOIN?
No. Use CSV Pivot for count, sum, average, min, or max summaries, and use CSV Joiner to match two files on a shared key.