The fastest way to spot differences between two spreadsheets

The quickest method depends on what changed and how much data you have. If both files are small and you need to see everything that differs, open them in separate windows and scroll through side by side. If the files are large or you only care about specific columns, use Excel's built-in comparison tools or a free online diff checker. For detailed tracking of what changed between versions, Excel's version history (if you use OneDrive or SharePoint) shows you exactly who changed what and when.

The approach that works best also depends on whether you're comparing structure (did someone add or delete columns?), values (did numbers change?), or both. A manual side-by-side check works for small files. A formula-based approach works when you need to flag every difference. A dedicated comparison tool works when you have hundreds of rows and need to move fast.

Key Takeaways

  • Open both files in separate Excel windows and arrange them side by side to visually compare small spreadsheets quickly.
  • Use conditional formatting with a formula to highlight cells that differ between two files, which scales to large datasets.
  • Excel's version history (available in OneDrive and SharePoint) shows exactly what changed, who changed it, and when.
  • Free online tools like Diffchecker or WinMerge can compare files without installing software, useful if you lack admin access.
  • If you need to track changes going forward, turn on Track Changes before editing so Excel records every modification.

Opening two files side by side in Excel

The simplest approach for small files is to view both at once. Open the first file in Excel, then open the second file. Both will open as separate windows. Go to the View tab in Excel, click Arrange All, and choose Side by Side. Excel will split your screen so you see one file on the left and one on the right.

Scroll through both files together — when you scroll in one, the other scrolls at the same pace. This works well if the files have the same structure (same columns in the same order) and you're looking for value changes. If the columns are in different orders or one file has extra rows, you'll need to mentally map which column is which, which gets tedious fast. For files with more than a few hundred rows, this method becomes slow because you're scrolling through everything.

If you want to keep both files open but not locked together, open them normally without using Arrange All. Click the View tab, then click Switch Windows to jump between them. This lets you compare specific sections without scrolling both at once.

Using conditional formatting to highlight differences

For larger files or when you want Excel to find differences automatically, use conditional formatting with a formula. This approach works best when both files have the same structure and you want to see which cells changed.

Open the first file. Select all the data you want to compare. Go to Home, then Conditional Formatting, then New Rule. Choose Use a Formula to Determine Which Cells to Format. In the formula box, type a formula that compares the current cell to the matching cell in the other file. For example, if your first file is open and the second file is named "Comparison.xlsx", the formula might be: =Sheet1!A1<>[Comparison.xlsx]Sheet1!A1

This formula tells Excel: highlight this cell if it does not match the same cell in the other file. The <> symbol means "not equal to". Set the formatting to a bright color (like yellow or red) so differences jump out. Click OK. Excel will now highlight every cell that differs between the two files.

This method scales to thousands of rows because Excel processes it when ready. The downside is that both files must be open at the same time, and if the files have different structures (different numbers of columns or rows), you'll need to adjust the formula for each section.

Checking version history in OneDrive or SharePoint

If both versions of your file are stored in OneDrive or SharePoint (not just on your local computer), Excel keeps a version history automatically. This shows you every change made to the file, who made it, and when. Open the file in Excel. Click File, then Info. On the right side, you'll see Version History. Click it to see a list of all saved versions.

Click any earlier version to open it in a read-only view. You can see the file as it was at that point in time. This is useful if you want to see what the file looked like before someone made changes, but it does not highlight the specific differences — you still have to compare manually.

For a more detailed view of what changed, open the current version and the earlier version side by side using the method described above. Version history works best when you want to know when a change happened or who made it, not just what the differences are.

Using Track Changes to record edits

If you want to compare files because someone edited one and you need to see what they changed, the best approach is to have used Track Changes from the start. If you did not, you can still turn it on now for future edits. Go to the Review tab and click Track Changes. Choose Highlight Changes. Check the box for Track Changes While Editing.

From that point forward, every edit will be marked with a colored box and a comment showing who changed it and when. You can accept or reject each change individually. If you're comparing two files where one person edited one version and another person edited another version, this does not help retroactively — but it prevents the problem in the future.

To see all tracked changes at once, go to Review and click the arrow next to Track Changes. Choose Accept/Reject Changes. Excel will walk you through each change one by one, and you can decide whether to keep it or discard it.

Using free online comparison tools

If you do not want to install software or keep both files open in Excel, free online tools can compare files for you. Diffchecker (diffchecker.com) accepts Excel files and shows differences in a side-by-side view with changes highlighted. WinMerge is free software you can read that compares files in detail and works with many file types, including Excel.

Upload or open both files in the tool. It will show you which rows and cells differ. Most tools highlight additions in green, deletions in red, and changes in yellow. This approach is useful if you lack admin access to install software, or if you want a quick comparison without opening Excel.

The downside is that online tools require you to upload your files to a third-party server. If your spreadsheets contain sensitive data, check the tool's privacy policy first. WinMerge runs locally on your computer, so your files never leave your machine.

Comparing files with different structures

If the two files have different numbers of columns, different column names, or rows in different orders, comparison becomes harder. Start by checking whether the columns are in the same order. If they are not, you'll need to reorder one file to match the other, or use a lookup formula to match rows by a unique identifier (like an ID number or name).

If one file has extra rows that the other does not, use a VLOOKUP or INDEX/MATCH formula to find matching rows. For example, if both files have an ID column, you can use VLOOKUP to pull values from the second file into the first file, then compare them in a helper column. This is more work than comparing files with identical structures, but it lets you find differences even when the files are organized differently.

If the files are very different in structure, consider whether you're actually comparing the right files. Sometimes what looks like a comparison problem is actually a question about whether the data was entered correctly in the first place. In that case, a side-by-side manual review might be faster than trying to automate a comparison.

Frequently Asked Questions

Can I compare two Excel files without opening both at the same time?

Yes. Use an online tool like Diffchecker, which lets you upload both files and shows differences without keeping them open in Excel. You can also save a comparison report by taking screenshots or exporting the results from the tool.

What if the two files have the same data but in different row orders?

Sort both files by the same column (like ID or date) so the rows line up in the same order. Then use the conditional formatting method or side-by-side view. If you cannot sort them, use VLOOKUP to match rows by a unique identifier instead of relying on row position.

Does Excel have a built-in tool specifically for comparing files?

Excel does not have a dedicated comparison feature, but conditional formatting with formulas works well for most cases. Version history in OneDrive and SharePoint shows changes over time. For more advanced comparison, use free tools like WinMerge or online services like Diffchecker.

How do I compare files if one is on my computer and one is in OneDrive?

read the OneDrive file to your computer first, then use any of the methods above. Alternatively, open the OneDrive file directly in Excel (it will open in the browser or desktop app), then open your local file in a separate window and arrange them side by side.

What is the fastest way to compare very large files with thousands of rows?

Use conditional formatting with a formula — it processes when ready and highlights all differences at once. If that is too slow, use WinMerge or another desktop comparison tool, which is optimized for large files and shows results faster than Excel's built-in features.