How to Extract All Email Addresses from Gmail and Save Them as a CSV

If you’ve ever needed to pull all the email addresses from your Gmail account—whether for backups, marketing lists, CRM imports, or just curiosity—you’re not alone. Fortunately, there are several ways to do this depending on how deep you want to go and how tech-savvy you are.

Here’s a breakdown of the most effective ways to extract Gmail email addresses and save them as a CSV file.

✅ Option 1: Export from Google Contacts (No Coding Required)

This is the simplest method if you’re looking to export emails you’ve interacted with (sent or received), even if they’re not saved as formal contacts.

📌 Steps:

1. Visit Google Contacts
2. Click “Other Contacts” (on the sidebar) – this includes anyone you’ve emailed.
3. Optionally, include saved Contacts as well.
4. Click the three-dot menu (⋮) > Export
5. Choose the format:
   • Google CSV (for Gmail)
   • or Outlook CSV (for Excel use)
6. Click Export
7. Open the downloaded .csv file in Excel, Google Sheets, or similar.

🎯 What you’ll get: Names, emails, and other available info — neatly organized.

✅ Option 2: Use Google Takeout + Python to Extract All Emails

Need to go deeper and extract every email address from your Gmail inbox (including email threads, CCs, and BCCs)? This method lets you do exactly that.

📌 Step 1: Export Gmail via Google Takeout

1. Go to Google Takeout
2. Deselect all and select Gmail only
3. Click Next Step
4. Choose:
   • Export frequency: Export once
   • File type: .zip
5. Click Create export
6. Wait for your export email and download the .zip file
7. Extract the .mbox file from the archive

📌 Step 2: Use Python to Extract Emails from MBOX

If you’re comfortable with a little coding, use the following script to pull out all email addresses:

import mailbox
import re
import csv

# Load your MBOX file
mbox = mailbox.mbox('path_to_your_mbox_file.mbox')

email_set = set()

# Extract email addresses from headers
for message in mbox:
    for header in ['from', 'to', 'cc', 'bcc']:
        if message[header]:
            found = re.findall(r'[\w\.-]+@[\w\.-]+', message[header])
            email_set.update(found)

# Save to CSV
with open('emails.csv', 'w', newline='') as f:
    writer = csv.writer(f)
    writer.writerow(['Email'])
    for email in sorted(email_set):
        writer.writerow([email])

Replace 'path_to_your_mbox_file.mbox' with the actual file path.

🎯 What you’ll get: A deduplicated list of every unique email address that’s ever appeared in your inbox — as a clean CSV.

✅ Option 3: Use Gmail Extensions or Add-ons

If you prefer browser tools, several Chrome extensions can extract emails directly from your Gmail interface.

Popular Tools:

• Email Extractor for Gmail
• Hunter.io
• FindThatLead

⚠️ Be cautious with third-party extensions: read reviews and privacy policies before installing.

📊 Comparison Table

🧠 Final Thoughts

Whether you’re exporting a client list, cleaning your inbox, or migrating data, Gmail gives you multiple ways to access and back up your email contacts. For most users, Google Contacts export is plenty. But if you need deeper extraction, Google Takeout + a bit of Python is the most powerful option.