DEV Community

Martin Grüner
Martin Grüner

Posted on Originally published at martingruner.com

Comparing XLSX, ODS, Numbers, CSV, and TSV without converting first

Diff Anything 1.3 adds the spreadsheet workflow I most wanted the product to have: comparing files even when they use different spreadsheet formats. An XLSX workbook can be compared with ODS, an Apple Numbers file with Excel, or a CSV/TSV table with a workbook. There is no conversion step before the comparison.

The comparison is based on stored cell values. Both sides stay in an aligned, sheet-aware grid with row numbers, column letters, empty cells, values, and the selected coordinate connected to the Differences pane. Large populated ranges are virtualized so the review does not need to render an entire workbook at once.

The boundary matters as much as the feature: spreadsheet mode does not compare formulas, formatting, charts, macros, or workbook layout. It compares the stored values a reviewer can inspect cell by cell.

Folder diff was rebuilt as a review workspace too. It now has two-pane tree and table layouts, search, status filters, progressive loading, ignore patterns, moved-file detection, and direct opening of nested file pairs. Pro synchronization turns a reviewed selection into an explicit create, update, delete, and move plan, with stale-result protection, recovery journals, rollback, and undo.

PDF review now makes two different questions explicit. Visual diff renders both versions and highlights page-pixel changes, which can reveal changed charts, replaced or moved images, visible signature changes, stamps, missing elements, and layout shifts. Extracted text is a separate mode for additions, removals, and changed wording. Visual diff does not authenticate a digital signature or inspect hidden PDF metadata.

All comparisons still run locally on macOS and Windows. There is no Diff Anything account, cloud comparison service, analytics, or telemetry.

The full release notes include the exact boundaries and four new screenshots: https://martingruner.com/blog/diff-anything-1-3

Top comments (0)