CSV File Merger
Combine files with compatible columns and handle different order and headings before download.
Comma, semicolon or tab separated, or upload a CSV or XLSX file. The first row holds the column names.
Columns are matched by name, ignoring case. A column only one file has is kept and left empty for the other.
Your result
Paste or upload two tables to stack them into one.
How to use it
- Paste or upload the first table.
- Paste or upload the second table.
- Check the preview and download the merged table.
Examples
- Different columnsid,name and id,city id,name,city with empty cells where there is no value
- Different caseName and name One column
- Source columnTick "Add a column that says which file" A source column with First or Second
Tool details and privacy
Stack two tables with similar columns into one: columns are matched by name, and a column only one file has is added.
Monthly or branch exports often come with columns in a different order or one extra column.
Options
- Columns match ignoring case and surrounding spaces.
- An optional column saying where each row came from.
Limits
- Rows are not matched on a key; use Table Join by Key for that.
- Repeats across the two files are not removed.
Privacy
What you type or open stays in your browser. Nothing is uploaded or saved on the server.
Questions
Does it reorder columns that differ?
Yes, they are matched by name.
Are two rows with the same id joined?
No, they stay two rows.
Does it read XLSX?
Yes.
Are the files uploaded?
No.