The fastest way to spot differences between two Excel files
Open both files in the same Excel window using the View Side by Side feature, which puts them on your screen at the same time so you can see changes when ready. If the files are large or you need to track exactly what changed, use the built-in Compare Sheets tool or a dedicated comparison program. The method you pick depends on file size, how many changes you expect, and whether you need a permanent record of what was different.
Key Takeaways
- View Side by Side in Excel lets you open two files at once and scroll through them together, which works best for files under 50,000 rows.
- The Compare Sheets feature (in Excel 365 and newer versions) highlights cells that differ and creates a summary you can save.
- Free tools like WinMerge or Diffchecker work when Excel's built-in tools are too slow or when you need to compare non-Excel formats.
- Before comparing, remove formatting-only changes like font color or cell borders, because these clutter the results and hide real data differences.
- Save the comparison results as a separate file so you have a record of what was different and when you checked.
Using View Side by Side in Excel
Open the first Excel file, then open the second file in the same Excel window. Go to the View tab at the top, click View Side by Side, and Excel will split your screen in half. The first file appears on the left, the second on the right. Scroll down in one file and the other scrolls automatically, so you can move through both at the same time and spot where they differ.
This method works well for files with a few thousand rows and a handful of columns. If your files are much larger, scrolling becomes slow and you may miss changes. If you need to compare specific columns or rows rather than the whole sheet, you can freeze panes first — select the row or column where you want the split, then freeze panes from the View tab — before opening View Side by Side.
When you are done, close one file and the other returns to full screen. View Side by Side does not change either file, so you can close without saving.
Using the Compare Sheets feature in Excel 365
Excel 365 (the subscription version) includes a Compare Sheets button on the Review tab. Click it, select the file you want to compare against, and Excel highlights every cell that differs between the two. Matching cells stay white; different cells turn yellow. Excel also creates a summary sheet that lists each change, which row it is in, and what the old and new values are.
This method is faster than scrolling manually and creates a record you can save. The summary sheet is useful if you need to show someone else what changed or if you need to refer back to the comparison later. One limitation: Compare Sheets works only on files that are already open in Excel, and only on .xlsx files (not .csv or other formats).
After the comparison finishes, you can save the file with the summary sheet included, or delete the summary sheet and save the original file unchanged. The comparison does not modify your data either way.
Using free comparison tools for large files or other formats
If your files are very large (over 100,000 rows), or if one file is in .csv format while the other is .xlsx, use a dedicated comparison program. WinMerge is free and works on Windows. It opens two files side by side, highlights differences in color, and lets you jump from one change to the next. Diffchecker is a free website where you paste or upload two files and it shows you the differences in a web browser — no installation needed.
These tools are faster than Excel on very large files because they are built specifically for comparison. They also handle more file formats. The trade-off is that they show raw differences without understanding that a cell contains a number or a date — they just compare text. If you need to ignore small differences like trailing spaces or different date formats, you may need to clean up your files first.
Preparing files before you compare them
Before comparing, remove any formatting changes that are not real data changes. If one file has cells with blue background and the other does not, that will show up as a difference even though the actual numbers are the same. Select all cells in both files (Ctrl+A), then go to Home > Clear > Clear Formatting to strip out colors, fonts, and borders. Keep only the data itself.
Also check that both files use the same column order and the same row order. If one file has columns in the order Name, Age, City and the other has Age, Name, City, the comparison will show every cell as different even though the data is the same. Rearrange columns so they match before you compare.
If one file has extra blank rows or columns, delete them. If one file has headers and the other does not, add headers to match. These small cleanup steps make the comparison results much clearer and save you time reading through false differences.
Reading and saving comparison results
When the comparison is done, go through the highlighted or listed differences and decide which ones matter. Some differences are expected — if you are comparing a file from last month to this month, you expect numbers to have changed. Other differences might be mistakes, like a formula that was accidentally deleted or a value that was typed wrong.
Save the comparison results in a new file with a clear name like "Comparison_File1_vs_File2_Jan2025.xlsx" so you know what you compared and when. If you used Excel's Compare Sheets feature, the summary sheet is already in the file. If you used View Side by Side or an external tool, take a screenshot or copy the list of differences into a new sheet and save it.
Keep this record if you need to explain the changes to someone else or if you need to refer back to what was different weeks or months later.
When to use each method
| Method | Best for | File size limit | Formats supported |
|---|---|---|---|
| View Side by Side | Quick visual check of small files | Under 50,000 rows | .xlsx, .xls |
| Compare Sheets (Excel 365) | Creating a saved summary of changes | Under 100,000 rows | .xlsx only |
| WinMerge or Diffchecker | Large files or non-Excel formats | Over 100,000 rows | .csv, .txt, .xlsx, others |
Frequently Asked Questions
Can I compare sheets within the same Excel file?
Yes. Open the file, right-click the sheet tab at the bottom, and select Move or Copy. Copy the sheet you want to compare to a new file, then use View Side by Side or Compare Sheets to compare the two sheets. Alternatively, open the same file twice in Excel and compare the different sheets that way.
What if the two files have different numbers of rows or columns?
The comparison will still work, but the file with fewer rows or columns will appear to have blank cells at the end. This is normal. Focus on the rows and columns that exist in both files. If one file has extra data that the other does not, that is a real difference worth noting.
Does comparing files change them?
No. View Side by Side and Compare Sheets do not modify your original files. If you save the file after using Compare Sheets, you are saving the summary sheet that was added, not changing the original data. Close without saving if you want to keep your files exactly as they were.
Can I compare files that are password-protected?
You can compare them if you can open them in Excel. If the file is protected to prevent editing, you can still view and compare it. If it is protected to prevent opening, you will need the password first. External tools like WinMerge may not be able to read password-protected Excel files.
What is the fastest way to compare very large files?
Use WinMerge or Diffchecker rather than Excel. These tools are built for speed on large datasets and will finish in seconds where Excel might take minutes. If you are comparing files over 500,000 rows, a command-line tool like diff (on Mac or Linux) or a Python script may be even faster, but that requires technical knowledge.