Importing Contacts into Google Email and Android Phone

Adding a large number of contacts to an Android device can be quite a challenge. Here's one way to reduce the pain.

First, on the device, add a Google email account. Follow the instructions here.

Second, prepare a spreadsheet that conforms to the Google templates here (big) and here (small). The small one has minimal fields hence less of a headache to fill up.  The bigger is the full scale template with all the bells and whistles you could wish for and more....

Do not change the spellings of the column headings in any way.

Enter the names, groups and phone numbers of the contacts and save as a .csv  file (any spreadsheet program worth its salt can allow you to do that including Excel, LibreOffice Calc etc.).

Open the site https://contacts.google.com/ in a browser.

Select More as shown below then Import

You will be prompted to select the spreadsheet you just prepared then click Import to import the list of contacts.

 

If its a long list it may take a few moments to  import. There may or may not be a message from Google telling you all the contacts have been imported.  See below:

 

That's it.