Zovo Spreadsheet Merge

Description

From the marketplace listing

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. It picks the key for you and explains why, or you name it, including a key made of two columns. Real exports rarely line up character for character. Zovo Spreadsheet Merge cleans keys in a fixed order and counts each step: extra spaces, upper/lower case, look-alike characters (Cyrillic letters, full-width digits, en dashes, accents), XLSX number formatting (12345.0, 1.2345E+05, 12,345), dashes and spaces inside IDs, leading zeros (C00123 = C123) and a letter prefix used by only one file (C123 = 123). The result says how many rows matched as typed and how many needed each clean-up, with examples. You can turn any clean-up off. If two different keys would become the same, those rows are left unmatched and listed as ambiguous instead of being guessed. Rows that still do not match are listed for both files with a likely reason: blank key, an ID outside the other file's range, a gap in the range, a different ID format, XLSX scientific notation that dropped digits, or a near miss with the closest real key. Duplicate keys in the lookup file are counted, with the rows they would add to the merge, and a many-to-many explosion is capped with a warning. Total rows and repeated header rows are removed and listed. Downloads: an XLSX workbook (Merged, Unmatched left, Unmatched right, Duplicates, Summary) and a merged CSV. Left join keeps all left rows like VLOOKUP; inner and full joins are available. It also stacks many files into one: up to 24 monthly exports whose column names or order changed during the year (Amount vs Amt, Date vs Txn Date). Columns are aligned by identical name, then the same name with different spacing, then a synonym table, then fuzzy matches listed for you to confirm. A Source file column is added, dates are read with the day/month order decided once per file, EU number formats are handled, and each column decision is listed in the workbook. Limitations: CSV, TSV and .xlsx only (save older .xls files as .xlsx); up to 100,000 rows per file for joins and 200,000 rows in total when stacking. Files are read once and downloads expire after about an hour. It does not do mail merge (letters, labels, emails).