How to merge multiple CSV files into one
To merge multiple CSV files into one, you stack their rows under a single header row. If every file has the exact same columns in the same order, copy-paste or a one-line command does it. If the columns differ, use a tool that lines up matching headers for you, like SheetSweep Merge.
Option 1: Copy and paste (small, identical files)
- Open the first CSV in Google Sheets or Excel.
- Open the next file, copy every row except the header, and paste it under the last row of the first file.
- Repeat for each file, then save or download as CSV.
This breaks down fast if one file has an extra column or the columns are in a different order, because the data ends up under the wrong headers.
Option 2: Command line (identical files)
On Windows, in the folder with your files, run copy *.csv combined.csv in Command Prompt. On Mac or Linux, run cat *.csv > combined.csv in Terminal. Both copy each file's header row into the result too, so delete the extra header rows afterward. Again, this only works when every file has the same columns in the same order.
Option 3: Excel Power Query
In Excel, Data > Get Data > From File > From Folder can combine every file in a folder. It's powerful but takes some setup, and it's Excel-only.
Option 4: SheetSweep Merge (Pro, nothing uploaded)
- Open SheetSweep Merge.
- Add two or more CSV, TSV, XLSX, or XLS files. You can mix formats.
- Check the column alignment. Columns with matching headers share a column. Headers that appear in only one file stay as extra columns, with blanks where another file doesn't have them.
- Optionally add a source-file column that tags each row with the file it came from.
- Download one spreadsheet as CSV or Excel.
All files stay in your browser while they're being stacked.
FAQ
What if my files have different columns?
Merge lines up columns by header name. Columns that only exist in one file are kept, with blanks for rows from the other files.
Can I tell which file each row came from?
Yes. Turn on the source-file column and every merged row gets tagged with its file name.
Is Merge free?
Merge is part of Pro ($29/month), which also adds Split, Compare, Bulk Clean, batch Convert, and 25 MB files. See pricing.
Merge your files
Tired of copy-pasting exports together? Try SheetSweep Merge and get one clean sheet with the headers lined up.