Merge CSV files without duplicates
Turn this on when the files overlap and you want one copy of each identical row.
Identical rows are removed after the files are stacked. Headers are still united if they differ.
🔒 Your files stay in your browser and are never uploaded
If Excel asks to remove leading zeros, click "Don't Convert" to keep them.
- The sample repeats a row across the two files.
- Remove duplicate rows is already on.
- The result count is the rows that remain, and the line under it is how many were removed.
Common problems
Use this page when the files overlap and you want one copy of each identical row. The first copy, in file order, is the one that stays. A later row is removed only when every cell matches. The same id with a different name is kept, because the whole row is different. After the run, the line under the count says how many duplicate rows were removed and how many rows remain. Blank rows, if the file had any, are counted separately so you can check that the numbers add up. This is not the page for comparing only one column. If only some columns should decide a match, use the duplicate tool and tick those columns there.
Which copy is kept?
The first one, in file order.
Does a different name with the same id count as a duplicate?
Not in this setup. The whole row has to match. Use the duplicate tool if only some columns matter.