CSV Merge

Two files that share a column — an email, an order number, a code — joined into one, with the rows that failed to match listed separately.

Keep

Match on, first fileColumn name. Blank uses the first column.

Match on, second fileBlank uses the same name

Ignore spaces and capitals when matching

Prefix the second file's columns

First file

paste or drop a file