- First make an Excel file, two columns, Name, and Phone
- Import names and Phone nos in the columns.
- Save the File as .CSV
- Open Google Contacts from Browser
- Click on Import option
- Import the CSV file
- Export as VCF file,
- Then go to your contacts app on phone (or download the Google contacts app)
- Import the VCF file
Done, all the contacts are now added. This is very helpful for me, I have googled stuffed and got it working. I have imported 4000 contacts, you can try for more if you wish. And it was only 80kb VCF file.