CSV.ink
TSV Viewer

Merge CSV Files

Combine multiple CSV files into one, matching columns by header.

Files are merged in the order listed. Columns are matched by header name.

Click to upload or drag and drop

.csv .tsv .txt · multiple files allowed

No file at hand?

How to merge CSV files online

  1. 1

    Select or drop several CSV files at once. You can add more files later.

  2. 2

    The files are merged in the order listed. Remove a file with the × button.

  3. 3

    Optionally add a column that records which file each row came from.

  4. 4

    Check the preview, then download the merged CSV.

Example: merging files with different column orders

jan.csv and feb.csv

id,name,city
1,Emma,Seattle

name,id,city,team
Liam,2,Austin,Sales

merged.csv

id,name,city,team
1,Emma,Seattle,
2,Liam,Austin,Sales

Tips for merging CSV files

Columns are matched by name

Columns with the same header end up in the same column, even if the files list them in a different order.

Extra columns are kept

A column that exists in only some files is added to the result and left empty for rows from the other files.

Track the source

Turn on the source file column to see where each row came from, for example when combining monthly exports.

Remove duplicates afterwards

If the files overlap, open the merged file in the CSV.ink editor and use "Remove duplicate rows".

Merge CSV FAQ

Is merging CSV files free?

Yes. There is no sign-up and no limit on the number of files.

Are my files uploaded?

No. The files are merged in your browser, so your data stays private.

What if the headers are different?

The result contains every column from every file. Rows simply leave the columns empty that their file did not have.

Can I merge files with different delimiters?

Yes. Each file's delimiter is detected on its own, and the result is a standard comma-separated CSV.

Is the header repeated in the middle?

No. The merged file has one header row at the top.

All CSV Tools

CSV to JSON

Convert your CSV files to JSON format with ease.

JSON to CSV

Convert your JSON files to CSV format easily.

CSV to Excel

Convert CSV files to Excel format easily

Excel to CSV

Convert Excel spreadsheets to CSV format.

Excel to JSON

Convert Excel spreadsheets (XLSX, XLS) to JSON arrays.

JSON to Excel

Convert JSON data to an Excel (XLSX) spreadsheet.

CSV Splitter

Split a large CSV file into smaller files by row count.

Merge CSV

Combine multiple CSV files into one, matching columns by header.

XML to CSV

Convert XML files to CSV format efficiently.

CSV to XML

Convert CSV files to XML format efficiently.

CSV to YAML

Convert CSV rows to a YAML list.

YAML to CSV

Convert a YAML list to a CSV table.

CSV to Markdown

Convert CSV files to Markdown tables.

Markdown to CSV

Convert Markdown tables to CSV files.

CSV to HTML

Convert CSV files to HTML tables.

HTML Table to CSV

Extract tables from HTML and save them as CSV.

CSV to PDF

Convert CSV files to PDF documents.

CSV to SQL

Convert CSV files to SQL insert statements.

CSV to vCard

Convert CSV files to vCard format for contacts.

CSV to TSV

Convert comma-separated CSV to tab-separated TSV.

TSV to CSV

Convert your TSV files to CSV format easily.

TSV to Excel

Convert your TSV files to Excel format easily.