Spreadsheet Compare Not Available? Here's What to Use Instead

If Spreadsheet Compare is missing, first check your Excel edition and platform. It is a separate Microsoft comparison tool, and installing Excel does not mean your license includes it. If your immediate job is to find changed customer balances, prices or invoice records, you can also compare the two tables by ID without installing that application.

Why Spreadsheet Compare is not available

Microsoft’s Spreadsheet Compare overview identifies Microsoft 365 Apps for enterprise as an eligible plan. Its basic tasks guide also lists Office Professional Plus 2013, 2016 and 2019. A Microsoft 365 subscription by itself is not enough to establish eligibility; check the exact product your organization provides.

There are three different situations to separate: the application is missing, the Inquire tab is hidden, or an unrelated command called Compare and Merge Workbooks is unavailable. They have different causes. Repeatedly searching the ribbon will not add a tool that your edition does not include.

If your Windows edition includes Inquire, check the add-in

Microsoft documents Inquire for eligible Excel for Windows editions. In Excel, open File → Options → Add-ins, select COM Add-ins in Manage, then choose Go. If Inquire is listed, enable it and confirm. If it is absent, check your edition and ask your administrator whether it has been made unavailable.

For an eligible installation, you can also search Windows for Spreadsheet Compare as a separate application. If you use a Mac, follow the Mac comparison guide instead of looking for Windows COM add-ins.

Choose the comparison you actually need

For example, sorting a customer export by name can move a customer from row 8 to row 40 without changing the record. Comparing A8 to A8 across the files would compare different customers. A stable customer ID keeps those records together.

Compare two exports without Spreadsheet Compare

TidyCell Compare Files compares selected XLSX or CSV tables by a single or composite record key. It produces a separate report rather than rewriting either original.

1. Choose the earlier export as the first file and the later export as the second. If a workbook has multiple worksheets, select the table you need.
2. Check the suggested ID and comparison fields. Use a unique ID, or a combination such as SKU plus Warehouse.
3. Review Added, Removed, Changed, Unchanged and Needs review. A removed record means absent from the second export; it does not prove that someone deleted it from the source system.
4. Check the row reconciliation totals. Resolve missing or duplicate IDs rather than treating them as definite matches.
5. Download the XLSX report. It contains Summary, Records, Cell changes and Needs review worksheets, with source coordinates for inspecting differences.

The comparison uses stored typed values and saved formula results. It does not recalculate formulas, compare formula text, or audit workbook formatting and macros. If those are your task, choose a workbook inspection method instead. Selecting files for this local Compare workflow keeps their contents in your browser.

A formula option for checking missing IDs

For a small list, copy the second export’s ID column into a sheet called Later in a working copy. With an earlier ID in A2, use =COUNTIF(Later!$A$2:$A$1000,A2). Extend the range to include your full list. Zero means no match; more than one means the ID repeats. Reverse the check to find IDs that appear only in the later list.

COUNTIF is a presence check, not a complete comparison of amounts or statuses. It has its own matching rules, including case-insensitive text matching and wildcard handling. Use a known example to check that those rules fit your IDs. The two-list comparison guide explains the next step of matching IDs before comparing fields.

Is Compare and Merge Workbooks the same tool?

No. Compare and Merge Workbooks belongs to Excel’s legacy Shared Workbook workflow. A greyed-out legacy merge command does not establish whether Spreadsheet Compare is installed. Do not enable an old sharing workflow just to compare two unrelated exports. Use the greyed-out command checklist to distinguish a missing add-in from a disabled comparison or legacy merge command.

Check one known difference before trusting the report

Choose a record whose change you already understand. Confirm its ID, earlier value and later value in the report. Then check a record that moved but stayed the same. Those two checks help distinguish a useful record comparison from a long list of row-position differences.