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 | Log Lens, VS Code | Confluence | Jira |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| JSONL | opens | opens (1) | opens | opens (1) | opens | opens | |||||||
| NDJSON | opens | opens | opens | opens | |||||||||
| gzipped JSONL | opens | opens | opens (5) | opens | |||||||||
| plain logs | opens | opens | opens (5) | opens | |||||||||
| logfmt | opens (1) | opens (1) | |||||||||||
| ANSI logs | opens | opens (6) | |||||||||||
| 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, in the IDE and in VS Code, 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 or .xltm 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, Log, & Attachment Viewer for Confluence opens .log, .txt, .out and .log.gz attachments with the level of each line detected and counted in chips, and gzipped JSONL, NDJSON, CSV and TSV; the earlier builds open neither.
- (6) Log Lens for VS Code strips the ANSI escape codes from its table and paints them as colors in the line detail.
the names each product claims
| product | file names |
|---|---|
| JSONL Lens | *.jsonl, *.ndjson, *.ldjson, *.jsonlines, *.jsonl.gz, *.ndjson.gz, *.ldjson.gz, *.jsonlines.gz |
| Log Lens | *.log, *.out, *.err, rotated *.log.N, and the .gz form of each |
| Parquet Lens | *.parquet, *.pq, *.parq, *.arrow, *.arrows, *.ipc, *.feather, *.ftr, *.avro, *.tfrecord, *.tfrecords, *.tfrec, *.h5, *.hdf5, *.he5, *.tfrecord.gz, *.tfrecords.gz, *.tfrec.gz |
| SQLite Lens | *.sqlite, *.sqlite3, *.db3, *.db, *.gpkg, *.sqlitedb, *.s3db, *.sl3, *.mbtiles, *.spatialite, *.sqlar, *.fossil, *.geodatabase, *.anki2, and most files that start with the SQLite magic bytes |
| XLSX Lens | *.xlsx, *.xlsm, *.xltx, *.xltm, *.xlam |
| 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, *.ldjson, *.jsonlines, *.jsonl.gz, *.ndjson.gz, *.ldjson.gz, *.jsonlines.gz |
| Parquet Lens for VS Code | *.parquet, *.pq, *.parq, *.avro, *.tfrecord, *.tfrecords, *.tfrec, *.tfrecord.gz, *.tfrecords.gz, *.tfrec.gz, *.arrow, *.arrows, *.ipc, *.feather, *.ftr |
| Log Lens for VS Code | *.log, *.out, *.err, rotated *.log.N with up to nine digits, and the .gz form of each |
| Lens File, Log, & Attachment Viewer for Confluence | CSV, TSV, JSONL, NDJSON, Parquet, .xlsx and .xlsm attachments; .log, .txt, .out and .log.gz, and the gzipped forms of JSONL, NDJSON, CSV and TSV |
| Lens File, Log, & Attachment Viewer for Jira | .log, .txt, .out, CSV, TSV, JSONL, NDJSON, Parquet, .xlsx, .xlsm, .log.gz, .jsonl.gz, .csv.gz attachments |