2.2.1

What's New in Version 2.2.1 🎉

Major Enhancements

• Interleaved Row Sorting: ⭐ NEW
  Deleted rows now appear in context! When rows are deleted, they're inserted immediately before the next corresponding new row position, making it much easier to understand what changed and where.

  Example:

  • Old File: New File:

  • Row 5: Data A Row 5: Data B

  • Row 6: Data B Row 6: Data C

  • Row 7: Data C

  • Display Order (Interleaved):

  • Row 5 → 5: Data A → Data B (Modified)

  • Row 6 → -: Data B (Deleted, shown before new row 6)

  • Row 7 → 6: Data C (Matched)

• Blank Key Column Handling: ⭐ NEW
  When rows have empty key column values, the tool now intelligently matches them using:

  1. Position-based matching (same row number in both files)
  2. Content comparison (all columns must match exactly)

  This prevents false positives when comparing files with occasional blank IDs.

• Enhanced Row Matching Accuracy: ⭐ NEW

  • Fixed row number calculation for non-default header rows
  • Improved Excel row number display (correctly shows header row + data row index)
  • Better handling of edge cases in key-based matching

Bug Fixes & Improvements

• ✅ Fixed row sorting to show deleted rows in logical positions
• ✅ Corrected Excel row number calculation for all header row selections
• ✅ Improved blank key column matching logic
• ✅ Fixed row type detection (matched/added/deleted)
• ✅ Enhanced debug logging for troubleshooting
• ✅ Improved CSV warning UX - now shows only once per browser session

v2.0.0

What's New in Version 2.0.0 🎉

Major Changes

• Unified Table View: Replaced side-by-side comparison with a single unified table
• Old/New Row Indices: Each row shows both its old (File A) and new (File B) row numbers
• Smart Column Matching: Columns are matched by header content, not position
  • Handles column reordering correctly
  • Detects truly added/deleted columns
  • Preserves column relationships even when columns are moved
• Enhanced Cell Display: Modified cells show "old value → new value" inline
• Click-to-Navigate: Click any changed cell to jump to that change in the navigation sequence
• Improved Change Detection: More accurate detection of column additions/deletions

Breaking Changes from v1.x

• Removed synchronized scrolling (replaced with unified table)
• Removed side-by-side sheet view (replaced with single table view)
• Removed sheet rename detection (simplified to focus on content comparison)
• Changed sheet selection workflow (now manual selection from dropdowns)

1.1.0

Full Changelog: 1.0.0...1.1.0

1.0.0

Demo Link Here
Full Changelog: https://github.com/HackettLai/excel-differ/commits/1.0.0