Importing Contacts into Google Email and Android Phone via .CSV File

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 Import on left hand panel as shown below:

 

You will be prompted to select the file containing contacts (the spreadsheet you just prepared) and the Import Contacts label (create a new label)  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.  The new contacts will be listed in the main panel as a separate group with the label as a title. These are now available on your Android device as long as you using the same Google account on the device as for the contacts list. 

That's it.