How to Export WhatsApp Group Contacts to Excel: A Step by Step Tutorial

WhatsApp has certainly evolved a lot in recent years and has become one of the most popular IM apps on the market. In addition to chatting with your friends, you can also use it to create different groups. However, there may be cases where a user wants to export her WhatsApp group contacts to her computer. Exporting WhatsApp contacts to Excel can be a bit tedious, so you may need some help. Here is a detailed guide to extract WhatsApp group contacts that anyone can easily follow.

Part 1: How to Export WhatsApp Group Contacts to Excel via WhatsApp Web?

You might already know that WhatsApp offers a dedicated web version that lets us access the application on our computers. Therefore, you can first access the web version of WhatsApp on your computer to export your group contacts. To learn how to export WhatsApp Group contacts to Excel manually, the following steps can be taken.

Step 1: Access WhatsApp web on your computer

To export WhatsApp contacts to Google or Excel, you first need to access the app on your computer. For this, you can just launch WhatsApp on your device, tap on the three-dot icon from the top, and select the “WhatsApp Web” option.

export whatsapp group contacts 6


After finding the group contacts under the tag, just select it, and right-click the section. From here, you can choose to copy the element or the outer HTML to extract WhatsApp group contacts.


export whatsapp group contacts 7


Step 3: Export WhatsApp Group Contacts to Excel

Great! After when you copy WhatsApp group contacts, open any text editor (like Notepad, WordPad, or MS Word) and paste the content there. Now, you can manually get rid of any unwanted code like “ ” from the text. You can also use the Replace feature of the text editor to replace “ ” with a blank.


export whatsapp group contacts 8


After getting rid of any unwanted code, you can copy the text, launch MS Excel on your PC, and paste the content. The data would be pasted in the entire row that you might not want. To fix it, click on the paste icon from the bottom to go to its “Paste Options”. From the Paste Options window, just enable the “Transpose” feature to display contacts in dedicated columns.

export whatsapp group contacts 9

That’s it! In this way, you can export WhatsApp Group contacts and save them as a dedicated Excel file.

Leave a Reply

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

Fill out this field
Fill out this field
Please enter a valid email address.
You need to agree with the terms to proceed