How to Import Contacts From Excel to Whatsapp?

What is an Excel File?

Excel is a spreadsheet program developed by Microsoft and a component of its Office suite product for business programs. It enables users to organize data in columns and rows for managing and calculating it. You can easily store a lot of data in each cell like text, contacts, numerical values, formulas.

Why Need to Add Bulk Contacts in WhatsApp From Excel?

As we all know, WhatsApp is a free messaging application and compatible with different platforms like Android, iOS, Blackberry, and Windows OS. Users are looking for a solution to import contacts from Excel to Whatsapp. Some of the key benefits of using Whatsapp are:

1. Allows users to send text messages, images, documents, user location, audio/video, other media files, etc.
2. Yan can send the bulk of messages to your friends without any charges, and the only requirement is to establish a proper internet connection.
3. Offers benefits of no advertisements on the screen to annoy the user.
4. The app is easy to use and contains an interactive interface.
5. It provides information about who in your contacts are using the WhatsApp application.
6. You can easily share your location, images, and status with your friends.
7. Friends can chat with friends without any money using WhatsApp on internet-enabled devices.
8. Voice call support.
9. Video calling is available.
10. Payment support (latest feature)
11. It allows you to send documents to anyone up to 100Mb like PDF, Slideshows, etc.
12. You can also share Live Locations for 15 minutes, 1 hour, and 8 hours.

How to Import Contacts From Excel to Whatsapp?

Unfortunately, there is no solution to move or copy contacts from Excel to Whatsapp because the Excel extension XLS or XLSX is not compatible with Whatsapp. Firstly, you have to convert excel file contacts to VCF or vCard format and then import the VCF into Whatsapp.

1. Steps to Export Excel Contacts into vCard File Format.
2. Import vCard into Whatsapp (Either PC or Phone)

How to Convert Excel to VCF or vCard File?

In order to import contacts from Excel to Whatsapp, it is crucial to convert Excel contacts into a VCF file. Follow the steps to-do-so:

1. Start the Excel to vCard Converter as an administrator on your PC.
   
2. Browse the Excel button to add the excel sheet(XLS, XLSX) into the software.
   
3. Here, you have to select the sheet from the dropdown list and click Ok.
   
4. Now, the software shows two options: Standard Mode and Advanced Mode.
   
• Standard Mode:- To export all the excel columns data into vCard format.
  
• Advanced Mode:- To enter the number of columns you want to migrate into vCard/VCF Format.
  
5. Click on the Next button for further process.
   
6. Add the Excel fields and vCard fields to the map and click Next.
   
7. Opt for the saving path and click the Convert button to start the conversion of Excel contacts into VCF.
   

How to Import vCard into Whatsapp?

Once you have converted Excel contacts in the VCF file, you can easily import them into the Whatsapp application on PC or Mobile.

Steps to import VCF File into Whatsapp Application on PC

1. To use Whatsapp on a desktop, you will have to install “Bluestacks App Player software” on your system.
   
2. After completing the installation steps, open Whatsapp by clicking on it.
   
3. To download and install Whatsapp on your system, you need to add your Google account as per your need(New or Existing).
   
4. When the Google Account gets configured, click on the Whatsapp icon from Bluestacks and redirect to Play Store to install it.
   
5. Here, you have to enter the mobile number to complete the verification steps.
   
6. After that, set up your profile by adding a profile picture and username.
   
7. Then you have to copy Excel contacts converted in VCF format and drag them into a shared folder.
   
8. Open Whatsapp, go to the Setting option, and opt for the Import/Export option. From the drop-down, choose the Import from Storage option.
   
9. Now, the importing process gets started. You will find a popup displaying: filename.vcf will be imported shortly.
   
10. Here, you can also view your imported VCF file contacts on Whatsapp.
    

Steps to Import VCF File into Whatsapp Application on Mobile

1. Firstly, open your Phone Contacts.
2. Choose Import Contacts to import Excel contacts to WhatsApp.
   
3. Browse the location where you want to save the imported contacts.
   
4. Opt for the VCF file and click OK.
   
5. After that, all the Excel sheet contacts get listed in your phone contact lists.
   
6. It is how you can easily access or open VCF files in WhatsApp.

Conclusion

If you are importing contacts from Excel to Whatsapp, try this application for converting your Excel contacts into VCF files. It is competent enough to import Excel contacts into VCF or vCard files in 3 different vCard versions. However, after converting it into VCF, you can move your contacts into Whatsapp using the Import contacts feature.

About The Author:

Lovely Baghel

Lovely specializes in technical writing for SysInfoTools Software and has over 2 year of experience writing blogs, and articles about databases & backup, email recovery, email migration & management solutions. Her passion is researching and developing content that helps Office users, professionals, administrators, enterprises, and novices solve multiple problems.