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%

1. Choosing Sales_Rep_ID as the key, the consolidated result will have only 456, 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%

2. Choosing Sales_Rep_ID and Year as 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%

3. Choosing Year as the key, and Total on Value:

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%

4. Choosing Year as the key, Total on Value, and Join on Sales_Rep_ID and Sales_Rep_Name See 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%