How to import Excel 2010 mobile phone contacts into Gmail

Time: 2022-04-27Source: Huajun Informationauthor:

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

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

Excel2010

3. Log in to gmail, click on the red Gmail under Google, and select "Address Book".

Excel2010

Excel2010

4. Import contacts:

Excel2010

Excel2010

5. Import the csv file you just edited:

Excel2010

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!

Related articles更多>>

Popular recommendations