How to copy and save all contacts in WhatsApp group to spreadsheet? It's very simple, here's how to copy phone numbers from a WhatsApp group to an Excel document .
Why is it necessary to save contacts in chat groups on WhatsApp?
When you save your WhatsApp group contacts somewhere other than your phone, you can contact them even when you're offline.
Being able to contact members of online chat groups is useful in many cases, especially when your WhatsApp is hacked or your phone is stolen. At this point, you can send a message to all group members and let them know you've lost access to WhatsApp.
How to copy WhatsApp group contacts using Inspect Element
It may sound academic but don't worry, this way to copy contacts from WhatsApp is very easy. You can use any web browser as long as it allows checking web elements.
To get the phone number on a WhatsApp group using Inspect Element via Google Chrome, first you need to go to WhatsApp Web on your computer.
You can then 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 a few phone numbers or contacts listed horizontally.
Click a contact, then select Inspect . You will see the numbers highlighted in the Elements menu , right-click on them and you will see a list of options. Click Copy > Copy element from the next selection group.
After copying the numbers, you can paste them into the spreadsheet.
To extract phone numbers from WhatsApp groups via Firefox, the process is a little different from Chrome.
Instructions for copying phone numbers in WhatsApp groups on Firefox:
Sort phone numbers into each cell in Excel
After copying the phone numbers in the WhatsApp group into Excel, you will see that they are not in separate cells. Separating them makes it easier to copy & paste each number as needed.
To separate numbers into each cell in Excel, first you need to select the column containing the phone number. From the Excel ribbon , click Data . Then, select Text to Columns .
Tick Delimited > Next .
In the next window, uncheck the Tab option . Then, check the Comma box .
Once you have completed the above steps, click Next . Next, select Finish . Now each phone number is in its own cell in a row. Select that entire row and copy it by pressing Ctrl + C .
At this point, you can open a new spreadsheet or right-click on any cell in the opened table. In every option, you need Paste Special... > Other Paste Options > Paste Special.…
After clicking the paste option, click the Transpose box > touch OK . You will now see the contact numbers in individual cells in a column.
Note: If the phone number is already in your contacts, you'll see the name saved for them.
Instructions for creating and searching for draft articles on Facebook. Currently, we can save articles that we have created but have not yet posted on Facebook. Here, WebTech360 invites
Instructions for checking who has viewed your Facebook Story. To know who has viewed your newsletter on Facebook, today WebTech360 will introduce a tutorial article.
Instructions for separating photo backgrounds on your phone using Mojo Cut. Mojo Cut is an extremely useful live background separation application. Here we invite you to refer to it.
Instructions for installing and swapping faces using the Reface application. Reface is an extremely interesting video creation application that swaps the user's face with the main character.
How to set up LibreOffice Writer to work like Microsoft Word, If you're planning to switch from Microsoft Word to LibreOffice Writer but want a similar experience
Instructions for inserting affiliate links into Instagram Stories. Most recently, Instagram allows users to attach affiliate links to their images and videos posted to the newsletter. Day
Instructions for turning off saving videos on TikTok are extremely simple, to help people block others from downloading and saving their videos simply and easily. So today, WebTech360
How to permanently delete Discord account, How to delete Discord account on phone and computer is not difficult. Below are detailed step-by-step instructions for deleting a Discord account.
How to create a GIF fireworks greeting card for the new year 2021, To help everyone create a happy new year card to send to friends and relatives, then
Instructions for creating transparent song frames. Today WebTech360 will introduce to everyone the steps to create beautiful and impressive transparent song frames.
Instructions for creating genealogical charts and organizing them on Google Sheets. Google Sheets is an online office application that helps us easily edit online spreadsheets,
Instructions for registering a Clubhouse account, Clubhouse is an audio chat social network, allowing users to organize and participate in audio chats with many people.
Instructions for setting up Privacy for TikTok accounts. Like other social networks, TikTok also allows users to turn on Privacy mode for their accounts.
How to beat the drum to open the school year 2023 - 2024, How to beat the drum to open the school year 2023 - 2024 will give very detailed instructions on how to beat, the types of drumming and pages.
How to convert a photo to black and white but keep one color in Photoshop, How to make a photo black and white, except for one color in Photoshop is not difficult. Here are the details
Instructions for creating styles for messages on Viber. Recently, Viber has launched the feature to set font styles when texting. Next, WebTech360 invites you to join us
Instructions for making a chip-embedded Citizen Identification Card at home on Zalo. Currently, we only need to perform a few simple steps on Zalo to be able to register as a chip-embedded Citizen Identification Card.
Instructions for viewing song lyrics on Youtube, Today, WebTech360 will introduce an article on instructions for viewing song lyrics on Youtube, please refer to it.
How to import and manage multiple email accounts in Gmail, Want to manage all emails in Gmail? Let's learn how to manage and add multiple accounts with WebTech360
Instructions for using Mocha AE to track motion. Mocha AE helps users track motion when editing videos easily. Below is how to use Mocha AE.
