CSV Merge
A GUI tool to merge and consolidate CSV files.
Download it here.
For a tutorial on how to combine your Bill of Materials (BOM), see here.
Basic Usage
Add files by dragging and dropping them into the window.
You can also drag in whole folders and they will be recursively searched for csv files. This is useful when the actual files are structured like 'Project/Outputs/BOM.csv'.
You can delete files by selecting entries from the list and hitting the delete key. You can select all by dragging or using Ctrl+A.
Drag and drop multiple times in case you missed something. Files won't be duplicated.
Merging
Once the files are added, just hit merge.
Some files may have a different number of headers, or the columns may be in a different order. Select one of the entries to choose which file's column order to use as output.
Note
The merged output will have a column inserted named (Source) which will contain the name of the file that contained the row.
Consolidation
As with merge, select one of the files to choose a column order.
From the list choose one or more columns to act as a key.
The combination of key fields will be used to determine the number of rows.
Click on one of the Combine fields to choose the type of operation.
Combine operations
Union
Set union, which discards duplicates
A, A, B, C, A, B, D becomes A, B, C, D
Join
Joins all fields with the specified separator - if none is specified, a semicolon ; is used
Total
Sums all the fields together. A numeric type is expected.
Example
| Sales_Rep_ID | Postcode | Sales_Rep_Name | Year | Value | Commission |
|---|---|---|---|---|---|
| 456 | 2027 | Jane | 2017 | 11,444 | 5% |
| 456 | 2110 | Jane | 2017 | 30,569 | 5% |
| 123 | 2137 | John | 2017 | 83,085 | 5% |
| 789 | 2164 | Jack | 2017 | 82,490 | 5% |
| 789 | 2067 | Jack | 2018 | 23,819 | 5% |
- Choosing
Sales_Rep_IDas the key, the consolidated result will have only456, 123, 789.
| Sales_Rep_ID | Postcode | Sales_Rep_Name | Year | Value | Commission |
|---|---|---|---|---|---|
| 456 | 2027, 2110 | Jane | 2017 | 11,444, 30,569 | 5% |
| 123 | 2137 | John | 2017 | 83,085 | 5% |
| 789 | 2164, 2067 | Jack | 2017, 2018 | 82,490, 23,819 | 5% |
- Choosing
Sales_Rep_IDandYearas the key:
| Sales_Rep_ID | Postcode | Sales_Rep_Name | Year | Value | Commission |
|---|---|---|---|---|---|
| 456 | 2027, 2110 | Jane | 2017 | 11,444, 30,569 | 5% |
| 123 | 2137 | John | 2017 | 83,085 | 5% |
| 789 | 2164 | Jack | 2017 | 82,490 | 5% |
| 789 | 2067 | Jack | 2018 | 23,819 | 5% |
- Choosing
Yearas the key, and Total onValue:
| Sales_Rep_ID | Postcode | Sales_Rep_Name | Year | Value | Commission |
|---|---|---|---|---|---|
| 456, 123, 789 | 2027, 2110, 2137, 2164 | Jane, John, Jack | 2017 | 207588 | 5% |
| 789 | 2067 | Jack | 2018 | 23819 | 5% |
- Choosing
Yearas the key, Total onValue, and Join onSales_Rep_IDandSales_Rep_NameSee screen:
| Sales_Rep_ID | Postcode | Sales_Rep_Name | Year | Value | Commission |
|---|---|---|---|---|---|
| 456; 456; 123; 789 | 2027, 2110, 2137, 2164 | Jane; Jane; John; Jack | 2017 | 207588 | 5% |
| 789 | 2067 | Jack | 2018 | 23819 | 5% |