Excel and CSV Comparison

Excel/CSV comparison can be widely used in

• Financial Data comparison
• Reference Data comparison
• Audit tracking

This plug-in compares the two excel files or two CSV files, where one file is original and second is updated and plug-in returns the delta from both files. This plug-in has two smart service.

• Compare Excel Docs - This smart service takes two excel files, primary key filed names, destination folder and output document name as input. It compares both files and return the difference in new excel file. The output excel file contains 3 sheets, first holds the new and updated rows, second sheets holds rows from original files which were updated and third sheet contains rows which are deleted from updated file. The output excel file captures differences in text format and does not preserve the datatype as original excel file. The plug-in also validates if both original and updated file contains single sheet, with the same name and if the number of columns in both files are same or not.
• Compare CSV Documents - This smart service takes two CSV files, destination folder and output document name as input. It compares both files and return the difference in new csv file.

Both smart service won't return expected output if any file have more than 50,000 rows.