twilight venturesformats
One table for the whole family: a row per file format, a column per product, and a cell that reads opens where the product opens that format by name. A blank cell means the product does not claim the format, or that its own description does not confirm it, and the notes under the table say where a cell needs a word more. The second table lists the file names each product claims.
| format | JSONL Lens | Log Lens | Parquet Lens | SQLite Lens | XLSX Lens | Notebook Lens | DuckDB Lens | Heap Dump Lens | JSONL Lens, VS Code | Parquet Lens, VS Code | Confluence | Jira |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| JSONL | opens | opens (1) | opens | opens | opens | |||||||
| NDJSON | opens | opens | opens | opens | ||||||||
| gzipped JSONL | opens | opens (5) | opens | |||||||||
| plain logs | opens | opens (5) | opens | |||||||||
| logfmt | opens (1) | |||||||||||
| ANSI logs | opens | |||||||||||
| CSV | opens | opens | ||||||||||
| TSV | opens | opens | ||||||||||
| Parquet | opens | opens | opens | opens | ||||||||
| Avro | opens | opens | ||||||||||
| TFRecord | opens | opens | ||||||||||
| Arrow IPC | opens | opens | ||||||||||
| Feather | opens (2) | opens (2) | ||||||||||
| SQLite | opens | |||||||||||
| DuckDB | opens | |||||||||||
| XLSX | opens | opens | opens | |||||||||
| XLSM | opens (3) | opens (3) | opens (3) | |||||||||
| Jupyter notebooks | opens | |||||||||||
| HPROF heap dumps | opens | |||||||||||
| thread dumps | opens (4) | |||||||||||
| GC logs | opens (4) |
- (1) Log Lens reads JSON lines and logfmt inside the files it claims by name (.log, .log.N, .log.gz); a file named .jsonl opens in JSONL Lens instead.
- (2) Feather v2; a Feather v1 file is not read.
- (3) A .xlsm opens as data; its macros are never read.
- (4) A .tdump file opens by name; jstack output and GC logs open through the Tools menu of Heap Dump Lens (Open Thread Dump, Open GC Log). A GC log is a .log file, so Log Lens opens it as lines; this row means parsed pause events.
- (5) Lens File Viewer for Confluence 2.4.0, the version in review, opens .log, .txt and .out attachments with the level of each line detected and counted in chips, and gzipped JSONL, NDJSON, CSV and TSV; the earlier builds open neither.
- Gzipped JSONL in VS Code: the .gz forms are not opened.
the names each product claims
| product | file names |
|---|---|
| JSONL Lens | *.jsonl, *.ndjson, *.jsonl.gz, *.ndjson.gz |
| Log Lens | *.log, rotated *.log.N, *.log.gz |
| Parquet Lens | *.parquet, *.pq, *.parq, *.arrow, *.arrows, *.ipc, *.feather, *.ftr, *.avro, *.tfrecord, *.tfrecords, *.tfrec, *.tfrecord.gz, *.tfrecords.gz, *.tfrec.gz |
| SQLite Lens | *.sqlite, *.sqlite3, *.db3, *.db, *.gpkg, and any file that starts with the SQLite magic bytes |
| XLSX Lens | *.xlsx, *.xlsm |
| Notebook Lens | *.ipynb |
| DuckDB Lens | *.duckdb, *.ddb, and any file that starts with the DuckDB magic bytes |
| Heap Dump Lens | *.hprof, *.hprof.gz, *.tdump, and any file that starts with the hprof magic bytes; GC logs and jstack output through the Tools menu |
| JSONL Lens for VS Code | *.jsonl, *.ndjson |
| Parquet Lens for VS Code | *.parquet, *.pq, *.parq, *.avro, *.tfrecord, *.tfrecords, *.tfrec, *.tfrecord.gz, *.arrow, *.arrows, *.ipc, *.feather, *.ftr |
| Lens File Viewer for Confluence | CSV, TSV, JSONL, NDJSON, Parquet, .xlsx and .xlsm attachments; in 2.4.0, the version in review, .log, .txt and .out, and the gzipped forms of JSONL, NDJSON, CSV and TSV |
| Lens File Viewer for Jira | .log, .txt, .out, CSV, TSV, JSONL, NDJSON, Parquet, .xlsx, .xlsm, .log.gz, .jsonl.gz, .csv.gz attachments |