Google Email Contacts

It's that time of the year!  Parents are completing Google forms, updating Skyward information, and more. We have all types of data, but sometimes it is difficult to get it from one place to another. Contact lists for your classes are a quick way to send an email to your students' parents throughout the year. Rather than enter contacts one by one, use the digital data you already have!

Here is a copy of a Google Sheet ready to import into your Gmail Contacts!  From wherever you have your digital data (a Google Sheet from Google Form Responses, Excel from Skyward export, etc.), you can copy and paste your info into the correct fields. I have found that it is best to not delete any fields but only enter the information that you would like to import.

Once you have entered your information, download your Google Sheet as a Comma-separated value (.csv) file.

Open Contacts> More> Import.

When prompted to import contacts from other accounts, select CSV or vCard file.

This feature is currently only available in the old version of Google Contacts, so select "Go To Old Version".

Once on the old version, select Import Contacts

Select "Choose File" and navigate to the Sheet you saved as a .csv file. Click Import and watch the magic happen.

Once the import is complete, look at the left-hand column for the import labeled by date and select.

Look across the top of the screen and find "More", select the drop-down box and select "Rename group" and rename your contact group.

Now, you are ready to start communicating!  When you are composing an email, begin typing the name of your contact group and it should appear as a choice to select!  Don't forget to include your contact group in the BCC field!

Are you sharing your homeroom students with another teacher?  You can share your new contact group with them as well!  Here is a blog post with step-by-step instructions!

 Happy "e"mailing!