Loading...
Loading...
Combine two CSV files by stacking rows. The header from file A is used once, and all data rows from file B are appended below file A's rows.
The merger reads both files and appends every data row from file B after all data rows from file A. The header row from file A is used as the single header for the combined output. The header row from file B is discarded. This means both files must have identical column headers in the same order for the merged file to be correctly structured.
If the headers are in a different order between the two files, columns will be misaligned in the output. The tool shows a header comparison before merging so you can confirm they match. If they differ only in column order, reorder one file's columns using the CSV Column Extractor to select columns in the matching order before merging.
Monthly export files from accounting software, subscription platforms, and analytics tools often have the same column structure because they come from the same report definition. Merging twelve monthly export files into a single full-year dataset lets you run an analysis across all months at once rather than repeating the same query twelve times or manually copying rows in a spreadsheet.
For multi-file merges of more than two files, work sequentially: merge file A and file B, then use the output as the new file A and merge it with file C, and so on. Each pass adds the next file's rows to the bottom of the growing combined file.
Merging data from two departments is another use. If the sales team and the support team both export customer records from different tools but use agreed-upon column names, a merger produces a unified customer record set. Verify for duplicate rows after merging by sorting on a unique identifier column and scanning for adjacent identical values.
What if file B has extra columns that file A does not have?
The merger uses file A's headers. Extra columns in file B will not appear in the output. If you need to include extra columns, add those columns to file A first using the Add Column tool, then merge.
Does the merger remove duplicate rows?
No. All rows from both files are included. If the files contain overlapping records, duplicates will appear in the merged output. Run a deduplication step after merging if uniqueness is required.
Can I merge more than two files?
The tool merges two files at a time. For three or more files, merge the first two, then load the output as file A and merge it with the third file, repeating until all files are combined.