How To Create A Mailing List In Gmail From Excel

Creating a mailing list in Gmail from an Excel sheet is a great way to quickly get your contacts into the Gmail system. In this article, I will tell you 2 methods to create a mailing list in Gmail from an Excel worksheet. One is done manually and the other is done automatically. You can choose to use them accordingly.

1. How To Create A Mailing List In Gmail From Excel Manually.

  1. Open your Excel spreadsheet and select the cells containing the email addresses you want to add to your mailing list.
  2. Copy the selected cells by pressing Ctrl+C (or Command+C on a Mac).
  3. Open Gmail and click the Compose button to create a new message.
  4. Click the To field and paste the copied email addresses by pressing Ctrl+V (or Command+V on a Mac).
  5. Separate each email address with a comma.
  6. Click the Save to Contacts button to add the email addresses to your Gmail contacts.
  7. Click the Create List button to create a new mailing list.
  8. Enter a name for the mailing list and click the Create List button.
  9. Your mailing list is now created and you can use it to send emails to multiple recipients at once.

2. How To Create A Mailing List In Gmail From Excel Automatically.

  1. If there are a lot of mail addresses in your excel worksheet file, you can use this method. Below are the steps you need to take.
  2. Open your Excel sheet, then click the File —> Save a  Copy menu item to open the Save a Copy window.
  3. Select the *.csv file extension from the file type drop-down list and click the Save button to save it as a .csv file.
  4. Open Gmail, click on the “Google Apps” icon in the top-right corner, then click on “Contacts”.
  5. On the left sidebar, click “More”, then “Import”.
  6. Click “Choose File” and locate the .csv file you saved.
  7. Click “Import” and the list of contacts will be uploaded into Gmail.
  8. To add the contacts to a mailing list, click the “Groups” button in the left sidebar, then click “Create Group”.
  9. Type in a name for the group, then click “Create”.
  10. Select the contacts you want to add to the group, then click “Add to Group”.
  11. When you’re finished, click “Done”.
  12. And that’s it! You’ve successfully created a mailing list in Gmail from an Excel spreadsheet.

Subscribe to learn more excel tricks.

We don’t spam!

Subscribe to learn more excel tricks.

We don’t spam!

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.