Compare CSV files online and highlight the difference
Compare CSV files online for difference. Compare two CSV files by key columns. Filter updated and equal and mismatching records.
CHOOSE FILE TYPE
XLSX\XLSM
CSV
TEXT
XML
LANGUAGE
ENG
日本語
한국인
中国語
DEU
ESP
РУС
УКР
SIGN IN
ORDER
MAXIMIZE
REPORT
FILE 1
Paste
Dedup
Del Empty
Sort
Trim
Copy
FILE 2
Paste
Dedup
Del Empty
Sort
Trim
Copy
Select Delimiter for Text Values
Ok
Cancel
Compare Tables
VLOOKUP
Merge Tables
Common Rows
Free version of xlCompare tool displays only first 200 rows of the comparison report.
To unlock xlCompare for you and remove this limitation, please order xlCompare Online license using the link below:
How to activate and use the license:
1. Click the SIGN IN button.
2. Enter your Email and Order Reference Number (you will get it by email after your order is processed).
3. Click the SIGN IN button to complete the process.
Now this service works without limitations. You can compare and merge Excel and CSV files.
Please, help us to improve our application
Rate quality of our service
Last ratings and reviews from our users
loading
rating...
loading
rating...
loading
rating...
loading
rating...
Compare two CSV Files using desktop tool
How to find differences in two CSV files with xlCompare
Open your CSV files in xlCompare application
Just drop them from the Windows Explorer into the xlCompare window. The software will open them for you.
Setup Primary Keys
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.
Use Compare Sheets command to get the Results
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.
Comparison Report for two CSV files
Changed cell value
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.
Added and Deleted rows are highlighted with red and green color
Detailed information on the changes
Filter records in CSV files with xlCompare
All cells
This is the default selection. No filtering is applied, all cells on the worksheets are visible.
Matching Rows
xlCompare displays only rows with identical cells.
Updated Rows
xlCompare display only rows that contains at least one updated cell. These rows have orange background in the heading.
Unique Rows
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.
Extract data from the CSV file into Excel workbook
Use Save | Only Visible Rows command from the right click menu on the worksheet.
xlCompare saves visible data in the XLSX file on disk. This is easy way to export block of the worksheet and send it by email to your colleague.
Get Rid of Mismatching Rows in CSV file
How to clean your CSV file from the redundant rows, that are not present in the worksheet.
First you need to compare your CSV files for differences in xlCompare.
Apply Unique Rows filter to get the mismatching rows on your screen.
Select all the rows on one side and apply the Delete command from the right click menu.
xlCompare removes rows from the worksheet.
Merge(combine) two CSV files into one
How to populate one CSV file with records from the other file.
Look into Merge tab on the ribbon
If you need to add all the mismatching rows from the left file into the right one - apply Insert Rows From Left command
All the green rows are moved into the right file in one click. Easy and convenient.
Similar command Update Cells from Left copies all the updated cells from the left file into the right one. You are getting your CSV file updated just in one click.
Compare three CSV files for diffs and matches
I have a question about xlCompare
Please, describe your question or inquiry in the form below. We will be happy to respond you!