There are lots of articles about how to export your Gmail contacts. But they all tell you the same thing: how to export Gmail contacts that are in your “Contacts” list.
Well, what if you want to export a list of every email address you’ve ever sent to or received an email from? And get rich response time data on each of those people?
In this article, I’m going to show you how to do both.
Table of Contents
- Method 1: Export Your Gmail Contacts Already in Your Address Book
- What About Contacts Added Automatically by Gmail?
- Method 2: Export a List of Every Email Address You’ve Sent an Email to or Received an Email From
Method 1: Export Your Gmail Contacts Already in Your Address Book
First, we’ll cover how to export your actual contacts in Gmail – the ones in your address book. There are already a ton of guides on how to do this simple process, but we’ll cover it here also for completeness’ sake.
Step 1. Open Google Contacts.
Visit https://contacts.google.com or click the menu in the upper-right corner of Gmail and choose “Contacts” from the list of apps.
Step 2. Click “Export.”
Step 3. Choose an Export Format.
You can choose from:
- Google CSV – Exports all data in Unicode format, which preserves international characters. Outlook does not support Unicode.
- Outlook CSV – Exports all data and converts characters to default character encoding, which is supported by Outlook.
- vCard (for iOS Contacts) – Supported by many email programs.
Step 4. Click Export.
What About Contacts Added Automatically by Gmail?
Gmail automatically adds email addresses to your contact list whenever you respond to an email or forward one to a new email address. You can find a list of these entries under “Other contacts” in Gmail Contacts.
To export these Gmail contacts:
Step 1. Select a Contact.
Hover your mouse over one of the contacts. You’ll see a check-box that you can tick to select that contact. Click to select the contact.
Step 2. Now you can “Select All Contacts.”
Click the newly-appeared drop-down box that appears as the new column header, and select “All.”
EmailAnalytics Visualizes Your Team's Email Activity
- 35-50% of sales go to the first-responding vendor.
- Following up within an hour increases your chances of success by 7x.
- Salespeople spend an average of 13 hours per week on email.
Step 3. Click Export.
Click Export and select “Selected contacts.”
Method 2: Export a List of Every Email Address You’ve Sent an Email to or Received an Email From
What about email addresses you’ve received an email from, but didn’t respond to or forward? Next, I’ll show you how to export a list of email addresses that includes these.
And you can get rich insights about each email address, too, including how many emails you’ve sent and received from each one, as well as each party’s average email response time. Here’s what the export looks like:
We’ll be using our app, EmailAnalytics, to do this. So if you don’t already have an account, sign up for a free trial (it takes 10 seconds). This method works whether you have a free trial or an active paid account.
Step 1. Login to EmailAnalytics
Step 2. Set your date range
All your contacts exported will be within the date range you choose. Make it as large as you like. If you’re on the free trial, you’ll be limited to just a few weeks of data, though.
Step 3. In your Top Interactions table, click the triple-dot icon then select “Export (ALL)”
That’s it! You’ll be able to download an Excel file with your list of contacts and a bunch of sweet metrics about each one.
Well, that covers it! Two methods you can use for how to export your Gmail contacts.
Let me know in the comments if you found this guide helpful!
Jayson is a long-time columnist for Forbes, Entrepreneur, BusinessInsider, Inc.com, and various other major media publications, where he has authored over 1,000 articles since 2012, covering technology, marketing, and entrepreneurship. He keynoted the 2013 MarketingProfs University, and won the “Entrepreneur Blogger of the Year” award in 2015 from the Oxford Center for Entrepreneurs. In 2010, he founded a marketing agency that appeared on the Inc. 5000 before selling it in January of 2019, and he is now the CEO of EmailAnalytics.