Query files with SQL
You speak SQL, your data is in three Excel files. Drop them: each becomes a table, and the query is written as on a database, joins included, without installing or importing anything anywhere.
What this tool does
- Each file (or each sheet) becomes a table; its columns are inserted with a click.
- SELECT, DISTINCT, inner and outer joins, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, CASE, LIKE, IN, BETWEEN.
- The common functions: COUNT, SUM, AVG, MIN, MAX, GROUP_CONCAT, UPPER, SUBSTR, REPLACE, ROUND, COALESCE, YEAR, MONTH.
- Examples written with your real column names, and the result as XLSX, CSV, ODS or JSON.
What it does not do: This is the part of SQL that is useful on tables: no subqueries, UNION or window functions, and nothing that modifies the files. Tables stay in the tab's memory: a few hundred thousand rows, not tens of millions.
No file is uploaded. Turn off your network once this page has loaded: the tool keeps working. How to check it yourself.
Other tools
- Open a large file : Over a million rows, several gigabytes: browse, filter, sort, export.
- Automatic pivot table : Useful pivots suggested, dates grouped, the table and its chart.
- Unpivot or pivot : One column per month becomes one row per month, and the reverse.
- Convert a spreadsheet : XLSX, CSV, ODS, JSON, in every direction, sheet by sheet.
- Workbook health check : Size, phantom rows, styles, links, errors, hidden content: all of it, with one-click fixes.