SQL-on-CSV Playground
Run SQL queries directly on CSV data in your browser. Perform JOINs, aggregations, and filtering using standard SQL syntax. 100% client-side.
Last updated: April 2026
SQL-on-CSV Interactive Playground
Why write complex Python scripts or Excel macros just to filter and aggregate data? Our **SQL-on-CSV Playground** lets you use the world's most powerful data language to query your spreadsheets directly in the browser.
Querying Power
- Full SQL Support: Use
SELECT,WHERE,GROUP BY, andHAVINGto slice your data. - Aggregation: Instantly calculate
SUM(),AVG(),COUNT(), andMEDIAN(). - Relational Joins: Combine multiple CSV files as if they were tables in a relational database.
- Instant Export: Download your query results as a new, perfectly formatted CSV file.
Real-World Scenario
Imagine you have a 10,000-row 'Orders' CSV. You need to find the top 5 customers by total spend in 'Engineering' department. Instead of manual filtering, just run:SELECT customer_name, SUM(amount) FROM ? GROUP BY customer_name ORDER BY 2 DESC LIMIT 5
Frequently Asked Questions
What SQL dialect does this playground support?
The playground uses AlaSQL, which supports a wide range of SQL-99 features including JOINs, GROUP BY, UNION, and complex subqueries.
Can I run JOINs between two different CSV files?
Yes, you can upload multiple CSV files. They are treated as separate tables (FILE1, FILE2, etc.), allowing you to perform cross-file joins and complex relational analysis.
Cite this Tool
Using this tool for a technical blog, research, or documentation? Copy a pre-formatted citation below to link back to devtoolspack.