Merge CSV files
Combine several CSV or Excel files into one table. Columns are matched by header name, and you can add a column that shows which file each row came from. Free, nothing is uploaded.
When to use it
Reports often arrive as one file per month, region or branch. Merging them by hand means copy and paste and a lot of mistakes.
Add several CSV files and this tool stacks them into one file. It matches columns by name, so files with the same headers line up even if the column order differs.
How it works
- Drop in two or more CSV files. Excel files work too.
- Choose whether the files have header rows, and whether to add a source column.
- Check the preview, then download one merged CSV or Excel file.
Questions
What if my files have different columns?
With header rows turned on, columns are matched by name. Any column that is missing from a file is left blank for that file’s rows, and the page lists which columns do not appear in every file.
Do the files need to be in the same order?
Rows are added in the order of the file list. Use the up and down buttons to change it before you download.
Can I tell which file a row came from?
Yes. Tick the option to add a Source file column and each row gets the name of the file it came from.
Are my files uploaded?
No. Merging happens in your browser tab. Your files are not sent to a server.
Did this help?
Tell me what worked, what broke, or what tool you want next. I read every message.
Send feedback