Move contacts between a phone and a spreadsheet

How contacts are stored in a .vcf file, why names turn into codes in some converters, and how to go from phone to spreadsheet and back without losing numbers.

Updated . How guides are checked

Primary sources checked

Phones export contacts as .vcf files of vCards. Converting one to CSV gives a sortable spreadsheet; converting a CSV back writes a .vcf a phone can import. Watch for quoted-printable names in older exports, keep a header row, and never upload a contacts list to a site that keeps it.

Contacts live in two very different places. On a phone or in an email account they are cards, each with a name, several numbers and addresses, and labels such as mobile or work. In a spreadsheet they are rows and columns, which is where people want them when a list needs cleaning, merging, sorting or sharing. Moving between the two is a common job, and it is where names get mangled and numbers go missing.

The bridge between them is the .vcf file. Almost every address book can export one and import one. This guide explains what is inside it, where conversions go wrong, and how to make the round trip safely.

What is inside a .vcf file

A .vcf file is plain text, a series of contact cards in the vCard format. Each card begins with BEGIN:VCARD and ends with END:VCARD, and every line between is one field: FN for the full name, N for the name split into family and given names, TEL for a phone number, EMAIL, ORG for the organisation, ADR for an address, and so on. Labels such as mobile or work ride along as parameters, for example TEL;TYPE=CELL.

The format is an open standard. Version 3.0 is defined in RFC 2426 and version 4.0 in RFC 6350. Version 2.1 is older and was never an IETF standard, but many phones still export it, and it is the version that causes most of the trouble.

Two rules in the standards matter to anyone converting a file. A long line may be folded: broken onto the next line, which then starts with a space. And certain characters inside a value are escaped with a backslash: a comma, a semicolon and a line break. A converter that ignores either rule cuts addresses in half or splits a company name at its comma.

Why names turn into codes

Version 2.1 cards often mark a value with ENCODING=QUOTED-PRINTABLE. That is the quoted-printable encoding defined for email in RFC 2045: every byte outside plain ASCII is written as an equals sign and two hex digits, so a name in Hindi becomes a run like =E0=A4=B0=E0=A4=B5=E0=A4=BF, and a long value is broken over lines that each end with an equals sign.

A converter that does not decode this shows the codes in your spreadsheet instead of the name. It is the most common complaint about contact converters, and the reason a list of mostly Indian, Arabic or Russian names can come out unreadable. The fix is simply to decode the encoding before writing the row, which VCF to CSV does, for any script.

From phone to spreadsheet

Export the contacts as a .vcf from the phone or from your email account’s contacts page. Convert it to CSV. Each contact becomes a row with the full name, given and family names, each phone and email address with its label, the organisation, title, address, birthday, note and website. A contact with three numbers gets three phone columns; the file has as many as the busiest contact needs.

The CSV follows the usual conventions set out in RFC 4180: a header row, commas between fields, and quotes around any value that contains a comma or a line break. It is UTF-8, so when a spreadsheet program asks which encoding the file uses, choose UTF-8 and names in other scripts will read correctly.

Once it is a spreadsheet, the list is easy to work with. Remove duplicates finds contacts entered twice, and Filter rows keeps only the ones you want, such as everyone at one company.

From spreadsheet back to phone

Going the other way needs the spreadsheet to say what each column is. Keep a header row and use plain names: Name or Full name, First name and Last name, Phone or Mobile, Email, Company, Title, Address, Birthday, Notes, Website. CSV to VCF matches columns by those names, keeps every phone and email column, and tells you which columns it did not recognise, so a heading it missed is visible before you import a few hundred contacts with a field left out.

It writes vCard 3.0, escaping commas and semicolons inside values as RFC 2426 requires, so “Acme; Ltd” stays one company name. Open the file on the phone, from its files or from an email to yourself, and the contacts app offers to add the cards. If the list started in Excel, save it as CSV first, or use Excel to CSV.

Before you import

Try a handful of rows first. Import a file with three or four contacts, check that names, numbers and labels landed where you expected, then import the rest. It is much easier than undoing a few hundred cards with a field in the wrong place.

Mind duplicates too. Depending on the address book, importing a list that overlaps with contacts already on the phone can add second copies rather than merge them, so it is safer to clean the spreadsheet against an export of what is already there.

Keep the list private

A contacts file is other people’s personal data: names, phone numbers, email and home addresses. Uploading it to a converter that stores files, even for an hour, hands that data to a third party. The two converters linked here run entirely in your browser. The file is read and written on your device, and nothing is sent anywhere.

Tools for this guide

Frequently asked questions

What is a VCF file?

A text file of contact cards in the vCard format. Each card starts with BEGIN:VCARD and ends with END:VCARD, with one line per field, such as FN for the full name and TEL for a phone number. The format is published as an IETF standard.

Why do names show as =E0=A4 codes after converting?

The export used vCard 2.1, which stores names with letters outside plain English as quoted-printable codes and splits long values over lines. A converter has to decode them; ones that do not print the codes instead of the name.

Can I edit contacts in Excel and put them back on my phone?

Yes. Convert the VCF to CSV, edit the spreadsheet, save it as CSV, then convert it back to VCF and import that file. Keep the header row so each column is matched to the right field.

Is it safe to use an online contacts converter?

Only if it does not keep the file. A contacts list is other people's names, numbers and addresses. The converters linked here run in your browser and never upload the list.

Primary references