Run real SQL on your spreadsheets
Drop in Excel or CSV files and query them with SQL: SELECT, WHERE, GROUP BY, JOIN, HAVING, window functions and more. It is a real SQLite database running inside your browser, so even confidential company data never leaves your computer.
- Several files at once: Each sheet becomes a table, so you can JOIN orders to customers or this month to last month.
- Smart column types: Numbers, UK dates (stored as YYYY-MM-DD so date functions work) and text are detected automatically.
- Ready-made examples: Totals by group, monthly totals, duplicates, top 10 and joins are written for your actual columns.
- Practice SQL: Perfect for learning or preparing for data analyst interviews using your own data.
Handy SQLite tips
- Column names with spaces need double quotes:
"Order Date". - Month from a date:
Strftime('%Y-%m', "Order Date"). - Text matching ignoring case:
WHERE "Region" LIKE '%lon%'.