Google Contacts to email list: export every address as a clean CSV
In short: Reads the Google CSV that Google Contacts exports, pulls every address out of the E-mail 1, 2, 3 Value columns (including cells joined with :::), removes repeats and marks each work or personal. Limit: It can only list addresses saved in the export; it can't tell you which mailboxes still exist.
To get every email address out of Google Contacts, open contacts.google.com, choose Export, pick Google CSV and download contacts.csv. Upload it here: the tool reads every E-mail Value column, splits cells that hold several addresses, removes repeats and gives you one address per row with name, company and a work or personal label.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. See pricing
Sample result
ana.silva@example.com and 5 more addresses pulled out of a Google Contacts export.
- Unique addresses
- 6 addresses
- Contacts read
- 6
- Repeats removed
- 1
What this means for you
Every E-mail Value column is read, repeats are removed and work is split from personal.
- Reads E-mail 1, 2, 3… Value columns
- Splits cells joined with :::
- Keeps name, company and label
- Work or personal per address
- Contacts
- Export
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
How do I turn Google Contacts into an email list?
- Open contacts.google.com and choose Export in the left menu (or select contacts, then More actions, Export).
- Pick which contacts or label to export, choose Google CSV and press Export. A file named contacts.csv downloads.
- Upload contacts.csv here (or paste it) and press Build email list. Tick Keep work addresses only to drop Gmail, Outlook and other personal mailboxes.
- Download the CSV with email, first_name, last_name, name, company, email_label, source_column and email_type columns, one address per row.
Example
- You enter
- A Google CSV export with 6 contacts: one with a Work and a Home address, one with two addresses in one cell joined by
:::, one with only a phone number, and one contact saved twice. - You get
- 6 unique addresses, one per row with name, company and the Work or Home label: 4 work and 2 personal (
gmail.com,outlook.com). 1 repeat is removed and 1 contact is counted as having no address. - Limits
- Runs in your browser with no row cap; an uploaded file can be up to 25 MB.
How do I export email addresses from Google Contacts?
Export a CSV from Google Contacts, then keep only the email columns. Google's help page on exporting contacts lists three formats: Google CSV, Outlook CSV and vCard. Google CSV is the one to choose for a spreadsheet or email tool, and this tool reads it as it comes.
The file has one row per contact, but addresses are spread across columns named E-mail 1 - Value, E-mail 2 - Value and so on, with a matching Label column (Work, Home, Other). A contact with two work addresses can have both in one cell, joined with ::: . Opening the file in Excel gives you dozens of columns and no single list; this tool turns it into one address per row.
Can I export only one label or group from Google Contacts?
Yes. In the Export dialog, choose a label instead of all contacts, or select contacts first and export only those. A label is how Google Contacts groups people, for example a client list or an event's attendees.
If you want the people you've emailed but never saved, Google keeps them under Other contacts in the left menu. Those rows often have an address and nothing else, so the name columns in the output will be blank for them.
Why does my Google Contacts export have duplicate emails?
Because Google Contacts lets the same address sit on more than one contact: an old card and a new one, a contact merged from a phone, or the same person saved once from Gmail and once by hand. The tool lowercases every address and keeps the first one it sees, and tells you how many repeats it removed.
Gmail ignores dots in the part before the @, so ana.silva@gmail.com and anasilva@gmail.com reach one inbox but are counted as two addresses here. To merge those too, run the list through the Gmail dots and +aliases tool.
Can I send a mass email to my Google contacts?
Gmail limits how many recipients you can send to in a day, and Google's sender guidelines ask anyone sending in bulk to authenticate their domain, keep spam complaints low and offer a one-click unsubscribe. For more than a handful of people, an email platform that handles unsubscribes is the safer route.
An address book is also not a mailing list someone signed up for. Email rules such as CAN-SPAM in the US and GDPR in the EU still apply; see the GDPR and B2B cold email guide. And address books age: people change jobs and close mailboxes, so check the list before a first send to keep bounces down.
Is this faster than cleaning the export in Google Sheets?
| This tool | Google Sheets | |
|---|---|---|
| Several E-mail Value columns | Read together | Stack them by hand or with a formula |
| Cells joined with ::: | Split automatically | SPLIT on " ::: " per column |
| Duplicates | Removed, count shown | UNIQUE after stacking |
| Work vs personal | Labelled per row | Needs a list of free domains |
In Sheets, with the email columns in F and H: =UNIQUE(FLATTEN(SPLIT(FILTER({F2:F;H2:H},{F2:F;H2:H}<>"")," ::: ",FALSE))).
Who uses this tool, and for what?
- Freelancers
- Turn years of client and lead contacts into one list for a launch or a service announcement.
- Event organisers
- Export a label of past attendees and get a clean list for the next invite, without the extra columns.
- Small businesses
- Move customer contacts saved in Gmail into Mailchimp, Brevo or a CRM, with work and personal addresses marked.
- Recruiters
- Pull candidate addresses from a shared Google account into an ATS import file.
What can’t this tool tell you?
- It can only list addresses saved in the export; it can't tell you which mailboxes still exist.
- Work or personal is decided by the domain alone, from our list of free and ISP mail providers.
- It reads the CSV export, not a vCard (.vcf) file; use the VCF to CSV converter for those.
- Gmail dot and +tag variants of one inbox are kept as separate addresses.
- Having an address in your contacts doesn't make it lawful to add the person to marketing email.
Common questions
- How do I export my Google contacts to Excel?
- In Google Contacts choose Export, pick Google CSV or Outlook CSV and open the file in Excel. Each email address sits in its own E-mail Value column, so use this tool if you need one list.
- How do I get a list of all email addresses in Gmail?
- Gmail's saved contacts live in Google Contacts. Export them as Google CSV and upload the file here to get every address in one column. People you emailed but never saved are under Other contacts.
- Can I export Google contacts as a CSV?
- Yes. Google Contacts exports Google CSV, Outlook CSV or vCard. Google CSV keeps labels such as Work and Home, which this tool copies into the email_label column.
- Why are some contacts missing an email address?
- Contacts saved from a phone often have only a number. The tool counts the contacts with no address and leaves them out of the list.
- Does this tool upload my contacts?
- No. The file is read in your browser and nothing is sent anywhere unless you choose to check the addresses afterwards.
Sources
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
One plan, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.