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.

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.

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.

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.

Set union, which discards duplicates A, A, B, C, A, B, D becomes A, B, C, D

Joins all fields with the specified separator - if none is specified, a semicolon ; is used

Sums all the fields together. A numeric type is expected.

1. Choosing Sales_Rep_ID as the key, the consolidated result will have only 456, 123, 789.

2. Choosing Sales_Rep_ID and Year as the key:

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

4. Choosing Year as the key, Total on Value, and Join on Sales_Rep_ID and Sales_Rep_Name See screen: