How to deduplicate supplier names in excel before procurement analysis
- Step 1Export vendor master — Download your vendor/supplier list from your ERP as an XLSX file.
- Step 2Upload and set key column — Use the supplier_name or vendor_name column as the key. Set threshold to 80%.
- Step 3Review fuzzy matches — Check matches like 'IBM Corp' / 'International Business Machines' — adjust threshold as needed.
- Step 4Download and import — Download the consolidated list and use it to normalize vendor names in your spend data.
Frequently asked questions
What about vendors with the same parent company?+
Fuzzy dedup works on the name string only. 'Pepsi Co' and 'Frito-Lay' won't match — parent-child hierarchy requires a separate reference table.
Can I run this on 50,000 vendor rows?+
Yes with Pro tier (50MB file limit, 100K row limit). Fuzzy dedup on 50K rows may take 30–60 seconds in-browser.
Privacy first
Every JAD Excel tool runs entirely in your browser using SheetJS and ExcelJS. Your spreadsheets, formulas, and data never leave your device — verified by zero outbound network requests during processing.