If you don't want to lose track of your WhatsApp group contacts, it's worth importing them into a spreadsheet.
Are you afraid of losing contact with your group members on WhatsApp? Saving each contact in a group to your phone is a time-consuming process. And maybe that's superfluous, especially when you don't have a personal relationship with them.
But how about copying and saving all WhatsApp group contacts to a spreadsheet, all at the same time? After all, you may need them in the future.
Here's how to copy contact numbers from a WhatsApp group into an Excel document.
When you save your WhatsApp group contacts to a place other than your phone, it allows you to contact them even when you are offline.
Having the ability to contact group chat members while offline is useful for many reasons. If your WhatsApp is hacked or your phone is stolen, for example, you can send a bulk SMS to group members and let them know that you have lost access to WhatsApp.
How to copy WhatsApp group contacts web using a Google Chrome extension
To copy group chat contacts from WhatsApp to a spreadsheet, you will need to use a computer.
The first way to achieve this is to use a Google Chrome extension. To use this option, follow these steps.
- Go to the Google Chrome Web Store. Then, download and install the.
- After installing the extension, go to on your Chrome browser.
- Scan the QR code with your phone's camera to sync and open WhatsApp.
- Select the WhatsApp group you want to get people's contact details from, look at the top right corner of the group page and click Save contacts .
- Select Salva file CSV to download phone numbers in this format. You can also choose Copy negli appunti and then paste them into an Excel sheet.
How to copy WhatsApp group contacts using Inspect Element
Unlike the previous option, this method of copying numbers from a WhatsApp group to an Excel spreadsheet is more manual. But it's not overly technical, so don't worry. You can use any web browser available, as long as it allows you to inspect elements of a website.
To get the phone numbers on your WhatsApp group using Inspect Element on Google Chrome, you must first log in to WhatsApp Web on your computer.
After that, you can select the group you want to copy contacts from. Look at the top of the group page (under the group name), where you will see some phone numbers or contacts listed horizontally.
After clicking on a contact, choose Inspect . You will see the numbers already highlighted in the menu Elements ; right click on these and you will see a list of options. You choose Copy > Copy Element from the subsequent series of choices.
After copying the numbers, you can paste them into a spreadsheet.
To extract WhatsApp group numbers from Firefox, the process is slightly different from Google Chrome.
Below, you will see the steps on how to copy WhatsApp group numbers to Firefox.
- Follow the same procedure to access WhatsApp Web via Google Chrome.
- Select the group you want to copy contacts from.
- Right-click the contacts listed horizontally at the top of the group. To select Inspect (Q) .
- Right-click the highlighted text in the inspector console. You choose Copy> Internal HTML .
- Paste the copied contacts into an Excel sheet.
Organize phone numbers in separate Excel cells
After copying your WhatsApp group phone numbers to Excel, you will notice that they are not separated into individual cells. Separating them will make it easier to copy and paste individual numbers when needed.
To separate numbers into single cells in Excel, you need to select the column containing the phone numbers first. From the Excel ribbon, click Data . So, choose Text in columns .
In the next window, check the circle Delimited. Next, click NEXT .
In the following window, uncheck the option Form . When finished, tick the box Comma .
After completing the above-mentioned steps, click NEXT . So, choose end . Phone numbers are now in separate cells in a single row. Select the entire row and copy it by pressing Ctrl + C on the keyboard.
After doing the above, you can open a new sheet or right-click on any cell within the one that is already open. Whatever you choose, you will have to go on Paste Special ...> Other Paste Options> Paste Special ... .
After clicking on the paste option, click on the checkbox Transpose. Then, tap OK . You should now see the contact numbers in a single column. But where they were grouped together before, each should now have their own separate cell instead.
Note: If a contact is already in your address book, you will see the names you saved them under, not their phone numbers. However, you can still get their mobile numbers from your address book once you know they are grouped in Excel.
