Stella
Contacts, calendars and email

Merge duplicate contacts from two lists

Two contact exports, 96 people, each once, with every number and email kept.

Download StellaFree with the plan you already have.

A real run on 13 November 2026, on a Linux computer, using Claude Code with Opus, on a Claude plan. The waiting is sped up; it took 1 min 43 s in real time.

The short answer.

Inside one account, iPhone's View Duplicates, the Mac's Card, Look for Duplicates and Google Contacts' Merge & fix all merge contacts with the same name. They miss “Bob” and “Robert” with the same email, can wrongly merge two different people with one name, and don't work across two accounts. Stella (stella.sh) merges two exports by matching phone numbers and emails, keeps every number, and lists the matches it wasn't sure of.

Stella does this on Windows, Mac and Linux.

What happened.

One merged list in about 1 minute 10 seconds. Checked afterwards against an answer key written before the run: 96 contacts, each of the 96 people exactly once with all their phones and emails, no record mixing two people, both Sam Patels kept separate, and both original files unchanged.

Both contact lists are made up, with 555 numbers and example emails. The work is sped up 5×.

How Stella does it.

  1. Reads both files in Downloads: 78 cards from the old phone (.vcf) and 65 rows from the email account (.csv)
  2. Spots 6 people saved twice on the phone, and 41 people who are on both lists
  3. Matches people by phone number and email, whatever the formatting or capitals, so Bob and Robert Quayle become one contact with the short name kept as a nickname
  4. Keeps the two Sam Patels apart, since they share no number or email
  5. Saves Merged contacts.vcf with 96 people, checks every number and email from both files is in it, and lists the matches worth a look

The prompt.

I've got two contact lists in my Downloads: an export from my old phone (the .vcf) and one from my email account (the .csv). Combine them into one list with no duplicates, without losing anyone's numbers or emails.

Paste it into Stella and press Enter.

This is the exact prompt from the recording. If your files are somewhere else, say where.

Do it yourself.

  1. Get both lists into one account

    On a Mac, open Contacts and use File, Import for each file, into the same account (such as iCloud). Or import both at contacts.google.com. The built-in tools only merge within one account.

  2. Mac: Look for Duplicates

    In Contacts, choose Card, Look for Duplicates, then Merge. It matches identical names, so check “Bob” and “Robert”-style pairs by hand.

  3. Google: Merge & fix

    In Google Contacts, click Merge & fix, review each suggestion and merge. Don't click Merge all until you've checked that two people with the same name aren't on the list.

  4. iPhone

    When the iPhone finds duplicates, the top of your contacts list shows Duplicates Found, View Duplicates. Tap Merge All or go through them one by one.

  5. Search for the leftovers

    Search for a few surnames and phone numbers you know were on both lists. Nicknames, maiden names and old work emails are where duplicates hide.

Where it stops.

  • Stella makes a new merged file; it doesn't change the contacts on your phone or in your account until you import it there and remove the old ones.
  • Two people with the same name and no shared number or email are kept apart and listed, so you decide. It also merged two pairs on name alone where nothing conflicted, and told you which.
  • Names, numbers and emails it reads go to the AI model you use in Stella. Nothing is uploaded to a contacts service.
  • Recorded on Linux, where Stella used only Python, built in on Mac and Linux. On Windows it may install Python first, which wasn't recorded.

Questions.

Why didn't my iPhone find all the duplicates?

It matches contacts with the same name. A contact saved as “Liz” on one list and “Elizabeth” on the other, or with a typo, isn't recognised, even if the number is the same.

Can I merge contacts from two Google accounts?

Not directly; Merge & fix only works within one account. Export both, merge them, then import the result into the account you keep.

What file should I import on my phone?

A .vcf works on iPhone, Android, Google, iCloud and Outlook. Stella saved one. To review it in a sheet first, convert the VCF to Excel.

Can it remove duplicates in a spreadsheet instead?

Yes. For any spreadsheet, see compare two Excel files or ask for duplicate rows to be removed.

Is Stella free for this?

Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.

Can I control what Stella changes on my computer?

Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.

Checked against these sources on 13 November 2026.

Stella