Find duplicates in a contact list and prepare a review file

A duplicate-group file with match reason, confidence tier and a proposed survivor per group.

Choose one of three approaches. The steps for that option appear below.

Choose an option above. On a phone, swipe the tabs left or right to see all options →

Claude: normalises contacts and proposes duplicate groups

Claude runs normalisation code; you approve its rules before grouping and check every proposed survivor.

  1. You

    Collect the contact CSV

  2. Claude

    Normalise contact fields with code

  3. You

    Check and approve rules

  4. Claude

    Draft duplicate groups and survivor

  5. You

    Check groups and record decisions

  1. Collect the contact CSV

    Use: You

    Have ready: contact CSV, for example 6,000 contacts with name, email, phone and company; retain original IDs.

  2. Normalise contact fields with code

    Use: Claude

    Ask Claude for normalisation rules, per-field change counts, changed-row samples and a working table retaining original IDs.

    Details

    What to paste into the tool

    Task: Normalisation report: rules applied, per-field change counts, sample of changed rows; Normalised working table with original IDs retained. Using code, normalise the fields for matching: trim spaces, case-fold the codes and strip stray punctuation. Keep every original ID and value alongside the normalised form - change nothing in the source data. Show me the exact normalisation rules you applied, per-field change counts, and a sample of changed rows.

  3. Check and approve rules before grouping

    Use: You

    Check the rules report and changed rows; approve or adjust the rules before requesting groups.

    Check

    Data owner approves the normalisation rules before any grouping; original IDs must be retained and nothing deleted. Check the normalisation rules on 20 sample contacts so that distinct people are not made to look the same.

  4. Draft duplicate groups and survivor proposals

    Use: Claude

    Ask Claude for a downloadable review file: members, matching fields, reason, confidence tier and proposed survivor per group.

    Details

    What to paste into the tool

    Task: Duplicate-group review file: group members, matching fields, match reason, confidence tier, proposed survivor per group. Using the approved normalised table and rules, group likely duplicates. For each group list the member rows with original IDs, the fields that matched, a plain-language match reason, a confidence tier (high or review), and a proposed survivor with the reason. Produce this as a downloadable review file. Merge nothing and delete nothing.

  5. Check groups and record decisions

    Use: You

    Compare matched fields and proposed survivors with source facts; record approvals or rejections.

    Check

    Check matched fields and proposed survivors against the source CSV, covering every high group and a sample of the rest. Approve or reject each group before any merge happens. Do not delete or merge records in the source system; original IDs are retained throughout.

Before you paste into any AI tool, remove any confidential information. Put it back at the end.

Tools in this workflow

Deciding between ChatGPT and Claude for this? See the comparison.

Final check

Data owner approves the normalisation approach before grouping.

Data owner approves or rejects each group before any merge happens.

Original IDs are retained and nothing is deleted.

No deletion or merge in the source system.

Check the result against your original inputs. Approve it before sharing or acting.

What still needs checking
  • Pricing, plan and file-size limits for Vizly were not captured on the cited page.
  • Whether Claude code execution file uploads fit a large contact CSV on the Free plan is unchecked; exact caps are not published on the cited page.
  • Vizly's FAQ states a free allowance of 10 messages a month; whether normalising and grouping a 6,000-row CSV fits within it, and what paid plans cost, was not captured.

Share this page