How to Import Contacts from Excel File to Android Phone

Today's TipsMake will show you how to import a contact list from an Excel CSV (Comma Separated Values: values separated by commas) document into the Contacts application on Android. Although Android devices cannot read CSV files, you can convert any CSV file to an Android-compatible format by importing it to your Google Account and exporting it to a vCard file. Once the conversion is complete, you can transfer the vCard file to Android via Google Drive, then import the vCard file to your device using the Contacts app.

Create a contact spreadsheet in Excel

How to Import Contacts from Excel File to Android Phone Picture 1

Open Excel. Click or double-click the Excel app with the green frame icon and a white "X" inside.

If you already have a CSV file to import, skip to the next section.

How to Import Contacts from Excel File to Android Phone Picture 2

Click Blank workbook . This option is in the upper left of the Excel window. A blank spreadsheet opens.

How to Import Contacts from Excel File to Android Phone Picture 3

Create a title for your contacts. You can add a title to your spreadsheet by clicking the top row cell and entering a description. To create CSV headers:

Enter FirstNamein cell A1 .

Enter LastNamein cell B1 .

Enter Phonein cell C1 .

Enter Emailin cell D1 .

How to Import Contacts from Excel File to Android Phone Picture 4

Enter contact information in each box. Starting in the second row, we will start entering each first name, last name, phone number and email address (if any ) in columns A , B , C and D.

For example, for a contact named "Thao Le" with phone number "1234567890" and email address "thao@gmail.com", you would enter "Thao" in cell A2 , "Le" in cell B2 , "1234567890" go to cell C2 and "thao@gmail.com" go to cell D2 .

How to Import Contacts from Excel File to Android Phone Picture 5

Click File in the upper left corner of the Excel window (Windows) or screen (Mac). A menu will drop down.

How to Import Contacts from Excel File to Android Phone Picture 6

Click Save As . This option is in the File drop-down menu .

How to Import Contacts from Excel File to Android Phone Picture 7

Save the document as a CSV file. Depending on your operating system, proceed as follows:

Windows — Double-click This PC in the middle of the page, enter a name for the contacts file, click the "Save as type" bar, select CSV UTF-8 (Comma delimited) (*.csv) from within drop-down menu, click the Desktop folder on the left side of the window, and then click Save .

Mac — Click the "On my Mac" button, enter a name for the file at the top, click the "Where" box and select Desktop , click the "Format" drop-down box, select CSV then click Save .

Convert CSV format to vCard

How to Import Contacts from Excel File to Android Phone Picture 8

Open the Google Contacts page (Google Contacts). Visit https://contacts.google.com/ using your computer's web browser. The Google Contacts page opens if you're signed in.

If you're not signed into your Google Account, enter your email address and password when prompted.

How to Import Contacts from Excel File to Android Phone Picture 9

Click More on the left side of the page. Various options will appear in the sidebar.

How to Import Contacts from Excel File to Android Phone Picture 10

Click the Import option below the More button . A window will pop up.

How to Import Contacts from Excel File to Android Phone Picture 11

Click CSV or vCard file (CVS or vCard file). This option is at the bottom of the list of import options.

How to Import Contacts from Excel File to Android Phone Picture 12

Click SELECT FILE . This blue button is at the bottom of the pop-up window. A File Explorer (Windows) or Finder (Mac) window opens.

How to Import Contacts from Excel File to Android Phone Picture 13

Select CSV file. Go to the folder where you saved the CSV file (for example, your desktop), then click the CSV file to select it.

How to Import Contacts from Excel File to Android Phone Picture 14

Click the Open button in the lower-right corner of the window.

On Mac, you may need to click Choose here.

How to Import Contacts from Excel File to Android Phone Picture 15

Click the IMPORT option . It's at the bottom of the window. Contacts in the CSV file will be imported into your Google Account.

Contacts you upload here will be added to your Google Account on all devices, including Android devices if you're signed in to the same Google Account; We won't need to create a vCard file and import it to the device unless you want to save contacts directly to Android's main memory.

How to Import Contacts from Excel File to Android Phone Picture 16

Select the folder of imported contacts. Click the folder with the current date in the left bar to view contacts in a CSV file.

How to Import Contacts from Excel File to Android Phone Picture 17

Click Export on the left side of the page. A window will pop up with the selected content located in the CSV file you imported.

How to Import Contacts from Excel File to Android Phone Picture 18

Check the "vCard (for iOS Contacts)" box at the bottom of the pop-up window.

How to Import Contacts from Excel File to Android Phone Picture 19

Click the blue EXPORT button at the bottom of the window. The vCard file with the title "contacts" will be downloaded to your computer. This is the vCard file that you use to import contacts to your Android device.

Add vCard file to Google Drive

How to Import Contacts from Excel File to Android Phone Picture 20

Open Google Drive. Visit https://drive.google.com/ using your computer's web browser. The Google Drive page will open if you're signed into your Google Account.

If you're not signed into your Google Account, enter your email address and password when prompted before continuing.

How to Import Contacts from Excel File to Android Phone Picture 21

Click the ＋New button at the top left of the page. A menu will drop down.

How to Import Contacts from Excel File to Android Phone Picture 22

Click File upload . It's in the drop-down menu. A File Explorer (Windows) or Finder (Mac) window opens.

How to Import Contacts from Excel File to Android Phone Picture 23

Select vCard file. Go to the download folder of the vCard file named "contacts" that you exported, then click the vCard file to select it.

How to Import Contacts from Excel File to Android Phone Picture 24

Click the Open option in the lower right corner of the window. The vCard file will be uploaded to Google Drive.

Again, on a Mac computer you would click Choose here.

Download the vCard file

How to Import Contacts from Excel File to Android Phone Picture 25

Open Google Drive on your Android device. Tap the Google Drive app, which resembles a green, yellow, and blue triangle on a white background. The Google Drive of your primary Google Account on Android will open.

You can switch to another account by clicking the ☰ icon and then selecting the profile photo of the account you want to use.

If your Android isn't signed into the Google Account you use on your computer, you can sign in by tapping the ☰ icon , selecting an email address, tapping Add account , tapping Google , and entering your login information. account input.

How to Import Contacts from Excel File to Android Phone Picture 26

Find the vCard file. Scroll through your Google Drive content until you find the vCard file you just uploaded from your computer.

How to Import Contacts from Excel File to Android Phone Picture 27

Long press on the vCard file. A menu will drop down after a few seconds.

How to Import Contacts from Excel File to Android Phone Picture 28

Tap the Download option from the drop-down menu. Google Drive will begin downloading the vCard file to the "Download" folder on Android.

How to Import Contacts from Excel File to Android Phone Picture 29

Turn off Google Drive. Press the Home button to exit. Once the vCard file has finished downloading, you'll be able to import the file's contents into the Contacts app on Android.

Import vCard file

How to Import Contacts from Excel File to Android Phone Picture 30

Open the Contacts app on Android. Tap the Contacts app in the App Drawer on Android.

How to Import Contacts from Excel File to Android Phone Picture 31

Tap the ⋮ icon in the upper right corner of the screen. A menu will drop down.

On some Android devices, you need to tap the ☰ icon in the upper left or right corner.

How to Import Contacts from Excel File to Android Phone Picture 32

Tap the Settings option in the drop-down menu.

On Samsung Galaxy, you need to tap on the Manage contacts option .

How to Import Contacts from Excel File to Android Phone Picture 33

Click on the Import option located on the Settings page. A list of import options opens.

On Samsung Galaxy, you need to tap Import/Export contacts .

How to Import Contacts from Excel File to Android Phone Picture 34

Select vCard format. Click on the .vcf or vCard option on the Import page. The File Manager window will open.

On a Samsung Galaxy, tap IMPORT near the top of the screen.

How to Import Contacts from Excel File to Android Phone Picture 35

Select vCard file. Click on the memory location where you downloaded the vCard file (such as Internal storage ), select the Download folder and then click on the vCard file.

On Samsung Galaxy, when you select the correct storage memory, the vCard file will automatically be selected.

How to Import Contacts from Excel File to Android Phone Picture 36