How to export Android contacts to Excel or CSV

Where your Android contacts are saved

Contacts saved to your Google Account sync with Google Contacts and appear on every Android phone where you sign in with that account. Others are saved only on the phone, on the SIM card, or in a different account. That decides which method to use:

• Everything in one Google Account: method 1 gives you a CSV file straight away.
• Contacts on the phone or SIM, or in several accounts: use method 2 or 3, which export from the phone itself.

If you are not sure, use the phone’s export. The Google Contacts app lets you choose one or more accounts to include.

Method 1: export from Google Contacts on a computer

1. Go to contacts.google.com and sign in with the Google Account your phone uses.
2. Select the contacts. Tick the box next to one contact or several, or tick any one and click Selection Actions → All at the top left.
3. At the top right, click More actions → Export.
4. Choose a format and click Export.

The export offers three formats:

• Google CSV is Google’s own layout. It is the one to keep as a backup or to move contacts to another Google Account.
• Outlook CSV uses the column names Outlook expects when it imports contacts.
• vCard makes a .vcf file for iPhone, Mac and other contacts apps.

Both CSV files open in Excel. A Google CSV is wide, though: each phone number takes a label column and a value column (Phone 1 - Label, Phone 1 - Value), and several labels can share one cell, separated by :::. For a tidier sheet, export as vCard and convert it as described below.

With a work or school account, you can’t select all the contacts in the Directory.

Method 2: export from the Google Contacts app

This is Google’s Contacts app, which Pixel and many other Android phones use.

1. Open the Contacts app.
2. At the bottom, tap Organize, then Export to file. In older versions of the app, this tab is called Fix & manage.
3. Choose one or more accounts to export contacts from.
4. Tap Export to .VCF file.

Method 3: export from Samsung Contacts

Galaxy phones come with Samsung’s own Contacts app. On One UI 7 and later:

1. Open Contacts and tap More options (⋮) at the top right.
2. Tap Settings, then Export contacts.
3. Choose Internal storage, tap Export, then tap OK.

The .vcf file is saved in the My Files app, under Internal storage → Download. Touch and hold it there to share it by Quick Share, e-mail or message. On older One UI versions, the option is under the menu (☰) → Manage contacts → Import or export contacts → Export. Exporting to the SIM card is a different option, and it keeps only names and numbers.

Turn the .vcf file into an Excel sheet

Excel can’t read .vcf files, so convert the file first. You can do this on the phone itself, in Chrome, or on a computer after sending the file there.

1. Open the VCF to CSV converter and choose the .vcf file (on the phone, from Downloads). Several files can be combined, for example one per account.
2. Pick the Spreadsheet layout for Excel or Google Sheets. Outlook CSV and Google Contacts CSV are for importing into those apps.
3. Download an Excel workbook (.xlsx), which keeps phone numbers as text, or a CSV.

Each contact becomes one row, with a separate column for every phone number, e-mail and address. Older phones save accented letters in a coded form called quoted-printable, which shows as =C3=A9 in a text editor. The converter decodes it, so names come out correctly. Everything happens in your browser and nothing is uploaded. To read the file as contact cards first, use the VCF viewer.

If something looks wrong

• Contacts are missing from the Google export. They are saved on the phone or SIM card, not in your Google Account. Export them from the phone with method 2 or 3.
• Numbers show as 4.47E+11 in Excel. Excel changed them while opening a CSV. Convert to .xlsx instead.
• Names with accents look garbled. You opened the .vcf file in a text editor, or a CSV in an app that doesn’t expect UTF-8. Convert to .xlsx, which keeps the letters intact.
• Contacts appear twice. The same people are saved on the phone and in Google. Remove repeats from the file with the VCF merge and de-duplicate tool before converting.