Changelog

1.12.1 current

1C 7.7 documents are read more fully.

New

• Binary .mxl files from 1C 7.7 with long strings, formulas and empty rows at the start and end are read in full.

1.12.0

1C:Enterprise 7.7 documents.

New

• Binary .mxl files from 1C 7.7 open as a table: rows and cell text, like 1C 8 documents.
• If the file contains cells of a special kind (number formats, drill-downs), the program shows the rest and says plainly that not everything is shown.

1.11.0

Parquet, PDF, contents of binary fields, side-by-side comparison and FoxPro indexes.

New

• Writing Parquet. Any table exports to Parquet with its types, dates and empty values — for pandas, DuckDB and Spark. How to do it.
• Saving as PDF from the print dialog: a header on every page, highlighting and color scales, any alphabet, searchable and copyable text. Details.
• Cell contents. The picture from a binary field — even inside the OLE wrapper of a FoxPro G field — the file type by content, a hex dump and saving as a file. Details.
• Side-by-side comparison. Two exports next to each other, rows aligned by key, differences highlighted on both sides. Details.
• .cdx indexes of FoxPro and Visual FoxPro: the table is shown in the order of the chosen tag. Details.
• Hotkeys for modes: Alt+1…3 for the right panel (record, statistics, bytes), Alt+4…6 for records marked as deleted, F4 for editing.

Improved

• Batch conversion and the Tabulens.exe convert console command handle Parquet.
• The version number is now the same everywhere: in “About”, in the properties of Tabulens.exe and on this page.

1.10.0

Totals of the selection and saved views.

New

• Totals of the selected cells in the status bar: count, sum, average, minimum and maximum.
• Saved views: filters, search, sorting and the set of columns are remembered under a name and brought back with one click.

1.9.0

Tidying data, column profile and the international edition.

New

• “Tidy up”: extra spaces, invisible characters, case, quotes, and numbers and dates written as text.
• Column profile: fill rate, spread, frequent values, outliers and remarks for all columns at once.
• The international edition with a free mode and a Pro key.

1.8.0

Parquet and column structure.

New

• Reading Parquet with our own parser, no outside libraries: Snappy, Gzip, LZ4 and Zstandard compression, dictionaries, lists and structs.
• Column structure for CSV, JSON, Excel and ODS: split, merge, add, rename, move.
• Transposing: rows become columns and columns become rows.

1.7.0

Charts, color scales and the command line.

New

• Charts from a pivot: columns, bars, line and pie; dates by year, quarter and month; saving to PNG and SVG.
• Color scales and icons for numeric and date columns.
• Console conversion: Tabulens.exe convert converts files between formats without a window.
• The “Data” menu is split into “Analysis”, “Tables” and “Transform”.

1.6.0

Printing, SQL across files and batch conversion.

New

• Printing a table (Ctrl+P) with a repeating header, and printing a record card.
• SQL over open tables, including JOINs between files.
• Conditional highlighting of rows and cells — in the grid and on paper.
• Pasting a table from the clipboard and batch conversion of a folder or a set of files.

1.5.0

Other countries, DATASUS files and linked tables.

New

• Checks for numbers of other countries: tax and personal numbers, documents of many states.
• Brazilian DATASUS .dbc files.
• Master–detail link: for the current row of the master table, the detail table shows only the related records.

1.4.0

Updating the Windows app and terms of use.

New

• Checking and installing updates from within the program: the new version is downloaded, verified by checksum and installed when you say so.
• License: free for personal use, for organizations by agreement.

1.3.0

Table matching and international checks.

New

• Matching two tables by fields: who is in and who is not, with values normalized to one form.
• Value checks: international formats of documents and numbers.

1.2.0

Access, binary Excel and 1C documents.

New

• Access databases: reading .mdb and .accdb with our own parser, no drivers and no Access.
• Binary Excel workbooks (.xlsb) are read with our own parser.
• 1C spreadsheet documents (MXL): reports, statements and print forms open as a table.

1.1.0

Checks, formulas, pivot tables and undo.

New

• Value checks: personal and tax numbers, emails, phones, dates and custom formats.
• Computed columns by formula and filling a column by formula.
• Pivot tables: rows × columns with totals and export to Excel.
• Step-by-step undo: Ctrl+Z and Ctrl+Y for every editing operation.

1.0.0

SQLite with writing and SQL queries, finding duplicates, dates as text.

New

• Editing SQLite databases, saved through the official engine in WebAssembly; the WAL journal is read together with the database.
• Read SQL queries and views against SQLite databases, query history.
• Finding duplicates by fields.
• Dates written as text in Excel, ODS and XLS are recognized as dates; Excel workbooks with a namespace prefix are read.

0.9.0

Merging and splitting files, anonymizing, first SQLite databases.

New

• Merging files of the same structure into one table.
• Splitting a table into files by a column’s value.
• Anonymizing columns: a number, GUID or code instead of the value; loading the mapping table of a previous export.
• SQLite databases open for viewing; finding a column by name (Ctrl+G).

0.8.0

Interface comfort.

New

• Narrow screens: the panels slide over the table, the interface works on a phone.
• A third theme — grey; the state of switches is remembered between launches.
• Copying with Ctrl+Insert, an XSD schema opens without an XML file, column statistics follow the selection.

0.7.0

ODS, code dictionaries and dragging columns.

New

• ODS: reading, writing and exporting LibreOffice and OpenOffice tables.
• Code dictionaries: decoding values by a dictionary; they stay on your device.
• Dragging columns with the mouse; grouping totals export to Excel.

0.6.0

Excel and JSON.

New

• Excel: formulas, merged cells, multi-sheet workbooks and reading old .xls.
• JSON: validation against JSON Schema and data generation from a schema.
• CSV and JSON are saved the way they were opened: delimiter, quoting, indentation.

0.5.0

All of DBF and fixed-width files.

New

• DBF: writing memo, packing and restoring deleted records, editing the field structure, creating a table from scratch.
• CSV: fixed-width files — column boundaries are found from the data and can be set by hand.

0.4.0

XML as a table.

New

• Validation against XSD and data generation from a schema.
• Linked tables: invoice, case, service — each level of an export as its own table, with moves up and down the link.
• Lazy reading: only record offsets stay in memory, so large exports open; editing and saving XML.

0.3.0

The Windows version.

New

• A single Tabulens.exe with no installation and no dependencies — easy to carry on a USB stick into a closed network.
• Opening a file by a launch parameter: the path to a table can be passed to the program at startup.

0.2.0

Editing tables and exporting to SQL.

New

• Editing: replace across the table, filling a column, adding and deleting rows.
• Export to SQL: a choice of DBMS dialect, CREATE TABLE and the way rows are inserted.

0.1.0

The first version: viewing tables right in the browser.

New

• DBF (including Visual FoxPro), Excel, CSV, XML and JSON open in the browser; the file stays on your computer.
• Filters, sorting, search, column statistics and export.