Query a Table with SQL
Run SQL on a CSV or Excel file in your browser: SELECT, WHERE, JOIN and GROUP BY on your own data, then export the result.
Your data never leaves this browser
The file is parsed, previewed and charted on your own device. Nothing is uploaded — not even a sample. Close the tab and the data is gone.
Table 1 (data)
Or paste table text
Table 2 (data2, optional — for JOIN)
Or paste table text
Table names you can use:
Run a query and the result appears here.
How it works
- 1.Import one table, or a second one too so you can JOIN them (Excel, CSV, TSV or JSON, or paste).
- 2.The engine is SQLite: the table names you can use are listed under the editor, and the first row becomes the header.
- 3.Write your query, or press Try sample data for a working example, then run it with Run SQL.
- 4.Read the result and download all of it as CSV or Excel — the grid only previews the first rows.