Here we give you a short step by step instruction on how to compare 2 CSV files with xlCompare and what you can do with comparison results. After this we describe you benefits you are getting if you use xlCompare with your CSV files.
1 Drop CSV files right into the xlCompare window. In a moment you'll see your files opened side by side. One file in the left panel and another file in the right panel.
xlCompare makes initial processed of the every opened CSV file and defines Key columns and Key rows on the worksheet if possible. You can change them in using Right Click menu commands if needed. But in the most cases xlCompare detects primary keys properly.
2 Now we are ready to compare 2 CSV files. Use Home | Compare Button on the Ribbon.
xlCompare opens Comparison Wizard to show you which worksheet are compared and which algorithm is used for comparison. Normally CSV files contain database tables, so CSV comparison required Database Algorithms. However you can change algorithm in this Wizard and
compare CSV files as General Worksheet or Cell by Cell if cells in your files have fixed positions and can't be moved or deleted.
Why should I use this tool, there are free on-line CSV diff tools?
Possible you are right. There are a number of free online comparators, or you can find other way to compare your CSV files for free. If you CSV files are relatively small is simple,
there are no reason to pay for a special tool. Below we describe some cases, when you can't use free online csv compare tools.
Peformance Issues If you have a file with 100,000+ rows loading it into online application will take a time and processor resources. Browsers are not adopted to display very large tables.
While xlCompare works with millions of cells.
Compare CSV file by Key Column Online CSV diff tools doesn't have a commands to define and manage Primary Keys.
Compare unsorted data. xlCompare has algorithms which designed to compare various unordered data tables. We will give you the best comparison results for your CSV files.
Save Outlined Diff Report. in xlCompare you can export comparison results into the XLSX or PDF file with color formatting.
Compare CSV files from the Command Line. Unfortunately on-line applications doesn't have a command line mode and can't be integrated into the GIT environment and other applications where CSV diff viewer is required.
Compare CSV with Accuracy This feature is not present in a free tools.
Ignore Specific Characters Simple CSV comparison applications doesn't have this option also.
Trim Strings and Convert Text Values to Numbers You can do this in Excel and paste your CSV into diff utility, but this requires extra step for you.