How to Import Contacts from MS Excel CSV, XLS or XLSX File into Whatsapp PC

Process to Export Contacts from Excel into VCF File

To get contacts from Excel sheet into Whatsapp, it is very important to first export Excel contacts into VCF file which can be easily imported into Whatsapp. Check here step by step process to import your Excel contacts:

  • Download “RecoveryTools MS Excel to vCard Converter” tool, “Browse” and add Excel (XLS, XLSX or CSV) file, Check loaded Excel file preview, then click on “Next”
    browse excel saved contacts to import it into whatsapp

  • Once the Excel gets added successfully then map Excel fields with vCard fields to maintain the contact information. Map Excel and vCard fields one by one and click on “Add” option. Once mapping field process is completed, click on “Next”
    map excel field with vcard field for easiest conversion of contacts
  • Now, to begin export procedure, select few options:
    • Select the vCard version (2.1, 3.0 or 4.0) and if you want to export all contacts from Excel then select “Single vCard for All Contacts” option. By default, software creates separate vCard for each contact
    • “Allow Empty Email Addresses to be Imported” to convert all those contacts which doesn’t have email addresses By default, software saves converted contact file in desktop, but to save vCard file in other location, select the destination path
    select destination path to save vcf file
  • Once the contacts gets transferred from MS Excel into vCard file then the process of importing Excel contacts (in the form of VCF file) into Whatsapp becomes an easier procedure.

How to Import Contacts from Excel i.e. VCF to Whatsapp

Once you have Excel contacts in VCF file then you can easily import it into Whatsapp application on PC.

  • To use Whatsapp on desktop, you need to have installed “Bluestacks App Player software” in your system
    download whatsapp for pc
  • After software gets installed on your system, Open it and click on “Whatsapp” icon to proceed further
    open whatsapp to import excel contacts
  • Now, to download and install Whatsapp on your machine, you need to add your Google account “New or Existing” account as per your requirement.
    register for google account to import csv excel file into whatsapp
  • Now when the Google Account gets properly configured, click on “Whatsapp” icon from Bluestacks and redirect to Play Store to install it
    download whatsapp application for csv file importing
  • Once Whatsapp gets successfully installed, configure it by giving your mobile number so that a code could be sent to your mobile for verification.
    configure whatsapp account
  • After account gets verified completely, set up your profile by adding profile picture and username
  • When the Whatsapp gets successfully configured, you will get to see it like this, default you will have some contacts added there right from your Google account.
    select contacts from excel file into whatsapp for importing process
  • Now you need to copy contacts Excel contacts converted in VCF format and drag it into shared folder (By default there is a shared folder created in the highlighted path)
    allcontacts.vcf file gets imported from excel into whatsapp

Note – To, import VCF file (Excel converted contacts) in Whatsapp, you need to have Astro manager installed on your system. Astro File Manager is a tool developed for Android device for navigation to distinct folders as well as executing tasks like move, copy or delete. You can download the Astro Manager from Play store by typing the “Astro Manager” in search option provided in the Bluestacks app

Now you will have 2 ways to import contacts from (Excel exported) VCF file into Whatsapp:-

Procedure – 1

  • Once the Astro Manager gets installed properly, open it and click on “SD” card option
  • Now by visiting the path “SDCard � Windows � BstSharedFolder”, you will get to see the Allcontacts.VCF file which we have copied in Shared Folder in the earlier step
  • Now, open the VCF file, you will get 3 options in the pop-up menu, Click on “Contacts from it”. You will get to see that the procedure of importing contacts started in the top-left corner.
    select contacts option to start whatsapp contacts import process

Procedure – 2

  • In Whatsapp account, go to Setting options and from drop down menu select Import/Export option. Now, a pop-window will appear with the some options, select “Import from Storage” option
    import-export-option to import vcf file in desktop whatsapp
  • Now, importing process gets started and a pop-up option appears showing “Allcontacts.vcf will be imported shortly”
    excel converted vcf file imported into whatsapp

Whether you select procedure 1 for importing VCF file in Whatsapp account or you proceed with process 2 to import Excel contacts to Whatsapp PC account, you will get this screen after contacts gets successfully added in Whatsapp.

excel contacts successfully imported into whatsapp

Leave a Reply

Your email address will not be published. Required fields are marked *