# Merge duplicate contacts from two lists

> Markdown version of https://stella.sh/how/contacts-calendar-email/merge-duplicate-contacts for agents and LLMs.
> Combine an old phone's contacts and an email account's contacts into one list with no duplicates and every number kept: Apple, Google, or Stella (stella.sh).

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.

- Checked: 13 November 2026
- Stella does it on: Windows, Mac, Linux

## Stella doing it

Recorded 13 November 2026 on Linux (Omarchy) with Claude Code with Opus, on a Claude plan.
Result: 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×.

Video (43 s): https://stella.sh/media/proofs/contacts-calendar-email/merge-duplicate-contacts/proof.mp4

Transcript:

- 0:00 Stella on a Linux computer. A phone export (.vcf) and an email export (.csv) are in Downloads.
- 0:02 The prompt: combine them with no duplicates and no lost numbers or emails.
- 0:12 Stella replies: people on both lists become one contact, and it will flag matches it isn't sure of.
- 0:17 Matching contacts, sped up 5×.
- 0:29 Done: 96 contacts in Merged contacts.vcf, Bob/Robert-style pairs merged, the two Sam Patels kept apart.

What Stella does:

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 to paste

```text
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.
```

## Merge them 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 Stella 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](https://stella.sh/how/contacts-calendar-email/convert-vcf-to-excel).

**Can it remove duplicates in a spreadsheet instead?**
Yes. For any spreadsheet, see [compare two Excel files](https://stella.sh/how/pdf-excel/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.

Sources: [Google: Merge duplicate contacts](https://support.google.com/contacts/answer/7078226), [Apple: Merge contact cards in Contacts on Mac](https://support.apple.com/guide/contacts/adrbk1456/mac), [How-To Geek: Find and merge duplicate contacts on iPhone](https://www.howtogeek.com/837552/how-to-find-and-merge-duplicate-contacts-on-iphone/).

## Related problems

- [Convert a VCF contacts file to Excel](https://stella.sh/how/contacts-calendar-email/convert-vcf-to-excel.md)
- [Convert a contacts CSV to a VCF file for your phone](https://stella.sh/how/contacts-calendar-email/convert-csv-to-vcf.md)
- [Compare two Excel sheets and list what changed](https://stella.sh/how/pdf-excel/compare-two-excel-files.md)
- [Fix garbled characters in a CSV file](https://stella.sh/how/pdf-excel/fix-garbled-characters-in-csv.md)
- [Convert an ICS calendar file to an Excel spreadsheet](https://stella.sh/how/contacts-calendar-email/convert-ics-to-excel.md)
- [Convert EML files to one PDF, oldest first](https://stella.sh/how/contacts-calendar-email/convert-eml-to-pdf.md)

Get Stella: https://stella.sh/download. Free with the ChatGPT or Claude plan you already have.
