1 CSV files 2 processed on your device 3 SQL results
CSV SQL Query
Tables
Query
Result
Result as CSV
Result as JSON
01
What it does
Loads CSV files as tables and runs SELECT queries with joins, grouping and functions, then exports the result as CSV or JSON.
Several CSV files as tables at once
WHERE, JOIN, GROUP BY, HAVING, ORDER BY and LIMIT
COUNT, SUM, AVG, MIN, MAX and DISTINCT
CASE, LIKE, IN, BETWEEN and string or date functions
02
Private by design
Everything happens in your browser. Nothing you type, paste or upload is sent anywhere, and it keeps working offline once the page has loaded.
03
What you get
Query results as CSV or JSON, with a Copy and a Download button on every result.
CSV
SQL
Data
Why it matters
A CSV export is often the quickest way to answer a question about your data: orders by month, customers in two lists, the slowest pages in a report. Spreadsheets struggle with joins and grouping, and loading a database for one question is overkill.
This tool reads CSV files as tables and runs a real SQL engine, written for this site, in your browser. Exports with customer data never leave your device, and anyone who knows a little SQL can join, group and filter thousands of rows in a second.
How it works
InputOne or more CSV files and a SELECT
In your browserRun by an SQL engine in the page
OutputA results table and CSV
Where it fits in a designer's workflow
Plan
Design
Build
Test
Launch
Answering questions about exports without a database.
By the numbers
Run with this tool's own SQL engine on its two sample CSV files (7 orders). It supports joins, GROUP BY with HAVING, ORDER BY, DISTINCT and functions, all in the browser, so a spreadsheet export can be queried without a database. Source: SQLite: SELECT.Show the numbers as a table
Query
Rows returned
Rows scanned
Group and total
2
7
Left join
7
7
By month
4
7
Filters
3
7
Distinct
3
7
How to use it
Load one or more CSV files, or use the sample tables.
Write a SELECT query using the table names shown.
Run it and check the results.
Download the results as CSV or JSON.
FAQ
Which SQL can I use?
SELECT with WHERE, inner and left JOIN, GROUP BY, HAVING, ORDER BY, LIMIT and OFFSET, DISTINCT, CASE and common functions. It doesn't change the data.
How are column types decided?
Each value is read as a number when it looks like one, otherwise as text. Empty cells are NULL.
How big can the files be?
Tens of thousands of rows work smoothly. Very large files depend on your device's memory.
I build fast, accessible websites and web apps that pass these checks from day one. Tell me about your project and I'll reply personally with honest next steps.
