How To Make Contacts For WhatsApp From Excel

Tutorials & Methods
, ,
1

How to Make Contacts for WhatsApp from Excel No. and Name | Import and Export

  1. First make an Excel file, two columns, Name, and Phone

  2. Import names and Phone nos in the columns.

  3. Save the File as .CSV

  4. Open Google Contacts from Browser

  5. Click on Import option

  6. Import the CSV file

  7. Export as VCF file,

  8. Then go to your contacts app on phone (or download the Google contacts app)

  9. 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 5600 contacts, you can try for more if you wish. And it was only 80kb VCF file.

Happy learning!

8 Likes
2

helpful tip. thanks a lot for sharing!

3

does it works for more than two columns (name, num , email ) ?