Merge CSV Files by Column Locally

Union Headers

Merge dozens of CSV or TSV files locally in browser RAM—aligning mismatched column headers by name and avoiding repeated header rows.

100% Client-Side — Verify 0 bytes uploaded in Network tabVerify 0 bytes sent in Network tab

or drop files here · Ctrl V to paste · or drop multiple files / folders to merge locally
  • 0 bytes uploaded
  • Union by header name
  • Deduplicates headers + BOM

Instant Before & After Preview

Union by column name
Before (Input)jan-feb-sales.csv
date,region,amount
2026-01-15,US,420
---
date,amount,currency
2026-02-10,610,USD
After (Output).csv
date,region,amount,currency
2026-01-15,US,420,
2026-02-10,,610,USD

How it works

How to merge multiple CSV exports safely

Unite monthly reports or regional exports cleanly even when column order varies across files.

  1. Select CSV files or folderDrop 2 or more .csv/.tsv files and drag/reorder the merge sequence in the queue.
  2. Enable union by header nameKeep Union Columns enabled to align differing column lists and optionally add a _source_file tracking column.
  3. Export merged CSVDownload one Excel-safe UTF-8 BOM CSV or send straight to CSV to SQL.
Format specs:CSV (.csv)

FAQ

Frequently asked questions

What if File 2 has an extra column or columns in a different order?

Union Columns by Header Name collects the union of headers across all files and maps each row's values into the matching column cleanly.

Will header rows repeat in the middle of the merged file?

No. Deduplicate Column Headers keeps only the single top header row while stripping repeated headers from subsequent files.

Can I track which input file each merged row came from?

Yes. Enable Add Source Filename Column to append a _source_file column populated with each file's name.