Is there an excel and/or copilot feature to compare two similar excel spreadsheets and identify the material differences? between the two?

Liane Williams 0 Reputation points
2024-04-19T15:42:42.9866667+00:00

There are various supplemental financial reports I produce on a monthly basis and I'm curious if there is an easy way to compare the two versions to quickly identify material changes between the two.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,947 questions
Microsoft Copilot for Microsoft 365 Development
Microsoft Copilot for Microsoft 365 Development
Microsoft Copilot for Microsoft 365: Microsoft 365 Copilot refers collectively to Copilot experiences within Microsoft 365 applications.Development: The process of researching, productizing, and refining new or existing technologies.
152 questions
Microsoft Copilot
Microsoft Copilot
Microsoft terminology for a universal copilot interface.
339 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 25,551 Reputation points Microsoft Vendor
    2024-04-22T02:03:52.2466667+00:00

    Hi,

    There is an app named Spreadsheet Compare, you can use this app to help you:

    User's image

    You can refer to this support article to get more information about this app:

    https://support.microsoft.com/en-us/office/overview-of-spreadsheet-compare-13fafa61-62aa-451b-8674-242ce5f2c986

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.


    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.