Are you scared of losing contact with your group members on WhatsApp? Saving each contact from a group to your phone is a time-consuming process. And it's also perhaps unnecessary, especially when you don't have a personal relationship with them.

But how about copying and saving all WhatsApp group contacts into a spreadsheet—all at once? After all, you might need them in the future.

Here's how to copy contact numbers from a WhatsApp group to an Excel document.

When you save your WhatsApp group contacts somewhere other than on your phone, it lets you reach out to them even when you're offline.

Having the ability to contact group chat members while offline is useful for many reasons. If your WhatsApp gets hacked or your phone is stolen, for example, you can send a bulk SMS to group members and let them know that you've lost access to WhatsApp.

To copy your group chat contacts from WhatsApp to a spreadsheet, you'll need to use the WhatsApp Web app via a computer.

The first way to achieve this is by using a Google Chrome extension. To use this option, follow the steps below.

1. Go to Google Chrome Web Store. Then, install the WA - Download Group Phone Numbers Chrome Extension.
2. Next, head over to WhatsApp Web on your Chrome browser after installing the extension.
3. Scan the QR code with your phone's camera to sync and open your WhatsApp.
4. Select the WhatsApp group you want to get people's contact details from. Then click the three vertical dots at the top-right and select Download info to download the contacts into an Excel file.
5. Refresh your WhatsApp page if you can't find the Download info option. Then retry the above step.

A striking advantage of using this extension is that it organizes the contacts into an Excel sheet. Plus, it matches each contact's corresponding username with its phone number. And if a phone number exists in your contact book already, it'll point this out in the downloaded Excel file.

Copying texts from a web page like WhatsApp Web is one of the things you can do with Inspect Element. Unlike the previous option, this method for 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 available web browser, as long as it lets you inspect the elements of a website.

However, unlike the previous method, arranging the phone numbers to match the owner's username isn't feasible without extra time-consuming work. Nonetheless, it's a reliable technique to fall on when an extension fails.

How to Get WhatsApp Group Contact in Chrome

To get the phone numbers on your WhatsApp group using Inspect Element on Google Chrome, you'll first need to go to WhatsApp Web on your computer.

After that, you can select the group you want to copy contacts from. Look to the top of the group page (below the group name and icon), and you'll see some phone numbers or contacts listed horizontally on that tab.

Right-click any of the contacts on this tab. Then choose Inspect. You'll see the numbers already highlighted in the Elements menu; right-click on these, and you'll see a list of options. Choose Copy > Copy element from the next sets of choices.

After copying the numbers, you can paste them into a spreadsheet.

The process for extracting WhatsApp group numbers from Firefox is slightly different from how you do it with Google Chrome.

Below are the steps to copy WhatsApp group numbers in Firefox:

1. Follow the same process for accessing WhatsApp Web via Google Chrome.
2. Select the group you want to copy contacts from.
3. Right-click on the contacts listed horizontally at the top of the group. Select Inspect(Q).
4. Right-click the highlighted texts in the inspect console. Choose Copy > Inner HTML.
5. Paste the copied contacts into an Excel sheet.

Arranging the Phone Numbers Into Separate Excel Cells

After copying your WhatsApp group phone numbers into Excel, you'll notice that they're not separated into individual cells. Separating them makes it easier to copy and paste each number when needed.

To separate numbers into individual Excel cells, you'll first need to select the row containing the phone numbers. From the Excel ribbon, click Data. Then, choose Text to Columns.

Tick the Delimited circle in the next window. After that, click Next.

In the following Window, uncheck the Tab option. When you've done that, tick the Comma box.

Once you've completed the steps mentioned above, click Next. Then, choose Finish. The phone numbers are now in separate cells in a single row.

Now select that entire row and copy it by pressing Ctrl + C on your keyboard.

After doing the above, you can either open a new sheet or right-click on any cell within the one already opened. Whichever you choose, you'll need to go to Paste Special... > Other Paste Options > Paste Special....

After clicking the pasting option, click the Transpose checkbox. Then, tap on OK. You should now see the contact numbers in a single column. Unlike the previously bundled row arrangement, each should now have its separate cell and row instead.

If a contact is in your phone book already, you'll see the names you saved them with—and not their phone numbers. However, you can still get their mobile numbers from your phone book since they're in the Excel file.

Even if you don't have personal contact with everyone in your WhatsApp group, losing touch with the group as a whole can have detrimental effects. And while the worst is unlikely to happen, a little preparation in case it does is a good idea.

Now you know how to copy phone numbers from a WhatsApp group, why not give it a go? Doing so might save you both time and your reputation in the future.

Explain how to export contacts and numbers from WhatsApp

to Mohamed Ahmed

How to export WhatsApp contacts and numbers

You are probably familiar with the growing popularity of WhatsApp in today's world. The demand for people to stay connected is growing as technology and social media continue to advance and flourish. Finding reliable technology to keep your contacts alive is critical to making sure you don't lose the connections you've made over time. nine0003

WhatsApp contacts are usually very important as they keep track of all your messages. What's more, if you have a saved contact, you can simply search for that person by name and all their messages will appear. In light of this, it is important to understand how to export WhatsApp contacts to create a backup.

You can export your WhatsApp contacts to a vCard file. The vCard file can save your contacts in a standard file format, making it easy for end users to share and transfer files over the network. Moreover, this file format is compatible with various contact management solutions. As a result, many WhatsApp users prefer to save their contacts in a VCF file. nine0003

How to export WhatsApp contacts

Install "Export Contacts for WhatsApp" from the Play Store. Start installing the app on your device. To sign in, click Sign In and enter your Google account details. Your contacts will be scanned and those using WhatsApp will be filtered out. The next screen will also display statistics. Then click "Export Contacts" to save all WhatsApp contacts as a CSV file.

The free version of the program has one limitation: you cannot export more than 100 contacts. Click "Export" to continue. Finally, click "Export" and choose your desired file name. Note. Before exporting contacts, you will be given the option to view them. These instructions are exclusively for Android phones.

Converting a CSV file to VCF format

This task requires the use of a third party tool (CSV to VCF converter). While you can do it manually, using a reliable tool will save you a lot of time and effort. CSV to VCF Converter makes it easy to convert CSV files to vCard format. The conversion process is very easy and uncomplicated using this software. nine0003

Another way to export a WhatsApp contact:

Export WhatsApp group contacts to Excel (iOS/Android)

This strategy is especially useful for people you haven't added to your WhatsApp contact list, such as WhatsApp groups. You can use a web browser to export group contacts as an Excel file. To complete this process, you will need to sign in to WhatsApp Web.

After logging in to WhatsApp Web, do the following: nine0003

1. Step 1: The chat list can be seen on the left side of the screen. Select the group chat you want to use to export contacts from this list.
2. Step 2: On the right side of the screen at the top, you will see the address of the group, as well as some contacts.
3. Step 3: Select "Inspect" from the menu by right-clicking on it.
4. Step 4: Select the contacts in the Elements tab and select them all. Right-click it and select Copy and then Copy Item. nine0038

How to save all files from WhatsApp and transfer chats to Telegram

WhatsApp users began to actively prepare to leave the messenger. It is known that so far no restrictions are planned for the application, however, experts believe that it will not hurt to be ready in advance. About how to save all information from WhatsApp, transfer it to Telegram, to another smartphone or PC - in the material of Gazeta.Ru.

Better early

In connection with the blocking of the Instagram photo service in Russia, users of the WhatsApp messenger should, just in case, pay attention to ways to back up all data from the application. The reason is that WhatsApp and Instagram are owned by the same company, Meta (formerly Facebook). nine0003

It is now known that no restrictive actions are planned for the messenger.

Nevertheless, more and more users are interested in how to switch to other services, with the help of which you can quickly send and receive messages, but at the same time not lose years of correspondence both with friends and relatives, and on work or business issues.

Any messenger has a backup function that allows you to protect data and restore it in case of unforeseen events, Ivan Samoylenko, managing partner of B&C Agency, told Gazeta.Ru. nine0003

“Of course, users can take many screenshots of conversations or copy contacts to a text file, but people tend to have dozens of chats. This will take a significant amount of time,” the expert added.

According to the analyst, there are three ways that are much more effective than such practices.

The first way - third-party programs

Transferring backups using third-party programs is possible on smartphones with both iOS and Android, Samoylenko explained. Typically, such programs are used if you need to move WhatsApp data between smartphones with different mobile operating systems. However, for the purpose of creating a backup, they are also suitable. nine0003

Among the most frequently used programs are MobileTrans, WutsApper, WhatsApp Transfer and others.

The method of copying them may differ, but, as a rule, you need to connect both devices to the system: a gadget with data and a smartphone that will store the copy.

Such programs are also capable of more complex actions. For example, MobileTrans allows you to transfer all data, including photos and videos. The program has the functions of backing up WhatsApp to a computer and restoring a copy from a PC to a smartphone. nine0003

The second way is to Telegram

Users whose version of the messenger has been updated to a version higher than 7.4 will be able to copy WhatsApp chats (including group ones) to Telegram.

You need to launch WhatsApp on the device, select a chat, swipe it from right to left and click the “More” button, Samoylenko said. In the menu that appears, select "Export chat". Here you need to specify whether media files will be transferred - audio, photo and video recordings.

“Next, we indicate with which programs we want to share the correspondence. In our case, with Telegram. In this application, you can create a separate group in advance for your own correspondence, or save chats in "Favorites," the analyst noted. nine0003

The last step is to select the desired chat and click the "Import" button. According to the expert, you should not save personal correspondence in group chats, as they will be available to all their participants. When the data transfer is complete, "Imported" will appear.

The third way is in Google Drive

A Google Drive cloud backup can help if multiple users need access and the account is registered for doing business.

According to Samoilenko, for this method you need to log in to your Google account and be connected to the Internet. nine0003

“Next, open WhatsApp, the tab “Other options”, and in it “Settings”. In the “Chats” item, select “Backup Chats”, and then “Backup to Google Drive,” the expert said.

After that, you must also specify how often the data will be automatically transferred and stored in your Google account. For example, once a day at night (usually at two in the morning, when the owner is no longer using the application).

Learn more

• 
  How to get around copyright on instagram
• 
  How to delete a post on instagram from computer
• 
  How to start up a whatsapp tv
• 
  How to use whatsapp for two numbers in one phone
• 
  How to delete the group in whatsapp
• 
  How to celebrate 1000 followers on instagram
• 
  How to post multiple pictures on instagram using laptop
• 
  How to schedule instagram posts on facebook
• 
  How to troll on instagram
• 
  How to turn off private mode on instagram
• 
  How to recover whatsapp chat from email