
Merge sheets on messy IDs
Merge two spreadsheets on an ID column, the VLOOKUP job, and see how each row matched. Attach two CSV or XLSX files (or one workbook with two sheets, or paste the tables) and Zovo Spreadsheet Merge joins them on a key column such as customer ID, SKU or invoice number.
Example path ·
https://sheet-join.zovo.one/mcpMerges spreadsheets. matches rows of two files on a key column (VLOOKUP/XLOOKUP job) and reports each key clean-up it applied; stacks many files with drifting column names. Report the match rate, the clean-ups with counts, unmatched reasons and duplicate warnings before the download links. Do not use for mail merge (letters, labels, emails).
1 in the ChatGPT listing