SQL with Excel

Use SQL to join and aggregate spreadsheets locally in your browser.

Quick steps

  1. Open the SQL Studio.
  2. Upload one or more CSV/XLSX files.
  3. Use templates to generate starter queries (JOIN, GROUP BY, TOP N).
  4. Run and export results as CSV/XLSX.

Common examples

-- inner join
SELECT a.*, b.*
FROM "SheetA" a
JOIN "SheetB" b
ON a.id = b.id
LIMIT 100;
-- top N
SELECT *
FROM "Sales"
ORDER BY CAST("amount" AS DOUBLE) DESC
LIMIT 10;