Has this happened to you? You create an Excel spreadsheet that you share with your coworker. She edits the document, sends it back to you, and you are left scanning through a long list of entries to try to determine what changes she made…
In our Word Advanced sessions, we talk about the nifty Compare feature in Word. This feature is absent in Excel, but there is a similar option for Excel users via a Microsoft Add In called Spreadsheet Compare. This Add In comes with PC versions of Microsoft Office 2013, 2016, and 365… in other words, you probably already have it…
Before we jump in, thank you so much to Hannah and Jamie for inspiring this Byte!
Exercise Files
If you would like to follow along, below are a couple of Exercise Files. Save these to a place where you can easily find them for the next step (e.g. Desktop).
This is a fictional class list of students. We are going to assume that the FictionalClass download is the original and the FictionalClassEdited is what your coworker altered and sent back to you.
Spreadsheet Compare Add In
To access the Spreadsheet Compare Add In, click on the Windows icon in the lower left of your task bar, and search for Spreadsheet Compare.
You will be taken to a sort of mission control for comparing spreadsheets. You haven’t loaded anything in here yet, so there is not much to see.
Compare Files
1. In the upper left, click on the first button called Compare Files.
2. A pop up screen will appear. Notice it is asking you to select an “older” file and a “newer” file.
3. Click on the folder to the right of each of these fields, and browse to find the FictionalClass (older) and the FictionalClassEdited (newer) that you downloaded from the exercise files above.
4. The two workbooks will load into the left (older) and right (newer) panes. Notice that changed cells are highlighted in green. Click on one of these cells, and it will select the corresponding cell in the other sheet.
5. Look at the bottom of the screen for an outline of the various changes that were made. This list notes all sorts of changes that were made, including the contents of cells and the formatting of cells. You can also click on any of these to be taken to the change in the worksheet on the panes above.
6. Try double clicking on one of the changes highlighted in the bottom pane. You can also access this feature by clicking on Show Details in the ribbon.
It is a little disorienting. This popup screen is showing you what was in the original document, and the change that was made in the second sheet, in kind of a strange format. Simply click on the X in the upper right to go back to the main Spreadsheet Compare screen.
Export Results
It is possible to export all the results from this comparison. in the Export group is a button called Export Results.
This will create an Excel file of all the differences between the two workbooks.
Drawbacks
While this is a nifty way to quickly see changes between two Excel files, it lacks some of the handiness of the Word Compare feature…
- You can’t accept or reject the alterations/differences, you can only see them displayed and highlighted. Any desired changes will still have to be made by hand in the source document.
- There is not a way to save a combined document containing both the original and changed document.
Other than that, a pretty cool tool!
Thoughts?
Do you think you will find a use for Spreadsheet Compare? Do tell!
100th Power User Certificate Awarded!
This is a most exciting week in Power User history! We have a three way tie for 100th WSU Microsoft Office Power User. Big congratulations to:
- Tiffany Morgan
- Matt Stiles
- Lauren Wilson
For more information about the WSU Microsoft Office Power User Program, visit wichita.edu/poweruser
This is extremely helpful when sharing document changes between multiple departments!
Great point! 🙂