Why people reach for VLOOKUP first
VLOOKUP (and its modern replacement XLOOKUP) is the most common way Excel users try to compare two spreadsheets. The idea is to use one sheet as a reference and look up each row in the other sheet to see if it exists and whether the values match.
A typical approach: in a third sheet, write =VLOOKUP(A2, Sheet2!A:B, 2, FALSE) to pull a value from the second sheet and then subtract or compare it to the value in the first sheet. Flag the difference with conditional formatting.
This works — but it requires you to write formulas, define which column is the key, handle cases where rows appear in one sheet but not the other, and repeat the process for every column you want to check. On a spreadsheet with 20 columns and 5,000 rows, that is a significant setup effort.
What VLOOKUP cannot do
VLOOKUP finds values but it cannot tell you the full story of what changed between two versions of a spreadsheet. Specifically:
It cannot detect added or removed rows without extra work. If a row exists in the old sheet but was deleted in the new sheet, VLOOKUP will return an error — you then need additional logic to distinguish "not found because deleted" from "not found because the key changed."
It cannot compare across multiple columns simultaneously without multiple formulas. Each column needs its own VLOOKUP or comparison formula.
It does not highlight the differences visually. You need to add conditional formatting manually, per column.
It does not work at all if there is no unique key column. VLOOKUP requires a value to look up. If your data does not have a reliable unique identifier per row, the comparison breaks down.
What a spreadsheet diff tool does instead
FreeDiffChecker's Excel & CSV Difference Checker compares two spreadsheets cell by cell across every row and column simultaneously, without you writing a single formula.
Upload your original XLSX, XLS, CSV, or TSV in the left panel and the revised version in the right panel. The tool produces a table where:
- Green rows were added in the new version
- Red rows were removed from the old version
- Amber cells were modified — hover over them to see the original value
Multi-sheet workbooks are handled automatically. Each sheet tab gets its own comparison, and you can switch between sheets to check them all.
The result is a complete, instant picture of every change in the file — not just the columns you thought to check.
When to use VLOOKUP vs. a diff tool
Use VLOOKUP when:
- You want to merge or enrich data from two sources (pulling fields from one sheet into another)
- You are building a permanent formula that will update as data changes
- You need to handle complex matching logic (partial matches, case-insensitive, approximate match)
- You are comfortable with formulas and already have them set up
Use a diff tool when:
- You want to audit what changed between two versions of the same file
- You need a one-time comparison you do not want to maintain
- You want a visual summary of all changes across all columns without writing formulas
- Your data does not have a reliable unique key column
- You need to share the comparison result with someone who does not have Excel
Excel's built-in Spreadsheet Inquire / Compare feature
Microsoft 365 includes a hidden tool called Spreadsheet Compare (available via the Inquire add-in, which you may need to enable in File > Options > Add-ins). It produces a detailed side-by-side comparison of two workbooks, including formula changes, value changes, and structural changes.
The limitation is that it requires Microsoft 365 and is not available in older Excel versions or on Mac. It is also buried in the interface — many users do not know it exists. If you have access to it, it is the most thorough Excel-native option. If you do not, FreeDiffChecker's online tool covers most comparison use cases without any subscription or installation.
Practical tips for better spreadsheet diffs
Sort both sheets the same way before comparing. A diff tool compares rows positionally — row 1 vs. row 1, row 2 vs. row 2. If the two sheets are sorted differently, every row will appear different even if the data is identical. Sort by the same column in both files before uploading.
Remove calculated columns before diffing. If your spreadsheet has VLOOKUP or SUM columns that reference external data, those values may differ between the two files simply because external data changed. Remove or hide those columns before comparing to focus on the raw data.
Use CSV for large files. XLSX files can contain significant metadata and formatting information that slows down processing. For very large datasets, export both sheets as CSV first — the diff will run faster and the result will be cleaner.