2 File Compare In Excel With Macros Sheet Download Updated

2 File Compare In Excel With Macros Sheet Download

There are two similarly-named Excel files in dissimilar folders on your reckoner. How practice you determine if the files are duplicates or different versions of the aforementioned Excel workbook? In this tutorial, nosotros'll show you how to compare two Excel files, even if you don't have Excel installed on your computer.

These comparison tools tin help you spot inconsistent data, outdated values, broken formulas, incorrect calculations, and other problems in your Excel worksheet.

i. Compare 2 Excel Sheets: View Side by Side

If you can peruse the sheet'due south data at a glance, open up them in a separate window and perform a side-by-side comparing using Excel's "View Next" feature.

Open the Excel file housing both worksheets, head to the View tab, and select New Window.

In the new window, select or switch to the (second) worksheet you want to compare.

Resize or rearrange the windows so you have a side-by-side view of both worksheets on your computer's display. Once again, this method is all-time for comparing Excel worksheets with only a few rows or columns.

If you'd rather employ Excel's comparison tool to place both windows side-past-side, check the "View" tab and select the View Side by Side icon.

Excel will immediately arrange both worksheets horizontally on your computer'due south screen. It might be a bit difficult to compare sheets in this landscape view, so go along to the next step to change the orientation to a vertical/portrait arrangement.

Caput to the "View" tab once again and select Arrange All.

Select Vertical in the "Arrange" window and select OK.

That'll stack both worksheets in a side-by-side position on your screen. There's one more setting yous demand to enable to brand the comparing a lot easier.

Tap Synchronous Scrolling and make sure information technology is highlighted. This lets you scroll through both worksheets simultaneously, allowing for a synchronous row-by-row comparison of your dataset.

If the elevation rows of both worksheets are headers, make sure you freeze them so they don't move with the residue of the dataset when you scroll through.

Select Freeze Panes and select Freeze Top Row. Repeat this pace for the second worksheet.

Select Reset Window Position to revert the comparison orientation to landscape format.

When you're washed with the comparison, select View Adjacent to revert the worksheets to their initial sizes.

At present you can gyre through both worksheets and compare them line-by-line. The major advantage of this feature is that it'due south built into all Excel versions. Still, you'll still accept to do a bunch of the work—i.e., spotting cells with varying figures, macros, formulas, etc.

2. Compare Two Excel Files Using Online Tools

There are web-based tools that offering Excel comparison services. You'll find these tools benign if you don't have Excel installed on your reckoner. This Excel Comparison tool by Aspose is a good web tool for comparison two Excel files.

Upload the first (principal) Excel file in the first box, drag the other file in the second box, and select the Compare Now button.

If the files take multiple sheets, select the sheets you want to compare in the Sheets tab. If both sheets accept cells with different values or content, the Aspose Excel comparing tool volition highlight the differences in yellowish.

The limitation of these spider web-based tools is that they mostly highlight unlike values. They can't highlight discrepant formulas, calculations, etc.

iii. Compare Two Excel Files Using "Spreadsheet Compare"

Spreadsheet Compare is a reliable software for comparison two Excel files or worksheets. Sadly, information technology'southward only available for Windows devices at the moment. It comes as a standalone program and is also built into Microsoft Excel included in the Function versions/packages: Office Professional Plus (2013 and 2016) or Microsoft 365.

Utilize Spreadsheet Compare in Excel

If your Excel app is part of the to a higher place-mentioned Office packages, you lot can access the Spreadsheet Compare tool via the "Inquire" add-in. If in that location'southward no "Ask" tab in your Excel app, hither'south how to turn it on.

Select File on the menu bar.

Select Options on the sidebar.

Select Add-ins in the sidebar, select COM Add-in in the "Manage" drop-downwards carte, and select Go.

Check the Inquire box and select OK.

Note: If you don't find an "Inquire" checkbox in the COM Add together-ins page, your Excel or Office version doesn't support Spreadsheet Compare. Or perhaps, your arrangement's admin has disabled the characteristic. Install the Office versions with Spreadsheet Compare pre-installed or contact your organization'due south admin.

Open both Excel files you want to compare in a separate window, head to the Enquire tab in the Menu bar, and select Compare Files.

Excel volition automatically add the start and second files to the "Compare" and "To" dialog boxes, respectively. Select Swap Files to interchange the primary and secondary files, or select Compare to showtime the comparison.

That'll launch Spreadsheet Compare in a new window, highlighting any disparity within your dataset. Regular cells with different values will have a green highlight. Cells with formulas are formatted purple while cells with a macro will sport a turquoise fill color.

Select Export Results to generate and save a copy of the results to your computer as an Excel certificate.

The report will signal the sheet(south) and cell references with varying datasets, besides as the verbal values of the old and new data.

You can share the Excel report with your colleagues, team, or other people working collaboratively on the file.

Employ Spreadsheet Compare equally a Standalone Program

If your Excel or Office version doesn't have the Spreadsheet Compare add together-in, install the standalone software from the programmer'due south website. When installing the setup file, brand sure you check the Register and actuate the add-in in Excel box.

Afterwards installation, launch Spreadsheet Compare and follow these steps to apply the program to compare the Excel documents.

Select Compare Files in the "Home" tab.

Select the folder icon next to the "Compare (older files)" dialog box to add together the outset document you desire to compare to the tool. Add together the second file to the "To (newer files)" box and select OK to go on.

Spreadsheet Compare will process the files and highlight cells with varying values in green.

Spot the Differences

The "View Side past Side" comparison tool is the near feasible option for Office Home or Students users. If you lot're using Excel for Microsoft 365 or Function Professional person Plus (2013 or 2016), the built-in "Spreadsheet Compare" tool is at your disposal. Only if you don't Excel on your computer, web-based Excel comparing tools will get the job done. Information technology's really that easy.

Do not share my Personal Information.