Compare two Excel sheets
I have an Excel file which contains two sheets. Both contains some data. I have to find common records of the two sheets(i.e., records which are present in both sheets). I can do it manually, but is there any tools/functions which exist to do this?
microsoft-excel
edited Apr 1 '12 at 10:46
Scott C Wilson
1,70031529
asked Apr 1 '12 at 7:01
RaufRauf
1,57072131
add a comment |
I have an Excel file which contains two sheets. Both contains some data. I have to find common records of the two sheets(i.e., records which are present in both sheets). I can do it manually, but is there any tools/functions which exist to do this?
microsoft-excel
edited Apr 1 '12 at 10:46
Scott C Wilson
1,70031529
asked Apr 1 '12 at 7:01
RaufRauf
1,57072131
2
Minimally, you could convert to a csv and then run grep or something similar. You are looking for records that are identical in all ways? what do you want to do with them
– soandos
Apr 1 '12 at 7:02
1
I'd convert to CSV and then write a simple Java program or whatnot to extract the relevant sections for comparison with your favorite diff tool. Or have the program compare them directly.
– Daniel R Hicks
Apr 1 '12 at 13:29
add a comment |
I have an Excel file which contains two sheets. Both contains some data. I have to find common records of the two sheets(i.e., records which are present in both sheets). I can do it manually, but is there any tools/functions which exist to do this?
microsoft-excel
edited Apr 1 '12 at 10:46
Scott C Wilson
1,70031529
asked Apr 1 '12 at 7:01
RaufRauf
1,57072131
I have an Excel file which contains two sheets. Both contains some data. I have to find common records of the two sheets(i.e., records which are present in both sheets). I can do it manually, but is there any tools/functions which exist to do this?
microsoft-excel
microsoft-excel
edited Apr 1 '12 at 10:46
Scott C Wilson
1,70031529
asked Apr 1 '12 at 7:01
RaufRauf
1,57072131
edited Apr 1 '12 at 10:46
Scott C Wilson
1,70031529
asked Apr 1 '12 at 7:01
RaufRauf
1,57072131
edited Apr 1 '12 at 10:46
Scott C Wilson
1,70031529
edited Apr 1 '12 at 10:46
Scott C Wilson
1,70031529
edited Apr 1 '12 at 10:46
Scott C Wilson
1,70031529
1,70031529
asked Apr 1 '12 at 7:01
RaufRauf
1,57072131
asked Apr 1 '12 at 7:01
RaufRauf
1,57072131
asked Apr 1 '12 at 7:01
RaufRauf
1,57072131
1,57072131
2
Minimally, you could convert to a csv and then run grep or something similar. You are looking for records that are identical in all ways? what do you want to do with them
– soandos
Apr 1 '12 at 7:02
1
I'd convert to CSV and then write a simple Java program or whatnot to extract the relevant sections for comparison with your favorite diff tool. Or have the program compare them directly.
– Daniel R Hicks
Apr 1 '12 at 13:29
add a comment |
2
Minimally, you could convert to a csv and then run grep or something similar. You are looking for records that are identical in all ways? what do you want to do with them
– soandos
Apr 1 '12 at 7:02
1
I'd convert to CSV and then write a simple Java program or whatnot to extract the relevant sections for comparison with your favorite diff tool. Or have the program compare them directly.
– Daniel R Hicks
Apr 1 '12 at 13:29
2
2
Minimally, you could convert to a csv and then run grep or something similar. You are looking for records that are identical in all ways? what do you want to do with them
– soandos
Apr 1 '12 at 7:02
Minimally, you could convert to a csv and then run grep or something similar. You are looking for records that are identical in all ways? what do you want to do with them
– soandos
Apr 1 '12 at 7:02
1
1
I'd convert to CSV and then write a simple Java program or whatnot to extract the relevant sections for comparison with your favorite diff tool. Or have the program compare them directly.
– Daniel R Hicks
Apr 1 '12 at 13:29
I'd convert to CSV and then write a simple Java program or whatnot to extract the relevant sections for comparison with your favorite diff tool. Or have the program compare them directly.
– Daniel R Hicks
Apr 1 '12 at 13:29
add a comment |
8 Answers
8
active
oldest
votes
You might be able to use VLOOKUP depending on how complex your key structure is.
(Do a search on the Microsoft Office Support website for VLOOKUP.)
answered Apr 1 '12 at 8:07
Scott C WilsonScott C Wilson
1,70031529
Link is unfortunately dead.
– Richard
Aug 21 '18 at 11:30
1
Grumble grumble. I guess when you're Microsoft, you don't have to worry about creating 301 redirects when you restructure a site.
– Scott C Wilson
Aug 21 '18 at 12:27
add a comment |
You can covert it .csv and there are lots of options
If you have access to Unix you can run diff <file1> <file2> or sdiff <file1> <file2>
If you have access to TortoiseSVN or TortoiseGit or Eclipse, you can diff those two files and the differences will be done on screen. For Tortoise select the two files and click Diff. For eclipse drag those two files into the gui, select and choose diff
If the files are not very big try - http://neil.fraser.name/software/diff_match_patch/svn/trunk/demos/demo_diff.html
You can put your text into the two boxes and run a diff using a proven diff algorithm [Myer's diff]
If you are Windows you can use WinDiff or WinMerge - http://winmerge.org/ . I personally use WinMerge as it can diff directories.
Hope this helps.
answered Apr 1 '12 at 8:19
First ZeroFirst Zero
1612
diff/sdiffare great tools for when you have two files that are largely the same, with a few lines different. They are not so useful for files that are largely different with a few lines the same.
– Scott
Jan 10 at 23:53
add a comment |
If the cells would be in the exact same location in each sheet, you can use a third sheet, then fill down and right with this formula:
=IF('Sheet1'!A1<>'Sheet2'!A1,"Different", "-")
to compare the changes, where "Sheet1" and "Sheet2" are your sheet names.
answered May 15 '14 at 5:08
user228546user228546
175116
add a comment |
There are several formulas you can use in Excel depending on what you want to do. The formulas all require a single-column key on both tables that they use to match rows. If you don't have a single-column key, then you need to create one. For example, if your data is in B2 to H500 and the key is the first three columns, create your single-column key in cell A2 with =B2&"-"&C2"-"&D2 and copy it down to the other rows. Do this in both tables and now you have a key column to use.
The main two formulas I would use in Excel are =COUNTIF(range, criteria) and =VLOOKUP(lookup_value, table_array, col_index_num, FALSE). COUNTIF counts how many times criteria in table1 is found in range table2. If the result is greater than zero, then the row is in both tables. VLOOKUP looks up the lookup_value table1 in table_array table2 and returns the value in column col_index_num. If VLOOKUP doesn't find a match, it returns NA().
If you want to see info from table 2 in table 1, use VLOOKUP. If you just want to know if a row is in both tables, use COUNTIF.
If you don't want to add anything/or change the existing Excel tables, you can link to them in Access and run a basic query there. (Let me know if you want details on how to do this.)
answered Apr 2 '12 at 19:25
mischab1mischab1
1,08469
add a comment |
This tool CompareIt does a good job at visually showing differences. It knows Excel natively.
answered Apr 1 '12 at 11:46
BilboBilbo
413
add a comment |
It's not free and it might be overkill for your needs, but Beyond Compare has done a great job of comparing Excel sheets for me.
answered Mar 14 '13 at 18:04
Luke ShaheenLuke Shaheen
138115
add a comment |
There is a specialized tool. Excel Diff seems to output result visually.
http://www.suntrap-systems.com/ExcelDiff/
Try to consider because there is a trial version.
HTH
answered May 15 '13 at 14:10
user2282466user2282466
1
add a comment |
Just my two cents, as nobody mentioned it here so far you could try also Excel Compare by Formula Software (it's paid software but comes with a free trial period).
Anyway the best solution, in my opinion, is maybe already stated on your question's comments: export to CSV and then use any diff-tool you like to compare, simple! (a list of diff-tools here)
answered Nov 13 '16 at 11:47
danicotradanicotra
1,0692621
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f407202%2fcompare-two-excel-sheets%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
8 Answers
8
active
oldest
votes
8 Answers
8
active
oldest
votes
active
oldest
votes
active
oldest
votes
You might be able to use VLOOKUP depending on how complex your key structure is.
(Do a search on the Microsoft Office Support website for VLOOKUP.)
answered Apr 1 '12 at 8:07
Scott C WilsonScott C Wilson
1,70031529
Link is unfortunately dead.
– Richard
Aug 21 '18 at 11:30
1
Grumble grumble. I guess when you're Microsoft, you don't have to worry about creating 301 redirects when you restructure a site.
– Scott C Wilson
Aug 21 '18 at 12:27
add a comment |
You might be able to use VLOOKUP depending on how complex your key structure is.
(Do a search on the Microsoft Office Support website for VLOOKUP.)
answered Apr 1 '12 at 8:07
Scott C WilsonScott C Wilson
1,70031529
Link is unfortunately dead.
– Richard
Aug 21 '18 at 11:30
1
Grumble grumble. I guess when you're Microsoft, you don't have to worry about creating 301 redirects when you restructure a site.
– Scott C Wilson
Aug 21 '18 at 12:27
add a comment |
You might be able to use VLOOKUP depending on how complex your key structure is.
(Do a search on the Microsoft Office Support website for VLOOKUP.)
answered Apr 1 '12 at 8:07
Scott C WilsonScott C Wilson
1,70031529
You might be able to use VLOOKUP depending on how complex your key structure is.
(Do a search on the Microsoft Office Support website for VLOOKUP.)
answered Apr 1 '12 at 8:07
Scott C WilsonScott C Wilson
1,70031529
edited Aug 21 '18 at 12:25
answered Apr 1 '12 at 8:07
Scott C WilsonScott C Wilson
1,70031529
answered Apr 1 '12 at 8:07
Scott C WilsonScott C Wilson
1,70031529
answered Apr 1 '12 at 8:07
Scott C WilsonScott C Wilson
1,70031529
1,70031529
Link is unfortunately dead.
– Richard
Aug 21 '18 at 11:30
1
Grumble grumble. I guess when you're Microsoft, you don't have to worry about creating 301 redirects when you restructure a site.
– Scott C Wilson
Aug 21 '18 at 12:27
add a comment |
Link is unfortunately dead.
– Richard
Aug 21 '18 at 11:30
1
Grumble grumble. I guess when you're Microsoft, you don't have to worry about creating 301 redirects when you restructure a site.
– Scott C Wilson
Aug 21 '18 at 12:27
Link is unfortunately dead.
– Richard
Aug 21 '18 at 11:30
Link is unfortunately dead.
– Richard
Aug 21 '18 at 11:30
1
1
Grumble grumble. I guess when you're Microsoft, you don't have to worry about creating 301 redirects when you restructure a site.
– Scott C Wilson
Aug 21 '18 at 12:27
Grumble grumble. I guess when you're Microsoft, you don't have to worry about creating 301 redirects when you restructure a site.
– Scott C Wilson
Aug 21 '18 at 12:27
add a comment |
You can covert it .csv and there are lots of options
If you have access to Unix you can run diff <file1> <file2> or sdiff <file1> <file2>
If you have access to TortoiseSVN or TortoiseGit or Eclipse, you can diff those two files and the differences will be done on screen. For Tortoise select the two files and click Diff. For eclipse drag those two files into the gui, select and choose diff
If the files are not very big try - http://neil.fraser.name/software/diff_match_patch/svn/trunk/demos/demo_diff.html
You can put your text into the two boxes and run a diff using a proven diff algorithm [Myer's diff]
If you are Windows you can use WinDiff or WinMerge - http://winmerge.org/ . I personally use WinMerge as it can diff directories.
Hope this helps.
answered Apr 1 '12 at 8:19
First ZeroFirst Zero
1612
diff/sdiffare great tools for when you have two files that are largely the same, with a few lines different. They are not so useful for files that are largely different with a few lines the same.
– Scott
Jan 10 at 23:53
add a comment |
You can covert it .csv and there are lots of options
If you have access to Unix you can run diff <file1> <file2> or sdiff <file1> <file2>
If you have access to TortoiseSVN or TortoiseGit or Eclipse, you can diff those two files and the differences will be done on screen. For Tortoise select the two files and click Diff. For eclipse drag those two files into the gui, select and choose diff
If the files are not very big try - http://neil.fraser.name/software/diff_match_patch/svn/trunk/demos/demo_diff.html
You can put your text into the two boxes and run a diff using a proven diff algorithm [Myer's diff]
If you are Windows you can use WinDiff or WinMerge - http://winmerge.org/ . I personally use WinMerge as it can diff directories.
Hope this helps.
answered Apr 1 '12 at 8:19
First ZeroFirst Zero
1612
diff/sdiffare great tools for when you have two files that are largely the same, with a few lines different. They are not so useful for files that are largely different with a few lines the same.
– Scott
Jan 10 at 23:53
add a comment |
You can covert it .csv and there are lots of options
If you have access to Unix you can run diff <file1> <file2> or sdiff <file1> <file2>
If you have access to TortoiseSVN or TortoiseGit or Eclipse, you can diff those two files and the differences will be done on screen. For Tortoise select the two files and click Diff. For eclipse drag those two files into the gui, select and choose diff
If the files are not very big try - http://neil.fraser.name/software/diff_match_patch/svn/trunk/demos/demo_diff.html
You can put your text into the two boxes and run a diff using a proven diff algorithm [Myer's diff]
If you are Windows you can use WinDiff or WinMerge - http://winmerge.org/ . I personally use WinMerge as it can diff directories.
Hope this helps.
answered Apr 1 '12 at 8:19
First ZeroFirst Zero
1612
You can covert it .csv and there are lots of options
If you have access to Unix you can run diff <file1> <file2> or sdiff <file1> <file2>
If you have access to TortoiseSVN or TortoiseGit or Eclipse, you can diff those two files and the differences will be done on screen. For Tortoise select the two files and click Diff. For eclipse drag those two files into the gui, select and choose diff
If the files are not very big try - http://neil.fraser.name/software/diff_match_patch/svn/trunk/demos/demo_diff.html
You can put your text into the two boxes and run a diff using a proven diff algorithm [Myer's diff]
If you are Windows you can use WinDiff or WinMerge - http://winmerge.org/ . I personally use WinMerge as it can diff directories.
Hope this helps.
answered Apr 1 '12 at 8:19
First ZeroFirst Zero
1612
answered Apr 1 '12 at 8:19
First ZeroFirst Zero
1612
answered Apr 1 '12 at 8:19
First ZeroFirst Zero
1612
answered Apr 1 '12 at 8:19
First ZeroFirst Zero
1612
1612
diff/sdiffare great tools for when you have two files that are largely the same, with a few lines different. They are not so useful for files that are largely different with a few lines the same.
– Scott
Jan 10 at 23:53
add a comment |
diff/sdiffare great tools for when you have two files that are largely the same, with a few lines different. They are not so useful for files that are largely different with a few lines the same.
– Scott
Jan 10 at 23:53
diff/sdiff are great tools for when you have two files that are largely the same, with a few lines different. They are not so useful for files that are largely different with a few lines the same.– Scott
Jan 10 at 23:53
diff/sdiff are great tools for when you have two files that are largely the same, with a few lines different. They are not so useful for files that are largely different with a few lines the same.– Scott
Jan 10 at 23:53
add a comment |
If the cells would be in the exact same location in each sheet, you can use a third sheet, then fill down and right with this formula:
=IF('Sheet1'!A1<>'Sheet2'!A1,"Different", "-")
to compare the changes, where "Sheet1" and "Sheet2" are your sheet names.
answered May 15 '14 at 5:08
user228546user228546
175116
add a comment |
If the cells would be in the exact same location in each sheet, you can use a third sheet, then fill down and right with this formula:
=IF('Sheet1'!A1<>'Sheet2'!A1,"Different", "-")
to compare the changes, where "Sheet1" and "Sheet2" are your sheet names.
answered May 15 '14 at 5:08
user228546user228546
175116
add a comment |
If the cells would be in the exact same location in each sheet, you can use a third sheet, then fill down and right with this formula:
=IF('Sheet1'!A1<>'Sheet2'!A1,"Different", "-")
to compare the changes, where "Sheet1" and "Sheet2" are your sheet names.
answered May 15 '14 at 5:08
user228546user228546
175116
If the cells would be in the exact same location in each sheet, you can use a third sheet, then fill down and right with this formula:
=IF('Sheet1'!A1<>'Sheet2'!A1,"Different", "-")
to compare the changes, where "Sheet1" and "Sheet2" are your sheet names.
answered May 15 '14 at 5:08
user228546user228546
175116
answered May 15 '14 at 5:08
user228546user228546
175116
answered May 15 '14 at 5:08
user228546user228546
175116
answered May 15 '14 at 5:08
user228546user228546
175116
175116
add a comment |
add a comment |
There are several formulas you can use in Excel depending on what you want to do. The formulas all require a single-column key on both tables that they use to match rows. If you don't have a single-column key, then you need to create one. For example, if your data is in B2 to H500 and the key is the first three columns, create your single-column key in cell A2 with =B2&"-"&C2"-"&D2 and copy it down to the other rows. Do this in both tables and now you have a key column to use.
The main two formulas I would use in Excel are =COUNTIF(range, criteria) and =VLOOKUP(lookup_value, table_array, col_index_num, FALSE). COUNTIF counts how many times criteria in table1 is found in range table2. If the result is greater than zero, then the row is in both tables. VLOOKUP looks up the lookup_value table1 in table_array table2 and returns the value in column col_index_num. If VLOOKUP doesn't find a match, it returns NA().
If you want to see info from table 2 in table 1, use VLOOKUP. If you just want to know if a row is in both tables, use COUNTIF.
If you don't want to add anything/or change the existing Excel tables, you can link to them in Access and run a basic query there. (Let me know if you want details on how to do this.)
answered Apr 2 '12 at 19:25
mischab1mischab1
1,08469
add a comment |
There are several formulas you can use in Excel depending on what you want to do. The formulas all require a single-column key on both tables that they use to match rows. If you don't have a single-column key, then you need to create one. For example, if your data is in B2 to H500 and the key is the first three columns, create your single-column key in cell A2 with =B2&"-"&C2"-"&D2 and copy it down to the other rows. Do this in both tables and now you have a key column to use.
The main two formulas I would use in Excel are =COUNTIF(range, criteria) and =VLOOKUP(lookup_value, table_array, col_index_num, FALSE). COUNTIF counts how many times criteria in table1 is found in range table2. If the result is greater than zero, then the row is in both tables. VLOOKUP looks up the lookup_value table1 in table_array table2 and returns the value in column col_index_num. If VLOOKUP doesn't find a match, it returns NA().
If you want to see info from table 2 in table 1, use VLOOKUP. If you just want to know if a row is in both tables, use COUNTIF.
If you don't want to add anything/or change the existing Excel tables, you can link to them in Access and run a basic query there. (Let me know if you want details on how to do this.)
answered Apr 2 '12 at 19:25
mischab1mischab1
1,08469
add a comment |
There are several formulas you can use in Excel depending on what you want to do. The formulas all require a single-column key on both tables that they use to match rows. If you don't have a single-column key, then you need to create one. For example, if your data is in B2 to H500 and the key is the first three columns, create your single-column key in cell A2 with =B2&"-"&C2"-"&D2 and copy it down to the other rows. Do this in both tables and now you have a key column to use.
The main two formulas I would use in Excel are =COUNTIF(range, criteria) and =VLOOKUP(lookup_value, table_array, col_index_num, FALSE). COUNTIF counts how many times criteria in table1 is found in range table2. If the result is greater than zero, then the row is in both tables. VLOOKUP looks up the lookup_value table1 in table_array table2 and returns the value in column col_index_num. If VLOOKUP doesn't find a match, it returns NA().
If you want to see info from table 2 in table 1, use VLOOKUP. If you just want to know if a row is in both tables, use COUNTIF.
If you don't want to add anything/or change the existing Excel tables, you can link to them in Access and run a basic query there. (Let me know if you want details on how to do this.)
answered Apr 2 '12 at 19:25
mischab1mischab1
1,08469
There are several formulas you can use in Excel depending on what you want to do. The formulas all require a single-column key on both tables that they use to match rows. If you don't have a single-column key, then you need to create one. For example, if your data is in B2 to H500 and the key is the first three columns, create your single-column key in cell A2 with =B2&"-"&C2"-"&D2 and copy it down to the other rows. Do this in both tables and now you have a key column to use.
The main two formulas I would use in Excel are =COUNTIF(range, criteria) and =VLOOKUP(lookup_value, table_array, col_index_num, FALSE). COUNTIF counts how many times criteria in table1 is found in range table2. If the result is greater than zero, then the row is in both tables. VLOOKUP looks up the lookup_value table1 in table_array table2 and returns the value in column col_index_num. If VLOOKUP doesn't find a match, it returns NA().
If you want to see info from table 2 in table 1, use VLOOKUP. If you just want to know if a row is in both tables, use COUNTIF.
If you don't want to add anything/or change the existing Excel tables, you can link to them in Access and run a basic query there. (Let me know if you want details on how to do this.)
answered Apr 2 '12 at 19:25
mischab1mischab1
1,08469
answered Apr 2 '12 at 19:25
mischab1mischab1
1,08469
answered Apr 2 '12 at 19:25
mischab1mischab1
1,08469
answered Apr 2 '12 at 19:25
mischab1mischab1
1,08469
1,08469
add a comment |
add a comment |
This tool CompareIt does a good job at visually showing differences. It knows Excel natively.
answered Apr 1 '12 at 11:46
BilboBilbo
413
add a comment |
This tool CompareIt does a good job at visually showing differences. It knows Excel natively.
answered Apr 1 '12 at 11:46
BilboBilbo
413
add a comment |
This tool CompareIt does a good job at visually showing differences. It knows Excel natively.
answered Apr 1 '12 at 11:46
BilboBilbo
413
This tool CompareIt does a good job at visually showing differences. It knows Excel natively.
answered Apr 1 '12 at 11:46
BilboBilbo
413
answered Apr 1 '12 at 11:46
BilboBilbo
413
answered Apr 1 '12 at 11:46
BilboBilbo
413
answered Apr 1 '12 at 11:46
BilboBilbo
413
413
add a comment |
add a comment |
It's not free and it might be overkill for your needs, but Beyond Compare has done a great job of comparing Excel sheets for me.
answered Mar 14 '13 at 18:04
Luke ShaheenLuke Shaheen
138115
add a comment |
It's not free and it might be overkill for your needs, but Beyond Compare has done a great job of comparing Excel sheets for me.
answered Mar 14 '13 at 18:04
Luke ShaheenLuke Shaheen
138115
add a comment |
It's not free and it might be overkill for your needs, but Beyond Compare has done a great job of comparing Excel sheets for me.
answered Mar 14 '13 at 18:04
Luke ShaheenLuke Shaheen
138115
It's not free and it might be overkill for your needs, but Beyond Compare has done a great job of comparing Excel sheets for me.
answered Mar 14 '13 at 18:04
Luke ShaheenLuke Shaheen
138115
answered Mar 14 '13 at 18:04
Luke ShaheenLuke Shaheen
138115
answered Mar 14 '13 at 18:04
Luke ShaheenLuke Shaheen
138115
answered Mar 14 '13 at 18:04
Luke ShaheenLuke Shaheen
138115
138115
add a comment |
add a comment |
There is a specialized tool. Excel Diff seems to output result visually.
http://www.suntrap-systems.com/ExcelDiff/
Try to consider because there is a trial version.
HTH
answered May 15 '13 at 14:10
user2282466user2282466
1
add a comment |
There is a specialized tool. Excel Diff seems to output result visually.
http://www.suntrap-systems.com/ExcelDiff/
Try to consider because there is a trial version.
HTH
answered May 15 '13 at 14:10
user2282466user2282466
1
add a comment |
There is a specialized tool. Excel Diff seems to output result visually.
http://www.suntrap-systems.com/ExcelDiff/
Try to consider because there is a trial version.
HTH
answered May 15 '13 at 14:10
user2282466user2282466
1
There is a specialized tool. Excel Diff seems to output result visually.
http://www.suntrap-systems.com/ExcelDiff/
Try to consider because there is a trial version.
HTH
answered May 15 '13 at 14:10
user2282466user2282466
1
answered May 15 '13 at 14:10
user2282466user2282466
1
answered May 15 '13 at 14:10
user2282466user2282466
1
answered May 15 '13 at 14:10
user2282466user2282466
1
1
add a comment |
add a comment |
Just my two cents, as nobody mentioned it here so far you could try also Excel Compare by Formula Software (it's paid software but comes with a free trial period).
Anyway the best solution, in my opinion, is maybe already stated on your question's comments: export to CSV and then use any diff-tool you like to compare, simple! (a list of diff-tools here)
answered Nov 13 '16 at 11:47
danicotradanicotra
1,0692621
add a comment |
Just my two cents, as nobody mentioned it here so far you could try also Excel Compare by Formula Software (it's paid software but comes with a free trial period).
Anyway the best solution, in my opinion, is maybe already stated on your question's comments: export to CSV and then use any diff-tool you like to compare, simple! (a list of diff-tools here)
answered Nov 13 '16 at 11:47
danicotradanicotra
1,0692621
add a comment |
Just my two cents, as nobody mentioned it here so far you could try also Excel Compare by Formula Software (it's paid software but comes with a free trial period).
Anyway the best solution, in my opinion, is maybe already stated on your question's comments: export to CSV and then use any diff-tool you like to compare, simple! (a list of diff-tools here)
answered Nov 13 '16 at 11:47
danicotradanicotra
1,0692621
Just my two cents, as nobody mentioned it here so far you could try also Excel Compare by Formula Software (it's paid software but comes with a free trial period).
Anyway the best solution, in my opinion, is maybe already stated on your question's comments: export to CSV and then use any diff-tool you like to compare, simple! (a list of diff-tools here)
answered Nov 13 '16 at 11:47
danicotradanicotra
1,0692621
answered Nov 13 '16 at 11:47
danicotradanicotra
1,0692621
answered Nov 13 '16 at 11:47
danicotradanicotra
1,0692621
answered Nov 13 '16 at 11:47
danicotradanicotra
1,0692621
1,0692621
add a comment |
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f407202%2fcompare-two-excel-sheets%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
Minimally, you could convert to a csv and then run grep or something similar. You are looking for records that are identical in all ways? what do you want to do with them
– soandos
Apr 1 '12 at 7:02
1
I'd convert to CSV and then write a simple Java program or whatnot to extract the relevant sections for comparison with your favorite diff tool. Or have the program compare them directly.
– Daniel R Hicks
Apr 1 '12 at 13:29