# Convert a VCF contacts file to Excel

> Markdown version of https://stella.sh/how/contacts-calendar-email/convert-vcf-to-excel for agents and LLMs.
> Turn a phone's contacts .vcf into an Excel sheet with one row per person and readable accented names: the Google Contacts route, or Stella (stella.sh) offline.

Opening a .vcf in Excel directly gives one line per field, not per person. The free route is to import the .vcf at contacts.google.com and Export as Google CSV, which Excel opens with one row per person (wide, with a column per phone and email). Stella (stella.sh) does it on your computer: it decodes the scrambled accents Android exports use, leaves photo data out of the cells and saves an .xlsx with one row each.

- 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: The spreadsheet in about 1 minute 40 seconds. Checked afterwards against an answer key written before the run: 85 rows, one per person, every name present with all 10 encoded accented names decoded correctly, every phone number and email in its person's row, no photo data or garbled characters in any cell, and the .vcf unchanged. The contacts are made up, with 555 numbers and example emails. The work is sped up 7×.

Video (44 s): https://stella.sh/media/proofs/contacts-calendar-email/convert-vcf-to-excel/proof.mp4

Transcript:

- 0:00 Stella on a Linux computer. An old phone's contacts export (.vcf) is in Downloads.
- 0:02 The prompt: an Excel sheet, one row per person, with name, phone numbers and email.
- 0:10 Stella replies: one row per person, saved in Downloads.
- 0:16 Reading 85 contacts, sped up 7×.
- 0:29 Done: Contacts.xlsx with 85 rows, accents decoded, a column per phone type, photos left out.

What Stella does:

1. Opens `Contacts 2026-11-02.vcf` in Downloads: 85 contacts in the vCard 2.1 format Android phones export
2. Decodes the 11 accented names stored in the phone's encoded form (like `=C3=89`), so they read correctly
3. Puts each phone type (mobile, home, work, other) in its own column, written the same way, and a second email in an Email 2 column
4. Leaves the 12 contact photos out of the sheet
5. Saves `Contacts.xlsx` in Downloads, sorted by last name, and leaves the .vcf unchanged

## The prompt to paste

```text
My old phone exported my contacts as a .vcf file (it's in my Downloads). Put them in an Excel spreadsheet, one row per person, with their name, phone numbers and email.
```

## Convert it yourself

1. **Import the .vcf into Google Contacts.** Go to contacts.google.com, click Import and choose the .vcf. Google decodes the phone's encoded names. This adds the contacts to your Google account; you can delete them afterwards.
2. **Export as Google CSV.** Select the imported contacts (they carry an “Imported on …” label), click Export and choose Google CSV.
3. **Open it in Excel.** Use Data, From Text/CSV, pick the file and click Load, so accented names come through as UTF-8. The sheet is wide: one column per field, like Phone 1 - Value and Phone 2 - Value, but one row per person.
4. **Trim the columns.** Delete the columns you don't need and keep name, phones and emails. Save as .xlsx.
5. **On a Mac without Google.** Import the .vcf into the Contacts app, but note it can't export to CSV or Excel; for that you need Google, a converter, or Stella.

## Where Stella stops

- Contact photos aren't put in the spreadsheet.
- Stella left email addresses that the old phone had saved without their accented letters as they were, and pointed them out.
- The Google route uploads your contacts to your Google account. Stella's doesn't, but what it reads while working, names and numbers included, goes to the AI model you use in Stella.
- Recorded on Linux. On a Mac or Windows PC Stella may install a small spreadsheet library first, which wasn't recorded.

## Questions

**Why does Excel show my VCF as one long column?**
A .vcf is a text file with one line per field (name, phone, email), so Excel shows each line as a row. It needs converting to put each person on one row.

**What are the =C3=89 characters in my contacts file?**
Android writes accented letters in an encoded form called quoted-printable. `=C3=89` is “É”. A proper converter decodes it; Stella did for all of them.

**Can I turn the spreadsheet back into contacts later?**
Yes: see [convert CSV to VCF](https://stella.sh/how/contacts-calendar-email/convert-csv-to-vcf). To combine two contact lists, see [merge duplicate contacts](https://stella.sh/how/contacts-calendar-email/merge-duplicate-contacts).

**Can it convert a calendar file to Excel too?**
Yes: see [convert an .ics calendar to Excel](https://stella.sh/how/contacts-calendar-email/convert-ics-to-excel).

**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: Import your contacts into Google Contacts](https://support.google.com/contacts/answer/15147365), [Fone.tips: VCF to CSV](https://fone.tips/vcf-to-csv/).

## Related problems

- [Convert a contacts CSV to a VCF file for your phone](https://stella.sh/how/contacts-calendar-email/convert-csv-to-vcf.md)
- [Merge duplicate contacts from two lists](https://stella.sh/how/contacts-calendar-email/merge-duplicate-contacts.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)
- [How to open an mbox file](https://stella.sh/how/contacts-calendar-email/open-mbox-file.md)

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