LikeOffice Excel Compare is a unique tool which lets you analyze differences in Excel documents. It was award prizes for its simplicity and effectiveness.
It does a Logical and a Visual comparison.
LikeOffice excel Compare saves you the trouble of manually searching for differences and offers you computer-aided comparing of Excel files. It does two types of excel comparisons:
Visual comparison - comparing between two worksheets in a “not a smart way”, meaning it compares between cell A1 in the Base Worksheet to cell A1 in the Compared Worksheet and back and forth and so on and so forth.
Logical comparison
Comparing of two excel worksheets according to a key Field (like ID or product number etc'), located in Column A of each worksheet. The results are reported to a separate worksheets which includes the following five reports:
- Additional Rows - meaning, what records were added to the Compared worksheet?
- Deletions Rows - meaning, what records were deleted from Base worksheet?
- Key Change - meaning, what records with the same Key Field were changed? What are the changes?
- Joint Records - meaning, what are the only records that appear in both, Base worksheet and Compared Worksheet, with the same Key Field?
- All records - meaning, what are the records that appear in either Based Worksheet or Compared Worksheet?
Records that appear in both Worksheets will appear only once in this reports. The information related to these records will be taken out of the Based Worksheet.
In Logical Comparison, the Key Field must be in column A in each of your excel worksheet. In addition, it is very recommended that the Key Field will be unique and no empty fields will be in column A. If it is not unique or if in column A there are empty fields, then you either have to fix your records or to continue with the comparison. Our Excel Compare will continue the comparison process taking into account these rejections.
Example:
Report 1: Added Records
Report 2: Deleted Records
Report 3: Changes Key Fields
Before
After
Report 4: Joint Records
|
|
A
|
B
|
C
|
|
2
|
AAAAA
|
1
|
2
|
|
3
|
DDDDD
|
3
|
4
|
|
4
|
CCCCC
|
65
|
150
|
Report 5: All Records
|
|
A
|
B
|
C
|
|
1
|
ID
|
Field 1
|
Field 2
|
|
2
|
AAAAA
|
1
|
2
|
|
3
|
BBBBB
|
|
8
|
|
4
|
DDDDD
|
3
|
4
|
|
5
|
CCCCC
|
65
|
150
|
|
5
|
GGGGG
|
|
800
|
