Orihako Data

Clean a mailing list of duplicates

"Taro@example.com" and "taro@example.com " are the same person. Normalise, then count, and the duplicates show.

Open duplicate removal

Steps

  1. Drop the CSV on "Remove duplicates" and pick the email column as the key.
  2. Use the preset "Loose (ignore spaces and case)".
  3. Check how many rows went and save.
  4. To share it, continue to "Mask personal data" from "Continue" in the bar.

Questions

Which row is kept?
The first one seen. Sort first if another should win.
Lists over 50,000 rows?
The free tier stops at 50,000 rows; the Pass opens more.

The CSV is never sent anywhere; everything runs in this browser.