Merge CSV Files
Quick answer
To merge CSV files online, add up to 5 .csv files with the same columns, drag them into order and click Merge and Download. The tool stacks their rows into one CSV in your browser and keeps the header row once. Columns are not re-ordered, so files must share a layout.
Click here or Drop files to upload
How to use it
- 1 Make sure every .csv has the same columns in the same order.
- 2 Add the files; the first file's header row is the one that's kept.
- 3 Click Merge and Download and open merged-file.csv in Google Sheets or Excel to check the row count.
What to expect
- The first file's header row is kept, and the same header at the top of any later file is removed, so you get one header line.
- Columns are matched by position, not by name. Check that every file uses the same columns in the same order.
- Values are copied as text, so nothing is reformatted or recalculated.
Frequently asked questions
What happens if my CSV files have different columns?
Rows are stacked by position, so mismatched columns end up under the wrong headings. Align the columns first.
How do I merge CSV files in Excel or Google Sheets?
Paste each file's rows under the first one, or in Excel use Data > Get Data > From Folder to combine files with matching columns.
Does merging change dates or leading zeros?
No. Values are copied as plain text. Spreadsheet apps may reformat them when you open the file, so import as text if that matters.
What if one file has no header row?
Only a first line identical to the first file's header is removed, so a file without a header keeps all its rows.