CSV Merger (Stack Files, Align Columns by Header Name)
Combines CSV tables into one, matching columns by their header names so a different column order or an extra column is handled.
Use the tool
Why this tool exists
Exports from the same system rarely line up exactly: the column order changes, a new column appears, a name changes case. Matching by header, not by position, avoids the classic shifted-column mistake.
The result has every column that appears in any table, in order of first appearance. Missing cells stay empty. Add a source column to see which table each row came from. Headers that differ in spelling are separate columns, so fix those first.
How to use it
- Paste the tables, each with its header, separated by a line of ---.
- Choose whether header case is ignored and whether to add a source column.
- Check the summary line for row and column counts.
- Copy or download the merged CSV.
Frequently asked questions
What if two files have different delimiters?
Set the delimiter explicitly only if all use the same; otherwise it is detected from the first line of each table.
Are duplicate rows removed?
No. Use the duplicate row remover afterwards.
What about renamed columns?
They are treated as new columns. Rename in the source first.
Is there a size limit?
Memory only; very large files are better handled with a command-line tool.