About Me

header ads

[Media] How To Add Members to a WhatsApp Group from Excel File?


Method: Adding Bulk Contacts to WhatsApp Group from Excel File or any Spreadsheet app

Step 1: Export the Excel file to CSV

The first step in adding members to a WhatsApp group from a spreadsheet file is to export the sheet to a CSV file. All spreadsheet editors have an option to export to CSV format. The sheet should contain exactly two columns, the first column being the Name and Phone Number, the second.

Prepend a group identifier, say CDG, to the names column. This helps us to easily search and retrieve bulk contacts in the following steps. So John Doe would become CDG – John Doe and so on.

Step 2: Import the CSV to Google Contacts

After exporting the CSV, go to Google Contacts web app and select the import option from the navigation bar. Select the CSV file which we have exported and wait for the import process to complete.

Once this process is complete, your contacts will automatically appear in your phone contacts if you have Google contact sync enabled. Otherwise, download the Google Contacts app for Android or iPhone to sync your contacts to phone.

Step 3: Create the WhatsApp group and add members

The last step is to create a WhatsApp group as you normally do and then select the add participants option. Now search for the group identifier you appended (e.g. CDG...) and it would list all the contacts. Simply select all of them and you are done!

The main takeaway of this WhatsApp trick is creating contacts in bulk from a sheet and appending a group identifier which makes handling contacts much easier.

Step 4 [Optional]: Deleting the new contacts

After creating the group and adding the members from the list, you can choose to delete the recently synced contacts. To do that, head back to contacts.google.com and in the side navigation bar, you’ll see a label with the import date. Select the corresponding one and hit the delete icon next to it. Choose the second option from the pop-up dialog box and click Delete.

If that doesn’t delete it from your phone, then search for the group identifier in your contacts app, select all and then delete.

Watch the following video

Post a Comment