How to Extract All Email Addresses from Gmail

Contacts

Gmail Exporter Guide

If you've been using Gmail for years, you've built up a quiet directory of everyone you've ever corresponded with — clients, vendors, colleagues, leads. Pulling those addresses into one deduplicated list is genuinely useful for importing into a CRM or building a contact list. This guide covers the fastest way to do it, the alternatives, and an important note on doing it responsibly.

Method 1: The 1-click Chrome extension (fastest)

This is the quickest route and keeps your data on your machine the whole time.

1. Install the extension. Add Gmail Exporter to Chrome (it's free, no sign-up).
2. Open Gmail. Go to the inbox, a label, or run a search to narrow down exactly the conversations whose addresses you want.
3. Remove duplicates. Click to de-duplicate so each address appears once, not once per email in a thread.
4. Click Export. Choose CSV and the file downloads straight to your computer.
5. Open it. Double-click to open in Excel, or in Google Sheets use File → Import.

Because everything runs inside your browser tab, the addresses are never sent to a third-party server — an important difference from cloud-based add-ons that require account access. The extension reads the From address of each message, and where available the To and Cc fields, so you capture both people who emailed you and people you emailed.

Method 2: Google Workspace add-ons

There are Google Workspace add-ons that connect to your mailbox and read message fields — To, From, Cc, Subject and body — then write the results into a Google Sheet. These can be flexible, but they typically request broad permission to read your mail and process it on their own servers. If you use one, check what data it stores and where. They're a reasonable option when you need server-side automation; for a quick local extract, the extension is simpler and keeps everything on your device.

Method 3: Manual copy (small lists only)

For a handful of contacts you can open each message, copy the sender's address, and paste it into a spreadsheet. This is fine for ten or twenty addresses but quickly becomes impractical — and error-prone — at any real scale, with no automatic de-duplication. Google Contacts can also export to CSV, but it only includes people you've saved as contacts, not everyone you've actually corresponded with.

Comparing the methods

Cleaning and de-duplicating the list

A raw extract usually has the same address many times — once for every email in a long thread. Before you do anything with it, clean it up:

• Remove duplicates so each address appears exactly once. The extension does this in one click; in a spreadsheet you can use Data → Remove duplicates.
• Filter out noise. Drop no-reply addresses, automated notifications and your own address before importing anywhere.
• Normalize case. Email addresses aren't case-sensitive, so lowercase everything to avoid the same person appearing twice.
• Use Gmail search first. Operators like from:, label: and after: let you extract exactly the right subset rather than your whole mailbox.

Common use cases

Once you have a clean list, the two most common things people do with it are:

• CRM import. Map the address, name and date columns to your CRM's fields so existing relationships are recorded in one place.
• Mailing list. Build a list of people you have a genuine relationship with — but read the next section first.

A responsible note on consent and anti-spam