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.

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.

Avery Label Merge

Use your Google Contacts sheet to create labels in Google Docs and Sheets.

WhatsApp Sender

Use your Google Contacts sheet to send bulk personalized WhatsApp messages in Google Sheets.