1.3.0
Excel Workbooks (XLSX) as Table
- Open Excel workbooks as tables: open modern OpenXML Excel workbooks (
.xlsx,.xlsm,.xltx,.xltm) directly into FastEditor's high-performance CSV grid snapshot via File > Open, drag-and-drop, Recent Files, or the command line. Workbooks are strictly read-only and never modified (Save As defaults to CSV). - Sheet picker & multi-sheet support: single-sheet workbooks open immediately; multi-sheet workbooks present a sheet picker listing visible sheets followed by hidden sheets marked
[hidden](veryHiddensheets are omitted). UseTable: Open Another Sheet...to open additional sheets in new tabs. - Standardized cell values: dates and datetimes are formatted as ISO 8601 strings (
YYYY-MM-DDorYYYY-MM-DD HH:MM:SS), numbers appear as clean decimals, hidden rows/columns are included, merged cells map to their top-left cell, and uncached formulas are displayed empty with an informative count. - 50 MB workbook limit & large-grid truncation: supports workbooks up to 50 MB, up to 1,000,000 rows, and up to 600 columns. Sheets exceeding these caps safely load the first 1,000,000 rows or first 600 columns with a status-bar notice. Sheets with no data within the grid or empty sheets are refused safely with an explanatory message.
- Clear messages for unsupported spreadsheets: legacy binary Excel (
.xls,.xlsb), OpenDocument spreadsheets (.ods), and password-protected workbooks are refused with clear guidance to save as.xlsxor.csvin Excel.
JSON as Table
- JSON: Open as Table (
Ctrl+Shift+J): converts tabular JSON (arrays of objects, arrays of arrays, wrapper objects, JSON Lines, flat objects) up to 50 MB (or 32 MB selection) into a detached, editable CSV grid snapshot tab (<file> [Table]) with up to 1,000,000 rows and 600 columns (overflow keys beyond 600 are preserved in a trailing column). - Interactive table candidate picker: documents containing multiple candidate tables prompt with a picker dialog showing row counts and sample keys.
- Snapshot editing, CSV saving & Export to JSON: full CSV grid editing, sorting, filtering, SQL queries (
Ctrl+Shift+Q), and DB Builder integration. Saves as CSV, and a dedicatedTools > JSON > Export Table to JSONcommand reconstructs formatted JSON in a new tab, restoring data types and nested structures. - JSON Lines (
.jsonl/.ndjson) open as text: JSON Lines files now open as standard editable text tabs with instant table view available viaCtrl+Shift+J, the status bar badge, or toolbar button.
JSON Tools & Structure Tree
- Streaming RFC 8259 Validator (
Ctrl+Shift+K): validates the document or selection asynchronously without memory overhead. Reports token count, nesting depth, and elapsed time on the status bar, or jumps the caret directly to the syntax error location. - Lossless Format in Place (
Ctrl+Shift+B) & Minify JSON: formats (2-space indentation) or minifies documents or selections up to 32 MB in place with a single Undo step (Ctrl+Z). Exact number text (arbitrary integers, trailing fractional zeros, large exponents) and key order are preserved verbatim. - Format JSON to New Tab (
Ctrl+J) on streaming engine: now powered by the streaming RFC 8259 tokenizer, preserving exact numbers and duplicate keys. Unescaped control characters inside strings (U+0000..U+001F) are strictly flagged as errors. - Docked JSON Structure Tree (
F11): virtualized right-hand tree view indexing JSON up to 50 MB (containers-only mode above 32 MB or 1,000,000 nodes; selections up to 32 MB). Offers live substring/JSONPath/JSON Pointer filtering, value-only caret selection, context menu for copying paths/values, and bidirectional caret sync.