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:
For Gmail to be able to read the entries you need at least two columns with the headers Name and E-mail.
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).
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:
If you enjoyed this article, check out our articles on:
How to create an address book template for google sheets
How to make an email link in google sheets
If you enjoyed this article, you might also like our article on how to set up conditional formatting based on other cells in Google Sheets or our article on how to set up conditional formatting for checkboxes in Google Sheets.
If you want to learn how to export email addresses from Google Sheets to Gmail, we also suggest checking out our detailed guide.
