Affiliate disclosure: This guide contains affiliate links. If you purchase through them, we may earn a commission at no extra cost to you.
How to Compare Two Excel Files: 5 Methods (2026)
Two versions of the same budget, forecast, or report — which cells changed? Excel comparison is a daily need in finance teams, and the right method depends on what you’re comparing: values, formulas, or formatting.
Quick answer: The easiest ways to compare Excel files: 1) Microsoft’s built-in Spreadsheet Compare (needs Office Professional Plus or Microsoft 365 enterprise); 2) Draftable or Diffchecker online (free, handle XLS/XLSX/CSV, no install); 3) formula + conditional formatting for quick cell checks; 4) Python (pandas) for automated batch jobs. For PDF financial statements, see our dedicated guide.
Method 1: Spreadsheet Compare (Official, but Gated)
Microsoft ships Spreadsheet Compare: open it from the Start menu or Excel’s Inquire tab, pick the two workbooks, and get a color-coded report — green for changed values, purple for formula changes, turquoise for macros. The catch: it requires Office Professional Plus or Microsoft 365 Apps for enterprise. Most home and small-business users don’t have it — which is why the methods below exist.
Method 2: Draftable / Diffchecker Online (Free)
Both tools compare XLS, XLSX, and CSV cell-by-cell in the browser, free with no account. Upload both workbooks, pick the sheets, and review highlighted value changes. Fastest path when you lack Spreadsheet Compare. Privacy caveat: files are uploaded — fine for internal budgets, not for confidential data (offline options).
Method 3: Formulas + Conditional Formatting
For a quick check without new tools: in a spare column, enter =IF(Sheet1!A1=Sheet2!A1,"Match","Difference") (use EXACT for case-sensitive), drag down, then apply conditional formatting to highlight mismatches. Manual setup, but zero installs and full control.
Method 4: Python for Batch Jobs
Comparing monthly exports programmatically? pandas reads both workbooks and diffs them in a few lines — ideal for recurring close processes. Pair with our batch comparison guide if you handle PDF exports too.
Method 5: Export to PDF, Then Diff
When the question is “did the printed report change?” rather than “which cells changed?”, export both versions to PDF and compare with DiffPDF (free, offline). This catches layout and formatting shifts that cell comparison misses.
Watch Out: Row Reordering
Most Excel comparers match cells by position (row 5 vs row 5). If rows were reordered, you’ll see a flood of false differences. Fix: sort both sheets by a key column (e.g., ID) before comparing, or use a key-based comparison if your tool supports it.
Frequently Asked Questions
How do I compare two Excel files for differences?
Use Microsoft’s Spreadsheet Compare (needs Office Professional Plus/enterprise), free online tools like Draftable or Diffchecker, or formulas with conditional formatting for quick checks.
Why does my Excel comparison show everything as changed?
Usually row reordering: most tools compare by cell position. Sort both sheets by a key column first, or use key-based matching.
Can I compare Excel formulas, not just values?
Yes — Spreadsheet Compare distinguishes value changes (green) from formula changes (purple). Free online tools typically compare displayed values only.
Last updated: October 2026. diffpdf.org is an independent resource center, not affiliated with Microsoft or Qtrac Ltd.