Thursday, February 27, 2020

Create a Google Contact Group from a List or CSV File

Google updated Google Contacts last year. With last year’s update they “broke” the way we created contact groups easily. I did a write up (here) sharing a workaround. Google now released a way to create a contact group, and upload many contacts easily. YOu can create a group using a list (must be comma-separated) or a CSV file. Check out both ways below!



Create a Contact Group from a List of Email Addresses:
This is the fastest and probably the easiest way. 
  1. Get all of your email accounts into a list. You can use a document or a spreadsheet (you don’t need headers in a spreadsheet). 


  1. After each email address, you MUST have a comma. 
    1. Document: Just have the list of addresses and add a comma at the end of each address.
    1. Spreadsheet: Make the cell to the right of each email address contain a comma.


  1. Copy this list. If you are using a spreadsheet make sure to copy both columns (email address and comma).


  1. Head over to contacts.google.com (or use the Google Waffle to click on the link).


  1. Click the “Create contact” button.


  1. Click on “Create multiple contacts”.


  1. Paste your copied list into the space for addresses.


  1. Select an existing Group or create a new Group.


  1. Click “Create”.








Create a Contact Group from a CSV File:
This is an easy way if you already have a list of Names and Addresses. 
  1. Get all of your email accounts into a spreadsheet. Download this file to your computer as a CSV file.


  1. Head over to contacts.google.com (or use the Google Waffle to click on the link).


  1. Click the “Create contact” button.


  1. Click on “Create multiple contacts”.


  1. Click “Import Contacts”.


  1. Add or create a new Group and click on “Select file”.


  1. Select an existing Group or create a new Group.


  1. Click on “Import”.





Use these newly created groups in emails and Drive Sharing!

If you want these directions in a document click HERE!