Merge CSV files with different column orders
One CSV might list SKU,Name,Price, while another lists Name,Price,SKU. Appending rows without matching headings would place values under the wrong columns.
Match by column heading
The merge tool builds a combined list of headings and places each source value under its corresponding heading. Column order can differ between files. A column absent from one file produces an empty cell for that file’s rows.
Clean up headings first
Matching is exact. Price, price and Price are different headings. Standardize the headings in the original files, or use CSV Cleaner with whitespace trimming selected when appropriate. Each file needs unique, non-empty column headings.
Appending is different from joining
Merging here adds records from one table after records from another table. It does not combine two records with the same SKU into a single record. If a product appears in both inputs, both records remain. You can inspect repeated records with the duplicate finder afterward.
Worked example: append two exports with reordered columns
Suppose your first file has the headings SKU,Name,Price and one row A-101,Desk lamp,25. The second file has Name,Price,SKU,Stock and one row Notebook,6,B-202,12. The combined download uses the headings SKU,Name,Price,Stock. Its first row is A-101,Desk lamp,25,; its second is B-202,Notebook,6,12. The blank Stock cell means the first export did not have that column. It does not mean the stock quantity was zero.
Before merging real files, compare a few headings character for character. For example, SKU and Product SKU become two separate columns, so rename one heading in the source if they mean the same thing. Keep an original copy of each export. Then merge the tables and inspect a row from each source in the preview.
When this workflow is unsuitable
This tool appends rows. If one file contains a product catalog and the other contains inventory updates for the same SKU, appending creates two rows rather than updating a single product. That task needs a key-based join or reconciliation workflow. Also, a repeated SKU does not automatically mean an accidental duplicate: the key may represent variants or locations. Select the relevant columns before using the duplicate finder.
Review the output
Check the final row count, headings and a few records from every source file. The tools work with table values and do not preserve workbook styling, formulas or charts.