Data Studio
CSV SQL Engine & Pivot Builder
Upload CSV files, run real SQL queries with GROUP BY and JOINs, and build pivot summaries — powered by SQLite WASM. Zero server.
Tables (0)
No tables loaded. Upload a CSV or load the sample.
SQL Query
Ctrl+Enter to run · SQLite syntax · no tables
Query CSV Files Like a Database
Spreadsheet tools like Excel and Google Sheets become cumbersome with complex aggregations, multi-table JOINs, or when working with sensitive data you cannot upload to a cloud service. Our CSV SQL Engine loads your data into an in-memory SQLite database compiled to WebAssembly, giving you the full power of a relational database query engine without installing anything or sending data anywhere.
Example Queries You Can Run
Pivot Table
SELECT department, COUNT(*) n, AVG(salary) avg FROM employees GROUP BY department;
Top 10 by Value
SELECT * FROM sales ORDER BY revenue DESC LIMIT 10;
Filter & Search
SELECT * FROM users WHERE city = 'London' AND age > 25;
Multi-table JOIN
SELECT o.id, c.name, p.title FROM orders o JOIN customers c ON o.cid = c.id JOIN products p ON o.pid = p.id;
Frequently Asked Questions
Yes. sql.js is the official SQLite database engine compiled to WebAssembly (WASM). It is the same database engine powering billions of apps and devices, running entirely inside your browser tab with zero server involvement.