Monday, August 29, 2016

Creating a Distribution List from Google Sheets


Open Shared Parent Email File
  • Select File > Download As > Comma-separated values (csv, current sheet)
After download >
  • Open downloaded  .csv file > Enter the name of your new group in column D (Group Membership) > Columns E and F do not have a corresponding name for import so you have 2 options:
Combine both columns and import with the column heading Notes or remove columns E and F
  • Confirm column headings are Name, E-mail 1- Value, E-mail 2 - Value, Group Membership (you may remove second email column if you prefer only 1 parent email >
  • Save file

To Import Into ContactsScreen Shot 2016-08-26 at 4.19.26 AM.png
  • Open your email account > Switch Mail toggle to Contacts > From the "More" dropdown select Import > Import saved csv. file
  • Contacts will appear individually and in the newly created group