Combine several CSV files into one when the columns don't match
Last reviewed 2026-09-19
Joining CSV files end to end only works when every file has exactly the same columns in the same order. Exports from different dates or systems often add, drop or reorder columns, so a plain copy-and-paste puts values under the wrong headings.
Messages you might see
- “Copying CSVs together puts data under the wrong headers”
- “Merged CSV has repeated header rows or misaligned columns”
Why it happens
- The files have the same columns in a different order.
- Some files have extra or missing columns.
- The files use different delimiters, so they are not read the same way.
Try this first (free, no tool needed)
- In Excel 365 use Data > Get Data > From File > From Folder, then Combine & Transform. Power Query lines columns up by name.
- On a command line, `copy *.csv all.csv` (Windows) or `cat *.csv > all.csv` joins files, but repeats each header row and needs identical columns.
- Check each file's delimiter first, since one semicolon-separated file will break the join.
If that didn't work
These tools run in your browser. Your file is read and repaired on your own device and is never uploaded.
Multi-CSV Merger
Drop several CSVs and get one file with the columns lined up by name (case and spacing ignored), even when the files have different column orders, delimiters or extra columns. You can choose which columns to keep, tag each row with its source file and remove duplicates.
Open Multi-CSV MergerCommon questions
What happens to columns that only some files have?
They are kept as their own column, with blanks where a file did not have them, unless you choose to keep only certain columns.
Is my file uploaded anywhere?
No. The tool runs as a program inside your own browser, so the file is read and repaired on your device and never sent to a server.