Excel import mobile phone contact graphic Tutorial

Domestic Gmail was immediately sealed, while still able to use the time to share a recent learn a little skill bar. Hope to have the help of the netizen that needs.

1, first, open your Excel file, only keep the name and telephone two bar. Save as a file with a suffix of. csv.

2, then, use Notepad to edit this CSV file, this step is to change the classification to Gmail identifiable name, and sometimes just a check of the role. First, in the first line of Notepad, write "name, phone" (unique quotes, in the middle of the comma); again, the contact names and cell phone numbers for each line below are separated by commas in English, such as "John, 13988888888". After the success of the figure:

3, login Gmail, point Google under the Red Gmail, select the "Address Book."

4, Import Contact:

5, import you just edited the CSV file:

6, Android: Point settings-Account and synchronization, enter the Gmail account and password, point "Sync Contact" on the OK

IOS: Setup-mail, Address Book, calendar-Add account-After adding Gmail accounts, synchronize your address book.