Merge CSV Files by Column Locally
Union HeadersMerge dozens of CSV or TSV files locally in browser RAM—aligning mismatched column headers by name and avoiding repeated header rows.
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 namedate,region,amount
2026-01-15,US,420
---
date,amount,currency
2026-02-10,610,USDdate,region,amount,currency
2026-01-15,US,420,
2026-02-10,,610,USDHow it works
How to merge multiple CSV exports safely
Unite monthly reports or regional exports cleanly even when column order varies across files.
- Select CSV files or folderDrop 2 or more .csv/.tsv files and drag/reorder the merge sequence in the queue.
- Enable union by header nameKeep Union Columns enabled to align differing column lists and optionally add a _source_file tracking column.
- 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.