How to add multiple contacts from Excel to your Phone?

headImage

Step by Step guide to add Multiple Contacts from Excel to your mobile Phone Contacts.

how to add multiple contacts from excel to phone | how to add contacts from excel to mobile | how to add bulk contacts in phone | how to add contacts from excel to phone | how to save bulk contacts in phone from excel | how to add contact number from excel to mobile

Dear Friends,

many small business facing issue about how to add multiple customers contact’s from their excel to their mobiles, when they wants to promote their ideas of any item or any other’s. Today i am going to tell you that how you can add multiple contacts to your phone with simple trick. So lets get started.

Just follow the steps mentioned below.

Step 1:

Open your excel sheet where you saved all the numbers. Check the sheet and be sure there were no blank row or column or any text under number list.

Here is my dummy list which have 1950 contacts.

contacts


Step 2:

open google contacts by https://contacts.google.com

googlecontacts

Step 3:

if you are using it first time go to Create Contact.

contactcreate


Step 4:

you will get window like this:

createcontactwindow


Step 5:

Now add a dummy contact name and number and save it.

createcontact


Step 6:

now go to the export contacts and select Google CSV and export the file to your local.

exportcontacts


Step 7:

Open contacts.csv file, downloaded from google contacts.

googlecsv


Step 8:

Now copy the column of name from your excel sheet and paste it to Name, and copy paste the number under “mobile number” column of contacts.csv file, and save contact.csv file.

Step 9:

Now go to google contacts and select import from right side menu bar.

importcontacts

Step 10:

Import the updated contact.csv sheet to google contacts.

import2


Step 11:

Now go to export from google contacts and export your contact file in vCard format.

exportcontacts


Step 12:

Send this vCard file to your phone via USB or mail.

Step 13:

Go to contact from your phone > from contact menu select import contacts.

Step 14:

Once you select import contact, give the location of vCard file to your phone.

(Some phones automatically select the vCard files.)

Step 15:

There is no step, check your contact’s that can be updated with all new numbers.


That’s all.


Hope this tutorial will be helpful for you. Feel free to leave your comments below.


Thank you



 

6 Comments