Export WhatsApp group members to Excel

Getting the list out of WhatsApp is half the job. The other half is getting it into Excel with the phone numbers still readable — which, if you double-click a CSV, they will not be.

Updated 23 August 20266 min read

The problem nobody warns you about

You export a group. You get a file with four hundred rows. You double-click it, Excel opens, and column B says:

9.19877E+11
9.19812E+11
9.19845E+11

Every phone number has become the same unusable smear. This is not a broken export — it is Excel doing exactly what it was designed to do, and it happens to every CSV of phone numbers regardless of where the CSV came from.

Two rules of Excel collide here. First, any cell whose contents look numeric is stored as a number. Second, numbers longer than eleven digits are displayed in scientific notation. An international mobile number is twelve or thirteen digits, so it trips both.

The leading + has a separate and equally annoying fate. To Excel it is a sign, not a character, so +919876543210 is parsed as positive 919876543210 and the plus is thrown away as redundant. Your numbers lose their country marker and every dialler and CRM downstream now has to guess.

The clean route: export a real workbook

The entire problem above exists because CSV is a text format with no type information in it. There is nothing in the file that says “this column is text”, so Excel guesses, and its guess is wrong for phone numbers every time.

An .xlsx file does carry types. If the list is exported as a genuine workbook rather than a renamed CSV, the phone column arrives already marked as text, the plus survives, and there is no import wizard to get right. You double-click it and it is correct.

That is what the XLSX option in GroupSync produces — a real workbook with a header row and typed columns, not a CSV wearing a different extension. If Excel is where the list is going, take that route and skip the rest of this page.

If you already have a CSV: import it properly

Sometimes the file is already a CSV and you just need it in Excel intact. The trick is to never open it directly. Double-clicking gives Excel no opportunity to ask you anything; the importer does.

1. STEP 01

   Start from a blank workbook

   Open Excel to an empty sheet. Do not open the CSV. Every conversion you are trying to prevent happens in the instant the file loads.

2. STEP 02

   Data → Get Data → From Text/CSV

   On the Data tab, choose From Text/CSV (older versions call it Get External Data) and pick your file. Excel opens a preview rather than loading it.

3. STEP 03

   Set File Origin to UTF-8

   In the preview, set File Origin to 65001: Unicode (UTF-8). This is what decides whether “सुनीता” arrives as itself or as a row of question marks. Check the preview pane before continuing — you can see it working or not working.

4. STEP 04

   Transform Data, then set the phone column to Text

   Click Transform Data to open the Power Query editor. Select the phone column, and in the Transform tab set Data Type → Text. If Power Query offers “Replace current” versus “Add new step”, choose Replace current so the detected numeric type is overwritten rather than layered on top of.

5. STEP 05

   Close & Load

   The list arrives as a proper Excel table with numbers intact, plus signs present, and names in the right script.

Making the sheet actually useful

Once the data is in cleanly, a few minutes of shaping saves you from the sheet becoming a dead file nobody opens twice.

Format it as a table

Select the range and press Ctrl+T. You get filter dropdowns on every column, banded rows, and a header that stays put when you scroll — and, more usefully, formulas that reference the table by column name keep working when the list grows.

Find the duplicates before you trust the count

People appear in more than one group, and the same person can appear twice in a merged list. Select the phone column and use Data → Remove Duplicates, or, to look before deleting, add a helper column:

=IF(COUNTIF($B$2:$B$500,B2)>1,"duplicate","")

Deduplicate on the number, never on the name. Two different people are called Rahul; two different Rahuls do not share a phone number.

Split the country code

For a single-country group with a two-digit code, this is straightforward:

Country code:  =LEFT(B2,3)
Local number:  =MID(B2,4,LEN(B2))

For a genuinely international group, do not do this with a fixed width. Country codes are one to three digits — +1, +44, +971 — and any single formula is wrong for most of the list. Sort by the leading digits and handle each block, or leave the numbers whole. Whole international numbers are what CRMs and diallers want anyway.

Fill in the blank names

Rows with a number and no name are the members you have never saved. That is expected, not an error. If you want them visually obvious rather than invisible, a conditional format on blank cells in the name column is faster than scrolling for them.

A note on Google Sheets

Sheets handles this better, for once. It assumes UTF-8 without being asked, and File → Import → Upload with Convert text to numbers switched off keeps the numbers as text and the plus signs in place. If the list is going to be shared with a team rather than worked on alone, importing to Sheets is genuinely the lower-friction path — and you can still download it as .xlsx afterwards, correctly typed.

Frequently asked questions

Keep reading