Steps/Methods:
1. First, open your Excel file and keep only the name and phone number columns. Save as a file with a .csv extension.
Excel2010
2. Then, use Notepad to edit the csv file. The purpose of this step is to change the classification into a name that can be recognized by gmail. Sometimes it is just for checking. First, write "name, phone number" on the first line of the notepad (without double quotes, with English commas in between); again, separate the contact names and mobile phone numbers in each line below with English commas, such as "Zhang San, 13988888888 ". As shown in the figure after success:
Excel2010
3. Log in to gmail, click on the red Gmail under Google, and select "Address Book".
Excel2010
4. Import contacts:
Excel2010
5. Import the csv file you just edited:
Excel2010
6. Android: Click Settings-Account and Sync, enter your Gmail account and password, click "Sync Contacts" and it's OK.
iOS: Settings - Mail, Contacts, Calendar - Add Account - After adding the Gmail account, just sync the address book.
The above is the entire content of the method of importing Excel 2010 mobile contacts into Gmail shared by the editor. I hope it will be helpful to everyone! For more exciting tutorials, please pay more attention to Huajun Software Park!