How to Export Contacts From WhatsApp to Excel – Free Vs Paid
Written by Justin Cener, Technical Executive and Staff Writer at Corbett Software. Justin covers email data formats and migration workflows.
Want your WhatsApp contacts in an Excel sheet for a backup or a clean up? There is a simple free way to do it, but first it helps to know what you are actually exporting, because that makes the whole thing much easier.
Summary: WhatsApp does not keep its own contact list. It reads the contacts saved on your phone and shows which of them use WhatsApp. So to get your WhatsApp contacts into Excel, you export your phone or Google contacts to a CSV or vCard file, then open that in Excel. The cleanest free route is exporting from Google Contacts as a CSV. Steps for Android and iPhone are below.
First, What WhatsApp Contacts Really Are
Here is the thing most guides skip. WhatsApp does not store a separate address book of its own. It reads the contacts already saved on your phone, matches them against phone numbers on the network, and shows you which of your contacts use WhatsApp. Your WhatsApp contacts are simply your phone contacts.
That is good news, because it means you do not need to pull anything out of WhatsApp itself. You just export the contacts from where they actually live, your phone or the Google account synced to it, into a spreadsheet file. Once you see it that way, the job is quick and completely free. The sections below show the cleanest route first, then the steps for each device.
How Your Contacts Reach Excel
The path is always the same three moves, whichever device you use. Export your contacts to a file, open that file in Excel, and only reach for a converter if the file will not open neatly.
How WhatsApp Contacts Reach Excel
WhatsApp reads your phone contacts, so you export those.
1. Your contacts
The people you WhatsApp are saved in your phone or Google account.
2. Export a file
Save them as a CSV or a vCard (.vcf) file. Both are free from the phone.
3. Open in Excel
A CSV opens straight into columns. Your contacts are now a spreadsheet.
If .vcf is messy
Only then convert the vCard to a clean CSV before opening.
Best Free Way: Export From Google Contacts
If your phone syncs contacts with a Google account, and most Android phones do, this is the cleanest route. Google Contacts exports a proper CSV that drops straight into Excel columns, with no conversion needed.
- On a computer, open Google Contacts and sign in with the account synced to your phone.
- Select the contacts you want, or use Select all in the left menu for everything.
- Click Export, then choose Google CSV for a plain spreadsheet, or Outlook CSV if you plan to import elsewhere.
- Open the downloaded CSV file in Excel. Your contacts appear as neat columns of names and numbers.
This is the method to use whenever you can, since it skips file conversion entirely.
Export Phone Contacts on Android
If you would rather export straight from the phone, the Contacts app saves a vCard file you can move to your computer.
- Open the Contacts app on your Android phone.
- Open the menu or Settings, then choose Import/Export or Export.
- Select Export to .vcf file and pick where to save it, usually the Downloads folder.
- Move that .vcf file to your computer, then open it, or import it into Excel. If it does not open as tidy columns, see the converter step further down.
Export Phone Contacts on iPhone
On an iPhone, the easiest route is through iCloud, which lets you export a vCard from a browser.
- On a computer, open iCloud.com and sign in, then open Contacts.
- Select the contacts you want, or press Ctrl+A or Cmd+A to select all.
- Click the settings gear at the bottom left and choose Export vCard.
- Open the downloaded .vcf file, or convert it to CSV first if you need clean spreadsheet columns.
Save Just One WhatsApp Contact
If you only need a single contact rather than the whole list, WhatsApp itself can share one as a vCard.
- Open the chat with that contact in WhatsApp.
- Tap the contact’s name at the top to open their info.
- Choose Share contact or Export contact, then send it to yourself by email.
- Save the attached .vcf file on your computer and open it, or add it to your spreadsheet.
When a vCard File Will Not Open in Excel
Sometimes a vCard file does not open cleanly in Excel. A .vcf holding many contacts can land as one long jumbled column rather than tidy rows, which is awkward to sort or edit. If that happens, converting the vCard to a proper CSV first fixes it. The Corbett vCard Converter Tool turns a .vcf file into a clean CSV with each detail in its own column, ready for Excel. It handles a single file or a whole folder at once, keeps every field intact, and a free demo edition lets you try it. It runs on all editions of Windows. For most people the free export above is all they need, this is only for when the .vcf will not cooperate.
People Also Ask
Q1: Can I export contacts directly from WhatsApp?
A1: Not as a separate list. WhatsApp reads the contacts saved on your phone rather than keeping its own. To get them into Excel, export your phone or Google contacts to a CSV or vCard file, which covers everyone you message on WhatsApp.
Q2: What is the easiest way to get WhatsApp contacts into Excel?
A2: Export from Google Contacts as a Google CSV and open it in Excel. It needs no conversion because a CSV opens straight into columns. This works for any contacts synced from your phone to that Google account.
Q3: How do I export my phone contacts as a file?
A3: On Android, open Contacts, choose Import/Export and export to a .vcf file. On iPhone, sign in at iCloud.com, open Contacts, select all and choose Export vCard. Both save a vCard you can open on a computer.
Q4: Why do my contacts open as one jumbled column in Excel?
A4: That happens when a vCard file with many contacts is opened directly. Convert the .vcf to a CSV first, which puts each name and number in its own column, then open the CSV in Excel.
Q5: Can I export a WhatsApp group’s contacts?
A5: WhatsApp does not export a group’s members as a file. You can save individual members to your phone contacts by tapping their number, then export your phone contacts as usual to include them.
Conclusion
Getting your WhatsApp contacts into Excel is easy once you know WhatsApp is just reading your phone contacts. Export those from Google Contacts as a CSV for the cleanest result, or save a vCard from your phone and open it in Excel. If a vCard file lands as a jumbled column, the Corbett vCard Converter turns it into a tidy CSV. Are you exporting your whole contact list, or just a few people you message most?
