Compare two Excel sheets
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.)
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.