Compare CSV files online and highlight the difference

Just drop them from the Windows Explorer into the xlCompare window. The software will open them for you.

Once you have your files opened, you need to make sure that Primary Keys are configured properly. This is highly important option to get the accurate results.

Each Primary Key column is marked with Key icon in the heading and highlighted with color.

If you think that you need another selection for your table, than the default one - do the right click on the column heading and set or unset the Key flag.

If you mark your column as Standard column - it will not be considered as Key.

It brings you Comparison Wizard window that contains summary of the data to be compared. After your Primary Keys are selected, just close it by pressing the Compare button and proceed to Comparison Report.

Two changed cells are highlighted with Orange fill color.

For the numeric values xlCompare adds tendency icon that indicates increase or decrease of the value.

This is the default selection. No filtering is applied, all cells on the worksheets are visible.

xlCompare displays only rows with identical cells.

xlCompare display only rows that contains at least one updated cell. These rows have orange background in the heading.

This filter shows mismatched rows on two worksheets. So, if you apply this command xlCompare shows you only green and red rows in the compared CSV files. This is usually called - difference between the CSV files.