tablize Tools

Guide

Compare Two Excel Files

Two versions of the same report, two exports a week apart — and you need to know exactly what changed. Here are three reliable ways to compare two Excel files: in the browser, or with a formula-driven diff inside Excel itself.

Compare Excel files online

If you don’t have desktop Excel at hand, the key-column approach works in tablize, an online data table: load both files and use the formula panel — including VLOOKUP and COUNTIF — to match rows and flag differences without installing anything.

Cell-level diff with a formula

If both files share the same layout, add a comparison sheet and fill it with =IF(A1<>[Book2]Sheet1!A1,"DIFF",""). Every mismatched cell lights up, and you can filter or count the DIFF flags. This is the fastest way to answer “did anything change?” across a whole grid.

Row matching across files with VLOOKUP or COUNTIF

When rows can move around, compare on a key column (an ID, an email, an order number) instead of by position. =COUNTIF(other!A:A,A2)=0 marks rows that exist in one file but not the other; VLOOKUP or XLOOKUP pulls the matching value over so you can compare amounts, dates, or statuses side by side.

Quick visual check: View Side by Side

For small sheets, open both files and use View → View Side by Side with synchronous scrolling. It costs nothing to set up, but it depends on your eyes — fine for a dozen rows, risky for a thousand.

Which method should you use?

  • No desktop Excel at hand — an online table with a formula panel.
  • Same layout, quick answer — the cell-level IF formula.
  • Rows move around — match on a key column with VLOOKUP or COUNTIF.

Comparing two sheets inside one workbook instead? See compare two Excel sheets.

FAQ

How do I compare two Excel files for differences?

Open both workbooks and use View → View Side by Side for a quick visual check. For a cell-level report, add a formula like =IF(A1<>Sheet2!A1,"DIFF","") in a copy of the sheet, or match rows across files with VLOOKUP or XLOOKUP on a shared key column.

Can I compare Excel files without installing anything?

Yes. Formula-based comparison works in Excel itself with no add-ins. If you prefer a browser, an online data table like tablize lets you load both sheets and match rows with VLOOKUP or COUNTIF from its formula panel.

How do I find rows that exist in one file but not the other?

Use COUNTIF against the other file’s key column: =COUNTIF(other!A:A,A2)=0 marks rows missing from the other file. Filter on that column to list them.