How to export whatsapp group contacts to an excel file

3 min readNov 25, 2020

There are times when we(users) wish to export Whatsapp group contacts to a file for future use, marketing or networking.

This article will guide you on how you can export contacts to an excel file.

In other to achieve this, we’ll be using the dedicated web version of whatsapp….

Step 1: Access Whatsapp web on your PC

launch whatsapp on your mobile device, tap the three dot icon from the top, and select “whatsapp web” option.

now head over to your favourite browser [mine is Chrome] on your pc and simply visit web.whatsapp.com. This will display a unique generated QR-code, which you have to scan on your mobile device to connect it to your whatsapp account.

Step 2: Copying the group contacts

Once you are in the web view of whatsapp, you can access your whatsapp account on your pc.

Select the group which you want to export its contacts , right click on the title of the group and choose the “inspect” option.

This will display a window showing the Html code of the page.

now right click on the highlighted part of the code with phone-numbers. Choose copy , then copy element to extract the contacts.

Awesome!

Step 3: Pasting copied contacts to Excel

Now go ahead and open Excel and paste the copied contacts in a row

now we need to make sure that numbers are displayed in different columns.

click on the “Data menu”, followed by “text to column” option, then a display window is shown. Click next

After clicking next, another display window is shown. now you have adjust one number into one column, by dragging the arrows to the right, forming one column for each number.