How to Export WhatsApp Contacts to Excel

You have hundreds of people in WhatsApp who never made it into your phonebook. Buyers, leads, group members, someone who asked about pricing three months ago. WhatsApp has no "export contacts" button, so that list just sits there — impossible to filter, impossible to hand to a colleague, impossible to load into a CRM. This guide shows you how to export WhatsApp contacts to Excel the practical way: what you can do by hand, why it stops working past about 30 people, and how to get a clean spreadsheet in under a minute. It also covers the one import setting that stops Excel from turning +55 11 98765 4321 into 5.51199E+12.

Decide which contacts you actually need

Before exporting anything, be clear about the source. Three groups matter:

• Unsaved chats. People who messaged you but were never saved to your phone. Usually the most valuable list you own, and the one nobody has a copy of.
• Group members. A community, a class, a supplier group, a neighborhood group. If you are in it, the members are visible to you.
• WhatsApp Business labels. If you tag chats as "Customer", "Paid", "Follow up", those tags are a ready-made segmentation you can carry into the spreadsheet.

What you get out of any of these is name and phone number. That is what a spreadsheet needs and what a CRM asks for.

The manual method (free, and fine for small lists)

There is a path that costs nothing:

• Open the chat, tap the contact, save the number to your phone.
• Repeat for every person.
• Go to contacts.google.com, select the contacts, choose Export, pick Google CSV.
• Open the downloaded CSV in Excel.

This works. The problem is arithmetic. Saving one contact takes roughly 20 to 30 seconds when you include typing the name. Three hundred contacts is two to three hours of thumb work, and typos creep in around contact number forty. Groups are worse: there is no way to save 200 members in bulk, so you tap each one individually. And unsaved numbers show up as raw digits, which you then retype by hand — the single most common source of a dead number in a database.

The fast way to export WhatsApp contacts to Excel

WAzap is a browser extension for Chrome, Edge, Brave and Opera, published on the Chrome Web Store. It reads the contact list already loaded in your WhatsApp Web session and writes it to a CSV file — which is exactly what Excel and Google Sheets want.

• Install the extension from the Chrome Web Store.
• Open web.whatsapp.com and scan the QR code as usual.
• Click Collect contacts.
• Choose your source: unsaved chats, a specific group, or a Business label.
• The file downloads to your computer in seconds. CSV for spreadsheets, or vCard (.vcf) if you would rather push it straight to a phone.

It runs on a computer, because it uses WhatsApp Web. There is no mobile app. If you want the click-by-click version with screenshots, the step-by-step tutorial walks through it, and there is a dedicated guide for exporting contacts from a WhatsApp group.

One thing worth knowing before you start: the reading happens inside your own browser, and no chat is opened to do it. Nobody gets blue ticks from your export. The file is generated on your machine. The only thing that talks to our server is technical — license validation, the free-trial counter, a version check. Contacts never leave your computer.

Opening the CSV in Excel without wrecking your data

This is where most exports go wrong, and it has nothing to do with the export tool. If you double-click a CSV, Excel guesses at every column. Its guesses are bad for phone numbers:

• A 12-digit number becomes scientific notation: 5.51199E+12.
• Leading zeros disappear: 044 9988 7766 becomes 44 9988 7766.
• Accented names turn to mojibake: José becomes José.

The fix is to import instead of open, and to tell Excel two things: the file is UTF-8, and the phone column is text.

Excel on Windows

Open a blank workbook. Go to Data → From Text/CSV and pick your file. In the preview window, set File Origin to 65001: Unicode (UTF-8) — that alone fixes the accents. Then click Transform Data, right-click the phone column header, choose Change Type → Text, and confirm "Replace current". Finally Close & Load. Your numbers arrive exactly as they were written.

Excel on Mac

Same idea: Data → Get External Data → From Text. Choose Delimited, set the file origin to UTF-8, mark the phone column as Text in the final step of the wizard, then import.

Google Sheets (the shortcut)

If you would rather skip the wizard: in Sheets, go to File → Import → Upload, and set Convert text to numbers, dates and formulas to No. Sheets handles UTF-8 natively, so accents survive. When it looks right, File → Download → Microsoft Excel (.xlsx). Two clicks, no settings to remember.

If you need the file reshaped — different column order, a different separator, a format some other tool insists on — the CSV converter handles that without you writing formulas.

What to do once it is in the spreadsheet

A CSV of names and numbers is raw material. The value comes next:

• Deduplicate. Select the phone column, then Data → Remove Duplicates. If you exported several groups, overlap is normal.
• Normalize the format. Decide on one shape — international format with a country code is the safest — and stick to it. Most CRMs and messaging platforms reject anything else.
• Segment. Add a column for source ("Group: Wholesale buyers", "Label: Paid"). Six months from now, that column is the difference between a list and a database.
• Import. Straight into HubSpot, Pipedrive, Mailchimp, or back into contacts.google.com if you want the names to show up on your phone. A Google Contacts import syncs to your phone in about 2 to 20 minutes on the same account.

Common mistakes

• Double-clicking the CSV. The number one cause of ruined phone columns. Import, do not open.
• Formatting the column as Text after the damage. Once Excel converts 5511987654321 to scientific notation, switching the cell format shows you 5511987654300 — the precision is already gone. Reimport the original file.
• Closing WhatsApp Web mid-export. The extension reads the live session. Leave the tab open until the download finishes.
• Missing country codes. Check a handful of rows before a CRM import. Numbers without a country code will silently fail to deliver later.
• Saving as .xls instead of .xlsx or .csv. Older formats mangle Unicode. Keep the encoding modern.
• Expecting a second computer to work on the same license. One license covers one machine. Changing computers is fine — write to support and it gets transferred.

What WAzap does not do

Worth being direct about this, because it saves everyone time:

• It does not send bulk messages and does not automate any sending.
• It does not export the content of your conversations. Names and numbers only.
• It does not export profile photos.
• It does not work without WhatsApp Web open.
• It does not bypass any WhatsApp limit or rule.

It is an export tool. What you do with the spreadsheet afterwards is on you — and you should follow the messaging rules and consent laws that apply where you operate.

Pricing, briefly

The first 20 contacts are free. No card, no signup, no account creation. That limit is lifetime, not daily, so it is a real trial rather than a drip. If it does the job, plans are monthly, quarterly (the most popular), six-month, and annual, priced in your local currency and adjusted for your country. Payment runs through Stripe with automatic renewal and cancellation whenever you like. Your license key arrives instantly on screen and by email in the format LX-XXXXXXXXXX.

Try it on your own list

The fastest way to know whether this solves your problem is to run it on your own WhatsApp. Install the extension, open WhatsApp Web, click Collect contacts, and export your first 20 for free. Import the CSV into Excel using the UTF-8 and text-column settings above, and see what the data looks like. If it is what you needed, upgrade. If not, you have lost about a minute.

Get the extension and export your first 20 contacts free, or read the full setup guide first. Questions go to support — the site and the extension are available in 12 languages.

If you are not using it yet, meet the WhatsApp contact extractor from WAzap: it exports and saves every WhatsApp Web contact at once, as a CSV ready for Google Contacts.

Need only the contacts under one WhatsApp Business label? See how to export WhatsApp Business contacts by label — the CSV opens in Excel the same way.