OmniSelect FileSQL

Client-Side Data Virtualization - Your Data Never Leaves Your Browser
Supports CSV, TSV, TXT, Excel, XML, JSON, 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, 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'.

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.