Select the files to compare and press load to load the data
Select the primary fields and any fields to ignore, as well as whether to write the results to a text file
A difference summary is shown
There is one duplicate primary key. Duplicate key's should be 0 or some differences cannot be calculated accurately
The changes are shown
This can be filtered by field
All of these 'New Rows' are present in the second file but not the first file (by primary fields)
The 'Rows Lost' are preset in the first file but not the second
The data can be viewed and queried
The contents of the files are loaded into a pandas dataframe before any processing can occur. For larger datasets, CSV files show a large performance increase over XLSX/XLS files. After data is loaded, running comparissons is significantly less time consuming.