File Select ?Click or drag & drop files here. Each file becomes a SQL table named by a single letter, taken from the start of the filename (orders.csv becomes O). The Alias column shows it, and you can change it. Supports CSV, TSV, TXT, Excel (also .xlsb and templates), OpenDocument (.ods), dBase (.dbf), Lotus 1-2-3, JSON, JSON Lines (.jsonl, .ndjson), XML, YAML, Avro, Parquet, Arrow/Feather, SQLite, Microsoft Access, SPSS, SAS, Stata, MongoDB BSON, MessagePack and CBOR; any of them gzipped (orders.csv.gz); and ZIP or TAR archives, each readable file inside becoming its own table. A Microsoft Access database opens the same way: each of its tables gets its own row. For a workbook or SQLite database, pick the sheet or table in the Sheet column. Column headers with spaces are auto-converted to underscores. Numeric values are auto-detected so you can filter with = 42 instead of = '42'.

Choose files, or click anywhere in this panel, or drop files onto it. No file to hand? Try sample data

SQL Editor ?Ask in plain English on the left, or write standard SQL on the right using your file aliases as table names (e.g. SELECT * FROM A). Use WHERE for filters, JOIN to combine files, GROUP BY for aggregates. Numeric columns support = 42 directly. Text columns use single quotes: WHERE city = 'Austin'. Click Run Query or press Ctrl+Enter.