CSV SQL Query Engine
Run SQL SELECT queries on pasted or uploaded CSV files in your browser. WHERE, GROUP BY, HAVING, ORDER BY, aggregates and INNER/LEFT JOIN across files, then export the result as CSV or JSON. Nothing is uploaded.
Loading tool...
What is CSV SQL Query Engine?
CSV SQL Query Engine is an in-browser SQL runner for CSV files. It loads one or more CSVs as named tables and executes real SELECT statements against them: filtering with WHERE, grouping with GROUP BY and HAVING, sorting with ORDER BY, aggregating with COUNT, SUM, AVG, MIN and MAX, and joining files with INNER or LEFT JOIN. The parser and query engine are written from scratch in TypeScript, so there is no database to install, no server round-trip, and no data ever leaves your browser tab.
Key Benefits
- Run real SELECT queries on CSV exports without importing them anywhere
- Join several CSV files to answer cross-file questions a spreadsheet cannot
- Privacy-first: files are parsed and queried entirely in your browser
- Prototype and validate query logic on real data before it reaches production
- Export the result set as CSV or JSON, or copy it straight to the clipboard
Common Use Cases
- •Reconciling two CSV exports by joining them on a shared key column
- •Aggregating a sales or expense export by category without opening a spreadsheet
- •Sanity-checking a query against a small sample before running it on a warehouse
- •Filtering and reshaping exported log or analytics data into a smaller result set
How to Use CSV SQL Query Engine
- Load your CSV files: Paste CSV text into a table card, or click Upload CSV to load one or more files at once. The first row becomes the column headers and the file name becomes the table name.
- Name the tables: Rename each table to the name you want to use after FROM — for example orders and customers when you plan to join them together.
- Write a SELECT query: Type a query such as SELECT status, COUNT(*) FROM orders GROUP BY status, or click a preset chip to load a working example. Results update as you type.
- Export the result: Switch the export format between CSV and JSON, then copy the result to your clipboard or download it as a file.
Key Features
- SELECT with DISTINCT, column aliases and table aliases
- WHERE with comparisons, AND/OR/NOT, IN, LIKE, BETWEEN and IS NULL
- GROUP BY with COUNT, SUM, AVG, MIN, MAX and HAVING
- JOIN across CSV files with INNER and LEFT JOIN
- ORDER BY multiple sort keys, LIMIT and OFFSET
- Export results as CSV or JSON, or copy them to the clipboard