Import Google Contacts
How do I import my Google Contacts into a Google Sheet?
Import your contacts into a Google Sheet from Google Contacts.
Watch a Video Tutorial
Watch this quick tutorial or follow the step-by-step instructions below to find out how to import Google Contacts into a Google Sheet.
If you have not already done so, install the free Import Google Contacts add-on for Google Sheets
Step 1
From a new or existing Google Sheet, click on the Show side panel arrow (if the side panel is not already visible) and then click on the Import Contacts icon.
This will open the Import Google Contacts sidebar.
Step 2
From the Import Google Contacts sidebar, click on the Contacts to Import drop-down and select which of your contacts you would like to import.
Options include importing all contacts or importing contacts with a particular label.
Step 3
Select the data fields that you would like to import for your contacts from the checkboxes listed under Import Data.
Step 4
Click Import.
This will create a new tab in your Google Sheet called Google Contacts and will import the data you selected in Step 3 for the contacts you selected in Step 2 (see the screenshot below).
Your Google Contacts are now imported into a Google Sheet.
Use this add-on in conjunction with these extentions from Quicklution
Mail Merge
Use your Google Contacts sheet to mail merge in Google Docs, Sheets, Slides and Forms.
WhatsApp Sender
Use your Google Contacts sheet to send bulk personalized WhatsApp messages in Google Sheets.