Export Email Addresses from Google Sheets to Gmail (2023)
In this article we will show how to export email addresses from google sheets to Gmail in just a few simple steps. Simply follow the steps below:
Export Emails from Google Sheets to Gmail
1. Format the list of email addresses
For Gmail to be able to read the entries you need at least two columns with the headers Name and E-mail.
2. Click File, Choose Download, then Select Comma Separated Values (.csv)
To add the list of email addresses to Gmail, they must be uploaded as a CSV file. To do so, click File, choose Download, then select Comma Separated Values (.csv).
3. Import CSV File to Google Contacts
To upload the list, go to Google Contacts (https://contacts.google.com).
The main page of Google Contacts lists the contacts already in your contact list. To import the CSV file, click the Import icon found in the upper-right corner of the list.
A small box labeled Import contacts will appear. Click Select file.
A window for finding the file in your computer will appear. Find the CSV file, then select it.
Once you select the file, click Import.
You have now imported the email addresses from Google Sheets to Gmail! Try drafting an email, and you will see the added email addresses appear when you type their names: