BaseToolbox LogoBaseToolbox
Blog

© 2025 BaseToolbox. All rights reserved.

Privacy PolicyAboutContact Us
  1. Home
  2. /
  3. Compare Excel Files

Compare Excel Files

Compare two CSV, TSV, or XLSX worksheets locally by row key or position. Find added and removed rows, changed values, formula differences, duplicate keys, and unmatched columns without uploading either file.

Saved sessions
Original or earlier file

Drop a CSV, TSV, or XLSX file

Updated or later file

Drop a CSV, TSV, or XLSX file

Both files remain private

The original file, updated file, selected keys, comparison result, and exports remain in your browser. File contents and names are excluded from analytics.

Current limitations
  • CSV, TSV, and modern XLSX worksheets are supported; legacy .xls and macro execution are not.
  • Automatic column matching requires a unique normalized header on both sides; ambiguous columns are reported.
  • Duplicate row keys are reported and skipped because pairing them automatically could create a misleading diff.
  • Formula comparison uses stored formula text and cached values; the tool does not recalculate a workbook.

How to compare two Excel files

1

Import both versions

Choose a worksheet from the earlier file and the corresponding worksheet from the later file.

2

Choose row matching

Use stable ID columns when available, or use positional comparison for files with identical row order.

3

Review and export differences

Inspect added and removed rows, changed values, formula changes, and mapping issues, then export the evidence.

Excel file comparison FAQ

Are the two Excel files uploaded?
Should I compare by key or by row position?
What happens when a key is duplicated?
Can the tool compare formulas as well as displayed values?

Related spreadsheet tools

Clean CSV or Excel dataAudit Excel formulas