How to remove near-duplicate contacts from excel before email marketing import
- Step 1Export list from your platform — Download your subscriber list as a CSV or XLSX.
- Step 2Run email exact dedup first — Use the csv-deduplicator tool on the email column to remove exact email duplicates.
- Step 3Run fuzzy dedup on name — Upload the remaining list, key on full_name, threshold 88%.
- Step 4Review and import — Check the flagged near-duplicates manually, then import the cleaned file.
Frequently asked questions
Should I dedup on email or name?+
Both. First dedup on email (exact) to remove identical email addresses, then dedup on name (fuzzy) to catch the same person with two email addresses.
What if the threshold flags too many legitimate unique contacts?+
Raise the threshold to 92–95%. You can also download the flagged pairs report and review them manually before deleting.
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.