← Home

OmniSelect FileSQL

Client-Side Data Virtualization - Your Data Never Leaves Your Browser
Supports CSV, TSV, TXT, Excel, XML, JSON, JSON Lines, YAML, Avro, Parquet Files

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, JSON, JSON Lines (.jsonl, .ndjson), XML, YAML, Avro, Parquet. Column headers with spaces are auto-converted to underscores. Numeric values are auto-detected so you can filter with = 42 instead of = '42'.

Click anywhere in this panel or drop files onto it. No file to hand?

SQL Editor ?Write standard SQL 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.

Query Results ?Results appear here after running a query. Large result sets are paginated at 1,000 rows per page. Use the Export button to download as CSV, JSON, Excel, or Parquet. Nested column headers show the short alias on top and the full dot-path below.

No results yet. Run a query to see data.