Merge CSV Files

In the second example the second file has Email before Name and a Phone column the first doesn’t have. The columns are matched by their headings, Phone is added at the end, and the cells a file doesn’t have are left empty. The summary above the result says which files were missing which columns.

How the files are combined

• Columns are matched by heading, ignoring capitals and extra spaces, so “Email” and “email ” are one column. They keep the order they first appear in.
• Each file’s heading row is used once. If two exports were pasted one after the other, the second copy of the heading row is dropped.
• Commas, semicolons, tabs or pipes: each file’s separator is detected on its own, so a semicolon CSV from European Excel and a comma CSV combine fine. Choose how to separate the result.
• Cells are kept exactly as they are, including commas, quotes and line breaks inside quoted cells, leading zeros and long numbers. Nothing is reformatted.
• Files without headings? Choose First row of each file is: data and the rows are stacked as they are.
• Remove repeated rows leaves out a row that’s exactly the same as an earlier one, even if it came from another file.
• Add a “Source file” column to see which file each row came from.

Files saved by older versions of Excel (not UTF-8) are read correctly too, and the downloaded CSV is saved so Excel shows accents and other characters properly.

Private: nothing is uploaded

Your files are read by your browser and combined on your computer. They’re never sent anywhere, which matters for customer lists and exports with email addresses.

Next steps

Combined a few contact exports? Clean the email list, remove duplicates by line, or sort by a column. The combined CSV stays in the box when you go to another tool.

Two exports pasted one after the other

Name,Email,City
Amy,amy@example.com,Boston
Bob,bob@example.com,Austin
Name,Email,City
Cat,cat@example.com,Denver

Name,Email,City
Amy,amy@example.com,Boston
Bob,bob@example.com,Austin
Cat,cat@example.com,Denver

Try this example

Columns in a different order

Name,Email,City
Amy,amy@example.com,Boston

Email,Name,Phone
bob@example.com,Bob,555-0101

Name,Email,City,Phone
Amy,amy@example.com,Boston,
Bob,bob@example.com,,555-0101

Try this example

Repeated rows removed

Name,Email
Amy,amy@example.com
Bob,bob@example.com
Name,Email
Bob,bob@example.com
Cat,cat@example.com

Name,Email
Amy,amy@example.com
Bob,bob@example.com
Cat,cat@example.com

Try this example