Have you ever ended up with two versions of the same Excel file and no idea which one is current? Maybe a colleague sent you an updated spreadsheet, or you found two files with nearly identical names sitting in the same folder. Figuring out what actually changed between them is a pain, especially when you’re staring at hundreds of rows of data.
Good news: there are several ways to compare two Excel files and highlight the differences, whether you want a quick visual check or a detailed cell-by-cell breakdown. In this guide, we’ll walk through four methods, from Excel’s built-in side-by-side view to Microsoft’s dedicated Spreadsheet Compare tool to free online options, so you can pick the one that fits your situation.
Before we dive in, it helps to know which method is right for you:
- Need a quick visual scan? Use Excel’s View Side by Side feature.
- Want cells with differences automatically highlighted? Use Conditional Formatting or Spreadsheet Compare.
- Don’t have Excel installed? Use a free online comparison tool.
- Need a full audit report covering formulas, macros, and formatting? Spreadsheet Compare is your best bet.
Method 1: Compare Two Excel Sheets Side by Side (Quick Visual Check)
This is the simplest approach and it’s built right into Excel, with no extra tools needed. The catch is that it’s purely a visual aid; Excel won’t automatically flag differences for you. You’ll still have to eyeball the data yourself. That said, it works great for smaller spreadsheets where you can spot changes at a glance.
One important thing to know: this method works best when you want to compare two worksheets inside the same workbook. If you’re comparing two completely separate Excel files, just open both files first and then follow the same steps.
Step 1: Open a New Window for Your Workbook
Open the Excel file that contains both worksheets. Then go to the View tab and click New Window. This opens a second instance of the same workbook so you can view two sheets at once.
Step 2: Switch to the Second Worksheet in the New Window
In the new window that just opened, click the tab for the second worksheet you want to compare (the one at the bottom of the screen). Now you have one window showing Sheet 1 and another showing Sheet 2.
Step 3: Turn On View Side by Side
Head back to the View tab and click the View Side by Side button. Excel will immediately arrange both windows on your screen.
By default, Excel stacks the windows horizontally (one on top of the other), which isn’t ideal for comparing columns. Let’s fix that.
Step 4: Arrange the Windows Vertically
Click the View tab again and select Arrange All.
In the dialog box that appears, select Vertical and click OK. This places both spreadsheets side by side so you can compare columns much more easily.
Step 5: Enable Synchronous Scrolling
Back on the View tab, make sure Synchronous Scrolling is turned on (it should highlight when active). This is the feature that makes both windows scroll at the same time, so when you move down in one sheet, the other one moves with it. Super handy for row-by-row comparisons.
Step 6: Freeze the Header Row (Optional but Recommended)
If your spreadsheets have header rows, freeze them so they stay visible as you scroll. Click on the first worksheet window, go to View > Freeze Panes > Freeze Top Row. Then repeat for the second window.
Now scroll through both sheets and compare them line by line. When you’re done, click View Side by Side again to return both windows to their normal sizes.
Bottom line on this method: It’s great for a quick sanity check, but you’re doing all the spotting yourself. If you have more than a few dozen rows, you’ll want one of the methods below that actually highlights differences for you automatically.
Method 2: Highlight Differences Automatically with Conditional Formatting
If you want Excel to do the heavy lifting and color-code cells that don’t match, Conditional Formatting is the way to go. This method works entirely inside Excel, with no add-ins or extra tools required.
The key thing to understand here: this approach compares two sheets within the same workbook. If your data is in two separate files, copy one sheet into the other workbook first (right-click the sheet tab > Move or Copy > select your target workbook).
Step 1: Select the Range You Want to Compare
Click on the first sheet you want to compare. Select the range of cells you want to check, for example, A1:D100. If you’re not sure of the exact range, press Ctrl + Shift + End (Windows) or Cmd + Shift + End (macOS) to select everything from A1 to the last used cell.
Step 2: Open Conditional Formatting
With your range selected, go to the Home tab and click Conditional Formatting > New Rule.
Step 3: Set Up the Formula Rule
In the New Formatting Rule dialog, select Use a formula to determine which cells to format. In the formula box, type a formula that compares the current cell to the corresponding cell on your second sheet.
For example, if your second sheet is named “Sheet2” and you’re comparing starting from cell A1, use this formula:
=A1<>Sheet2!A1
This tells Excel: “Highlight this cell if its value doesn’t match the same cell on Sheet2.” Make sure the cell reference in the formula matches the top-left cell of the range you selected in Step 1.
Step 4: Choose a Highlight Color
Click the Format button, go to the Fill tab, and pick a color. Something bright like yellow or orange works well. Click OK twice to apply the rule.
Any cell that differs from its counterpart on Sheet2 will now be highlighted in the color you chose. It’s that simple.
Watch out for this: Conditional Formatting only compares the values displayed in cells. It won’t catch differences in formulas or cell formatting. For that level of detail, you’ll want Method 3 or 4 below. Also, make sure your formula references the correct sheet name. If your sheet has a space in its name (like “Sales Data”), wrap it in single quotes: =A1<>'Sales Data'!A1.
Method 3: Use a Free Online Excel Comparison Tool
Don’t have Excel installed, or just want a fast no-fuss option? There are web-based tools that can compare two Excel files right in your browser, with no software needed.
One solid option is Aspose’s free Excel Comparison tool. Another worth checking out is xlCompare, which offers both an online comparison workflow and a desktop version if you need more privacy (since you’re not uploading files to a third-party server).
Important note before you upload: These are third-party websites. If your spreadsheets contain sensitive or confidential data, think twice before uploading them to an online tool. For private data, stick with Method 2 or Method 4.
Step 1: Upload Your Files
Go to the Aspose Excel Comparison tool. Upload your first (original) Excel file in the left box, and drag or browse to your second file in the right box. Then click Compare Now.
Step 2: Review the Results
If your files have multiple sheets, use the Sheets tab to select which ones to compare. Cells with different values will be highlighted in yellow, making them easy to spot.
Heads up: Most online tools, including Aspose, only highlight cells with different values. They typically won’t catch differences in formulas, formatting, or macros. For a complete audit, you’ll need Spreadsheet Compare (Method 4 below).
Method 4: Use Microsoft Spreadsheet Compare for a Full Audit
If you need the most thorough comparison possible, one that catches differences in formulas, cell values, formatting, and even VBA macros, Microsoft’s Spreadsheet Compare tool is the gold standard. It produces a color-coded report and can even export the results as an Excel file you can share with your team.
The trade-off: it’s Windows-only, and it’s only available if you have one of these Microsoft 365 or Office editions:
- Microsoft 365 Apps for Enterprise
- Office Professional Plus (2013, 2016, 2019, or 2021)
If you’re on a Home or Student edition of Office, or you’re on a Mac, this tool won’t be available to you. Use Method 2 or 3 instead.
There are two ways to run Spreadsheet Compare: directly from the Start menu as a standalone app, or from inside Excel via the Inquire add-in. We’ll cover both.
Option A: Run Spreadsheet Compare as a Standalone App
Step 1: Open Spreadsheet Compare
Click the Start button and type Spreadsheet Compare in the search bar. Click the app when it appears in the results.
Step 2: Click Compare Files
In the Spreadsheet Compare window, click Compare Files on the Home tab.
Step 3: Select Your Files
Click the folder icon next to the Compare box and browse to your older (original) file. Then click the folder icon next to the To box and select the newer file. Click OK to start the comparison.
Good to know: you can compare two files with the same name as long as they’re stored in different folders. Microsoft explicitly supports this.
Step 4: Review the Results
Spreadsheet Compare will open a color-coded results view. Here’s what the colors mean:
- Green: Cells with different values
- Purple: Cells where formulas differ
- Turquoise: Cells with macro differences
Step 5: Export the Results (Optional)
Want to save or share the comparison report? Click Export Results to save a copy as an Excel file. The report lists every difference by sheet name, cell reference, and the old vs. new values, which is great for auditing or sharing with your team.
Option B: Use Spreadsheet Compare from Inside Excel (via the Inquire Add-in)
If you’d rather launch the comparison from within Excel itself, you can do it through the Inquire add-in. If you don’t see an Inquire tab in your Excel ribbon, here’s how to turn it on.
Step 1: Open Excel Options
Click File on the menu bar, then click Options at the bottom of the left sidebar.
Step 2: Go to Add-ins
In the Excel Options dialog, click Add-ins in the left sidebar. At the bottom of the page, you’ll see a Manage dropdown. Set it to COM Add-ins and click Go.
Step 3: Enable the Inquire Add-in
Check the box next to Inquire and click OK. You should now see an Inquire tab appear in the Excel ribbon.
Note: If there’s no Inquire option in the list, your edition of Office doesn’t include Spreadsheet Compare, or your organization’s IT admin may have disabled it. In that case, use Method 2 or try the standalone app approach above.
Step 4: Compare the Files
Open both Excel files you want to compare. Then click the Inquire tab in the ribbon and select Compare Files. Excel will automatically populate the Compare and To fields with the two open workbooks. You can click Swap Files if they’re in the wrong order, then click Compare to run the comparison.
The results will look exactly the same as the standalone app, with color-coded differences, a detail pane at the bottom, and the option to export the report.
Tips and Troubleshooting
Common Issues
Problem: Spreadsheet Compare says it can’t open one of the files
This usually means the workbook is password-protected. Spreadsheet Compare will prompt you to enter the password. Just type it in and the comparison will proceed normally.
Problem: Conditional Formatting isn’t highlighting any differences, but I know they exist
Double-check your formula. Make sure the sheet name in the formula exactly matches the tab name in your workbook (including capitalization and spaces). If the sheet name has spaces, wrap it in single quotes: =A1<>'My Sheet'!A1. Also check that the cell reference in the formula matches the top-left corner of your selected range.
Problem: The comparison is flagging cells as different even though they look the same
This is a sneaky one. Invisible characters (like extra spaces or line breaks) and different cell formatting can cause false mismatches. Try using Excel’s TRIM() function to clean up any stray spaces, or check whether one cell is formatted as text and the other as a number.
Problem: I’m on a Mac and Spreadsheet Compare isn’t available
Spreadsheet Compare is a Windows-only tool. If you’re on macOS, use the Conditional Formatting method (Method 2) or an online tool like Aspose or xlCompare instead.
Pro Tips
- Don’t use generic text diff tools on Excel files: Excel files are binary (not plain text), so tools designed for comparing code or text documents won’t work reliably on .xlsx files. Stick to the methods in this guide.
- Comparing files with the same name? No problem. Spreadsheet Compare handles this as long as the files are in different folders. Just browse to each location separately when selecting your files.
- Need to compare specific columns only? With Conditional Formatting, select just those columns before creating your rule instead of selecting the entire sheet.
- Working with sensitive data? Skip the online tools and use Spreadsheet Compare or Conditional Formatting locally. Your data never leaves your computer.
Which Method Should You Use?
Here’s a quick summary to help you choose:
| Method | Best For | Highlights Differences Automatically? | Works on Mac? |
|---|---|---|---|
| View Side by Side | Quick visual check on small datasets | No, manual inspection only | Yes |
| Conditional Formatting | Highlighting value differences in specific ranges | Yes (values only) | Yes |
| Online Tool (Aspose/xlCompare) | No Excel installed; non-sensitive data | Yes (values only) | Yes |
| Spreadsheet Compare | Full audit: values, formulas, formatting, macros | Yes (values, formulas, macros, formatting) | No, Windows only |
Figuring out what’s different between two Excel files doesn’t have to be a headache anymore. For a quick look, View Side by Side does the job. For automatic highlighting, Conditional Formatting is fast and free. And if you need a proper audit trail, one that catches formula changes and macro differences, Spreadsheet Compare is the tool to reach for. Pick the method that fits your situation and you’ll have your answer in minutes.