@Caroline ,
I am going to echo @Mark-Olson’s sentiment, but with a lot more wordy detail, because that’s the kind of answers I give here. ;-)
Notepad++ does not have a native compare function. Since you are saying you are using Notepad++ to compare, I have to conclude that you are using either the old Compare plugin or its much-improved successor ComparePlus. (If you are still using ComparePlugin, remove it and install ComparePlus, as that is the one that is getting continued support going forward.)
Unfortunately, even ComparePlus doesn’t have any feature to export its comparison to any format (whether it be something “standard”, like normal diff output or a patch file, or something unusual like a custom spreadsheet format)
Just so you know, Notepad++ is a text editor, and Excel natively works with binary data files. There is a text-based intermediary – the CSV format. But I cannot think of any standard CSV-based format that would be reasonable for a difference/comparison (ie, I have never heard of diff or similar tools outputting to a CSV format), so I doubt there’s anything ready-made that exists for Notepad++, any other text editor, or any command-line-based text-comparison tool like diff.
Since no one here is likely to know what are “CRIMS codes” or what “RPA running [in Excel]” is, or what format that spreadsheet-based tool would want the “differences” in for comparison, there’s not much else we can do at this point.
If you were to give us some short dummy “CRIMS”, along with a table
| header 1 | h2 | h3 |
|---|---|---|
| A1 | B1 | C1 |
| A2 | B2 | C2 |
| A3 | B3 | C3 |
header 1
header2
header3
A2
B2
C2
A3
B3
C3
A4
B4
C4
And show us what pieces from the CRIMS codes (or the “comparison of CRIMS codes”) map into each of those cells.
If it’s not too complicated, someone might be able to create a script for the PythonScript plugin that would take one or more CRIMS files and create the text-based CSV spreadsheet, which you could then open in Excel and use the “RPA” tool. And if the CRIMS codes and/or the difference format that you want is too complicated, it might be beyond the scope of free help in a text editor forum; so don’t be surprised if no one is able to help you with that, unless it’s just a simple mapping from a simple data format.
(However, if comparing the differences between two CRIMS codes is something that people in your field often do with an RPA running in Excel, it would very much surprise me if there weren’t already tools – either command-line or Excel/VBA-based – that didn’t do the comparison or otherwise convert the CRIMS codes into the right format to read in Excel. In which case, it’s not a question for Notepad++ users.)