How to Copy WhatsApp Group Contacts to Excel (with Easy Steps)

Millions of people all over the world use WhatsApp, one of the most widely used instant messaging applications for our online discussions. It is therefore crucial to keep a backup of your contacts in case of an accident that causes you to lose communication with your WhatsApp contacts. This article will demonstrate to you how to copy WhatsApp group contacts to Excel.

How to Copy WhatsApp Group Contacts to Excel: Step-by-Step Procedures

WhatsApp has undoubtedly changed a lot over the past several years to rank among the most widely used instant messaging (IM) apps available. You can use it to make various groups in addition to communicating with your pals. But occasionally, people want to download WhatsApp group contacts to their computers. You might require assistance because copying WhatsApp contacts to Excel can be a bit difficult. Here is a step-by-step tutorial that anyone can easily follow on how to copy WhatsApp group contacts to Microsoft Excel.

Step 1. Accessing WhatsApp Web on Your Computer

You must first access WhatsApp on your computer in order to copy contacts to Excel. Simply open WhatsApp on your device to do this.

Firstly, launch the Chrome browser.
Then go to the web.whatsapp.com website.

Step 2. Scanning Your Smartphone

Here, you will see the one-time generated QR code.
Then, you will scan it on your smartphone to connect it to your WhatsApp account.

Step 3. Selecting WhatsApp Group

After that, you get access to a WhatsApp account on your computer.
Then, you will select your WhatsApp group.

Besides, right-click on PYTHON Programming best WhatsApp group.
Then, click on the Inspect option.

Step 4. Using Element Section For Copying

Here, you will see the below window with the back-end codes of your WhatsApp group contacts.
Then, go to the Elements section.
After that, choose the Copy option.
Besides, click on the Copy element option.

Step 5. Utilizing Data Tab

For the huge amount of data, we use the Data tab. By establishing a connection with the server, we can import data automatically from the web, MS Access, and other sources. Additionally, Excel’s sort and filter functions are incredibly useful; they make it simple to read large amounts of data. In this section, we will demonstrate to you how to separate each contact by using the Data tab.

Now, paste the back-end codes into your Excel sheet.
Then, select the entire code from the Excel sheet.
After that, go to the Data tab.
Besides, click on the Text to Columns command.

Here, you will see the below window and select the Delimited from here.
Then, click Next.

Here, you will go to the Other option and put a comma (,) here to separate each number.
After that, click Next.

Here, select the entire row.
Then, click the Copy option.

Step 6. Using Paste Special Command

By letting you select which formatting (source or destination) to preserve or by removing all formatting and only pasting the data or formulas, Excel Paste Special facilitates the pasting process.

Here, right-click anywhere in the Excel sheet.
Then, go to the Paste Special command.
After that, select the Transpose option and click it.

Finally, you will get all the WhatsApp group contacts here in the below image.
Here, we will show 17 contacts.

Lastly, you will see here that we have all the contacts up to 1026 rows.

Download Practice Workbook

You may download the following Excel workbook for better understanding and practice it yourself.

Copying WhatsApp Contacts.xlsx

Conclusion

In this article, we’ve covered Step-by-Step Procedures to Copy WhatsApp Group Contacts to Excel. We sincerely hope you enjoyed and learned a lot from this article. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.

<< Go Back to Importing Data in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!