Les Archives · pièce 4
Query CSV with SQL
Run SQL queries on CSV, JSON and Parquet files with DuckDB.
🔒 Traité dans votre navigateur · Sans envoi · Sans inscription
Drop CSV, JSON or Parquet files here ou cliquez pour parcourir
Each file becomes a table you can query with SQL. Files stay on your device.
Run SQL queries on CSV files — no database needed
Drop one or more CSV, TSV, JSON / NDJSON or Parquet files and query them with full SQL: GROUP BY, JOIN across files, window functions, date functions and more. Column types are detected automatically. The query engine is DuckDB compiled to WebAssembly, so even files with millions of rows are fast — and nothing is uploaded.
Examples
SELECT country, SUM(revenue) FROM sales GROUP BY 1 ORDER BY 2 DESC;SELECT * FROM orders o JOIN customers c ON o.customer_id = c.id;
How big can files be?
Files are held in your browser's memory, so a few hundred MB works well on most computers.