CSV Merge

Stack two CSV files into one. Columns are matched by name, so the files do not need the same column order.

Processed on your device. Files are not uploaded

How to combine two CSV files

  1. Paste both files

    Put one in each box.

  2. Choose whether to dedupe

    Optionally drop rows that appear in both.

  3. Copy or download

    Save the combined CSV.

Worked example

This is what CSV Merge gives for its own sample values. Open the tool above and change anything to try your own.

First CSV

id,name
1,Ada
2,Linus

Second CSV

name,city,id
Grace,New York,3
Delimiter
Detect automatically
Remove rows that appear twice
No

Merged CSV

id,name,city
1,Ada,
2,Linus,
3,Grace,New York

About CSV Merge

Stack two CSV files into one. Columns are matched by name, so the files can have different column orders, and columns found in only one file are added with empty cells for the other.

FAQs

What if the columns differ?

The merged file has every column from both. Cells with no data are empty.

Can I remove repeated rows?

Yes. Turn on the option.

Can I see the differences instead?

Use CSV Compare.

Related tools