How to Export WhatsApp Contacts to Excel

WhatsApp has no button to download your contact list, so to get it into Excel you export it from where the contacts are actually stored: Google Contacts on Android, iCloud on iPhone, or your WhatsApp API platform. Google gives you a CSV file that opens in Excel. iCloud gives you a vCard, which you can turn into a CSV in a couple of minutes.

There’s one catch people miss. WhatsApp can now save contacts only inside WhatsApp, and those don’t appear in your phone’s address book, so they won’t be in any export until you move them there. This guide covers each route, the API route for business teams, and how to open the file without Excel breaking your phone numbers.

Where your WhatsApp contacts are stored

WhatsApp’s help pages describe two places a contact can be saved, and your route to Excel depends on which one holds the numbers you want:

The free WhatsApp and WhatsApp Business apps read your phone’s address book, so there’s nothing to export inside them. That’s also why the export happens in Google Contacts or iCloud, not in WhatsApp.

First, move WhatsApp-only contacts to your phone

According to WhatsApp’s “About contact upload” page, when you save a new contact you choose whether it’s saved only to WhatsApp or also to your device, and syncing to the device is off by default. Contacts saved only to WhatsApp are restored when you change phones, but they don’t show up in Google Contacts or iCloud.

1. When you add someone in WhatsApp, turn on Sync contact to phone before you save.
2. For contacts you already saved only to WhatsApp, save them to your phone’s address book. WhatsApp’s own advice is to do this for any contact you want to keep outside your WhatsApp account.
3. Check one or two of them in Google Contacts or iCloud before you export, so you know they came across.

Birthdays you add in WhatsApp are saved to the contact in WhatsApp only, even with sync on, so they won’t be in your export either.

Android: download your contact list from Google Contacts

If your Android contacts are saved to your Google account, this gives you a file Excel opens directly. Do it on a computer:

1. Open contacts.google.com and sign in with the Google account your phone uses.
2. Tick the contacts you want. For everyone, tick any contact, then use the selection menu at the top left to choose all contacts.
3. At the top right, open More actions and choose Export.
4. Choose Google CSV and click Export. The file downloads to your computer.
5. Open it in Excel using the steps in the last section, so the phone numbers stay intact.

Google’s file has many columns (several phone and email fields, labels and notes). For a WhatsApp list you usually only need the name and the mobile number, so delete the rest once it’s open.

iPhone: export from iCloud, then convert to a spreadsheet

If your iPhone contacts are saved to iCloud, Apple lets you export them as a single vCard (.vcf) file. Excel doesn’t read vCards well, so the simplest free route is to pass it through Google Contacts:

1. On a computer, open icloud.com/contacts and sign in with your Apple Account.
2. Open the Select menu and choose Select All Contacts.
3. Open the Actions menu and choose Export vCard. You get one file with every selected contact.
4. Go to contacts.google.com, click Import, then Select file, and choose the vCard.
5. Export from Google Contacts as Google CSV, as in the Android steps.

Google warns that imports of more than 3,000 contacts at a time can cause problems, and an account holds up to 25,000 contacts. If you’re close to either, export from iCloud in smaller batches.

Can you download a WhatsApp group’s contact list?

Not as a file. WhatsApp has no option to export a group’s members, and we don’t recommend browser extensions or scrapers that claim to: they aren’t WhatsApp’s own tools, and you’d be handing them your customers’ numbers.

What WhatsApp does offer is Add members to contacts in the group’s info screen. You pick the members and save them, and with Sync contact to phone on they reach your address book and any export you make afterwards.

Export contacts from Automate AI to Excel

On a WhatsApp API platform, customers who message you, contacts you import and leads from integrations all land in the platform’s own contact list, so that’s where you export from. In Automate AI:

1. Open Contacts.
2. Narrow the list if you want part of it: search, or filter by group, status, tags, opted out or the Created date. People allowed to filter by agent can also narrow it to one team member’s contacts.
3. Click ⋯ next to Import and choose Export all contacts. With a filter on, it reads Export filtered contacts and the file matches what’s on screen.
4. To export only some people, tick them first and choose Export selected.
5. Open the CSV in Excel, setting the Phone column to Text.

Who can export: owners and managers export the contacts they can see. An agent’s export only includes contacts they created or whose chats are assigned to them. If Hide customer numbers is on in Settings › Auto Assignment, the agents it covers see masked numbers and can’t export contacts at all. Owners always see full numbers.

Because the Groups column uses the same shape the importer reads, you can edit the file in Excel and bring it back in. That’s covered in how to import WhatsApp contacts from Excel.

Keep a copy in Google Sheets or Google Drive automatically

A one-off export goes out of date the next day. If you want a spreadsheet that stays current, Automate AI has two options under Settings › Google Drive, using the same Google connection:

• Google Sheets: link one of your own sheets and contacts are kept in step with it every 1, 6, 12 or 24 hours. Edits in the sheet update the matching contact, and new rows with a phone number become contacts. Details in WhatsApp and Google Sheets.
• Google Drive backup: saves a dated Excel file (contacts_YYYY-MM-DD.xlsx) to a Drive folder on a schedule. A second backup on the same day replaces that day’s file.

Switched from the WhatsApp Business app with coexistence? Ask our team when you connect: we can bring in your WhatsApp Business app contacts and up to 6 months of one-to-one chats, within 24 hours of connecting, if you allowed chat sharing in Meta’s window. After that, they’re in Contacts and export like everyone else. See WhatsApp coexistence.

Open the file in Excel without breaking the numbers

Double-clicking a CSV lets Excel guess each column’s type, and phone numbers are where it guesses wrong. Microsoft says Excel keeps a maximum of 15 significant digits, drops leading zeros and can show large numbers in scientific notation. To keep numbers exactly as exported:

1. Open a blank workbook and go to Data › From Text/CSV, then choose your file.
2. In the preview, choose Edit to open the Query Editor.
3. Click the phone column’s header and set Home › Transform › Data Type to Text. Choose Replace Current if asked.
4. Click Close & Load.
5. Check a few numbers still have their country code, such as 91 for India or 44 for the UK.

Then tidy up: remove duplicates, delete columns you don’t need, and keep the file somewhere with limited access. It holds customers’ personal details, so treat it like any other customer record.