Append rows across files
Append mode creates a union of headers by name, handles different column order, and leaves missing cells empty.
Join by a shared key
Join two files by ID, email, SKU, or another column using a left or inner join. Duplicate keys in the second file are reported and the first match is used.