How to Export Android Phone Contacts to an Excel File

image d'un android sur une table avec le titre exporter les contacts android dans un excel

Want to send bulk SMS messages but don’t have a database? Discover in this article how to import contacts from your Android mobile phone into an Excel spreadsheet.

Steps to follow to export your contacts from Android

Step 1: Export your contacts to your computer:

First, to create an Excel database from your Android contacts, open the Contacts app on your Android phone.

Next, tap the 3 lines as shown here:

Then click on “Manage contacts”, followed by “Import/Export contacts”.

exporter contacts android

After selecting this, export your contacts to your SIM card or vCard files, then click “Export”.

Import / export contacts

Finally, select “Internal storage”.

Import base de données dans excel

Go to your phone’s storage, into your files, then to the Downloads folder.

In this folder, select Contacts.vcf and send it to yourself by email.

Go to your computer’s email inbox to retrieve your file.

Step 2: Create a CSV file (your contact database)

After downloading your file, go to http://labs.brotherli.ch/vcfconvert/

In the “Browse” tab, select the contact file you just downloaded to your computer. The format to select is “CSV“. It is labeled “Gmail (CSV)”.
Confirm with the “convert” button and save your new file.

base de données excel android

Step 3: Import Android contacts into Excel

Open the new file with Excel.
Select the “Data” tab in the top menu of Excel.
Select the column containing the data and click “Convert” as shown below.

convertir

Select the “Delimited” button, then click “Next“.

android / excel

As shown below, specify the separators between the data fields in your table. You can select multiple different separators if needed, choosing from Tab, Semicolon, Comma, Space, or other.

excel base de données contacts téléphone

Check “General“, then choose a destination sheet in your Excel file. You can select cell A1 to place your contact table correctly. It is also possible to choose a different sheet in your file.
Once done, click “Finish“.

fin base de données

You’re all done! Your Android contact database is ready to use for sending bulk SMS messages! 😊

All that’s left is to log in to the SMS Partner sending platform and upload your contact database! To do so, you can check out our video tutorial on Importing a contact database.

Discover our campaign calendar to help you communicate at the right time with the right message throughout the year! (See our SMS campaign calendar)

To import contacts from an iPhone into an Excel database, please refer to the following article: How to import your iPhone contacts into Excel?

FAQ about exporting

Android contacts

+

1. How do I retrieve all my contacts when switching phones?

To retrieve all your contacts when switching phones, the simplest and most reliable method is to use synchronization with a Google account. Here’s how:

On your old phone:

Go to Settings > Accounts (or Accounts and sync).
Select your Google account and make sure contact sync is enabled. If not, turn it on.
Wait for the sync to complete (check by opening the Contacts app, tapping the three dots in the top right corner, then Manage contacts > Import/Export > Sync).

On your new phone:

Sign in with the same Google account.
Go to Settings > Accounts and enable contact sync.
Your contacts will automatically appear in the Contacts app after a few minutes.

+

2. How do I transfer contacts from one Android to another?

Here is the method recommended by Google:

On the source phone, make sure your contacts are synced with your Google account.
On the new phone, sign in to the same Google account and enable contact sync. Your contacts will be transferred automatically.

Alternatively, you can follow the method described in our article by exporting your contacts as a CSV file and then importing it to your new smartphone.

+

3. How do I know if my contacts are stored on my phone or on my SIM card?

To check where your contacts are stored (on the phone, the SIM card, or a Google account), follow these steps:

Open the Contacts app on your Android phone.
Tap the three dots (menu) in the top right corner, then select Manage contacts or Settings.
Look for an option such as “View contacts from” or “Contact storage”. You will see a list of possible sources: Phone, SIM card, or Google account (or another synced account).
If you select “SIM card”, only the contacts saved on the SIM card will be displayed. Do the same for “Phone” or “Google” to see where your other contacts are stored.