# How To Make Contacts For WhatsApp From Excel **URL:** \ **Category:** Tutorials & Methods\ **Tags:** tools, tips-tricks, social-media\ **Created:** [April 11, 2021, 11:29am UTC](https://onehack.st/t/how-to-make-contacts-for-whatsapp-from-excel/178407 "2021-04-11T11:29:42Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![PlayBoy83](https://onehack.st/user_avatar/onehack.st/playboy83/32/164314_2.png) [@PlayBoy83](https://onehack.st/u/PlayBoy83)\ **Post date:** [April 11, 2021, 11:29am UTC](https://onehack.st/t/how-to-make-contacts-for-whatsapp-from-excel/178407/1 "2021-04-11T11:29:42Z")
**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!** ---
**Author:** ![slimjval](https://onehack.st/user_avatar/onehack.st/slimjval/32/30254_2.png) [@slimjval](https://onehack.st/u/slimjval)\ **Post date:** [April 26, 2021, 2:39pm UTC](https://onehack.st/t/how-to-make-contacts-for-whatsapp-from-excel/178407/2 "2021-04-26T14:39:31Z")
helpful tip. thanks a lot for sharing! ---
**Author:** ![Ayoub\_Haloui](https://onehack.st/user_avatar/onehack.st/ayoub_haloui/32/37454_2.png) [@Ayoub\_Haloui](https://onehack.st/u/Ayoub_Haloui)\ **Post date:** [April 26, 2021, 3:52pm UTC](https://onehack.st/t/how-to-make-contacts-for-whatsapp-from-excel/178407/3 "2021-04-26T15:52:32Z")
does it works for more than two columns (name, num , email ) ?