Coverton BlogMerge spreadsheet rows, compare changes or join by ID
Use table merging to collect rows from several files. Use a join to add product information to an order table by code. Use comparison to find what changed between an old table and a new table.
Use the free tool →Match headers before appending rows
Merging appends rows by matching column names. Rename equivalent columns first when their names differ. Retain source labels when you need to trace a result row to its original file.
Joins and comparisons need reliable keys
Joining matches a code or ID in two tables. Duplicate keys in the reference table are rejected instead of unexpectedly multiplying rows. Comparison requires unique keys in each table and does not count reordered rows as content changes.
Check formula results and missing keys
XLSX processing reads values and cached formula results from the selected sheet without recalculating formulas. Missing cached results may require recalculation and saving in the source app. Compare row counts, unmatched keys and important totals before and after processing.
Choose the right tool
Example inputs illustrate the workflow; they do not promise a particular file size, recognition accuracy or compatibility.
Merge CSV and Excel tables
Combine periodic order tables by header name. Add source labels to trace each row to its input file.
Example
January.csv + February.xlsx → combined tableOpen the tool →Compare two tables
Compare revisions of prices or inventory by unique key rather than row position.
Example
old.csv + new.csv + product ID → change reportOpen the tool →Join tables by key
Attach product details to orders by code. Review unmatched keys and duplicate reference keys.
Example
orders + product catalog + code → joined tableOpen the tool →This guide describes the public web tools and their support limits. Keep your original and check the downloaded result. Coverton · Corrections and contact