Import your contacts into Google Contacts

You can use a template to make sure that your contacts' details are imported into the right fields in Google Contacts.

Step 1: Fill in the contacts template

Important: Do not delete the header row in the template. These headings help make sure that your contacts' info is saved to the right place in Google Contacts.

1. Open the sample template.
2. Click Make a copy.
   • If you want to download the template to another application, like Excel:
     1. Click File Download.
     2. Choose the application where you'd like it saved.
     3. Open the spreadsheet in that application.
        • If your cells are merged or formatted incorrectly in the opened file, check that application's support channels.
   • If the option to make a copy doesn't appear, click menu Make a copy.
     1. If 'Make a copy' is not an option, select Share and export Make a copy.
3. Fill in the spreadsheet with the details for all contacts that you want to import.
   • You can fill in the columns that you want to save to Google Contacts and delete the columns that you don't use.
   • A new contact is created for every row that has any entered data.
4. Click File Download Comma-separated values (.csv).
5. Save your file.
   • Make sure that you save it someplace that you'll remember, like your desktop.

Tip: If you're not familiar with Google Sheets, learn more about how to use it.

Step 2: Upload your file to Google Contacts

1. Open Google Contacts.
2. On the left, click Import .
   • If you don't see the menu on the left, at the top left, click Menu .
3. Click Select file Select your new contacts file.
4. Click Import.
   • When the import is done, Google Contacts will open your newly imported contacts.

To make sure that your contacts' info imports exactly where you want it to, use the headers from the template. You can learn about the template's headers and how contact fields are formatted.

Header name	Field description
Name prefix	Prefix for your contact. For example: 'Dr' or 'Prof'.
First name	First or given name for your contact.
Middle name	Middle or additional name for your contact.
Surname	Surname or family name for your contact.
Name suffix	Suffix for your contact. For example: 'Sr' or 'Jr'.
Phonetic first name	Phonetic pronunciation for your contact's first or given name.
Phonetic middle name	Phonetic pronunciation for your contact's middle or additional name.
Phonetic surname	Phonetic pronunciation for your contact's surname or family name.
Nickname	Nickname for your contact.
File as	Name used to organise your contact.

Contact fields:

Header name	Field description
Email <number> – label	Label of the email. For example: 'Home' or 'Work'.
Email <number> – value	Email for your contact. For example: '[email protected]'.
Phone <number> – label	Label of the phone number. For example: 'Home' or 'Work'.
Phone <number> – value	Phone number for your contact. Use a '+' to indicate a country code. For example: '+44 2345 678900'. Spaces, dashes and parentheses are optional.

Address fields:

Header name	Field description
Address <number> – label	Label of the address. For example: 'Home' or 'Work'.
Address <number> – country	The country of the address.
Address <number> – street	The street of the address.
Address <number> – extended address	The secondary street of the address if it has one.
Address <number> – city	The city of the address.
Address <number> – region	The state, province, prefecture and more of the address.
Address <number> – postcode	The postcode of the address.
Address <number> – PO box	The post office box of the address.

Organisation fields:

Header name	Field description
Organisation name	The name of the contact's organisation, like a company or school.
Organisation title	The contact's title in their organisation.
Organisation department	The contact's department in their organisation.

Event fields:

Header name	Field description
Birthday	Birthday for your contact. Can be formatted as either DD-MM-YYYY or DD-MM-- if there's no year.
Event <number> – label	Label of the event. For example: 'Anniversary'.
Event <number> – value	Date for this contact's event. Can be formatted as either DD-MM-YYYY or DD-MM-- if there's no year.

Other fields:

Header name	Field description
Relation <number> – label	Label of the relation. For example: 'Spouse' or 'Cousin'.
Relation <number> – value	Name of the relation. For example: 'Alice Jones' or 'Bob'.
Website <number> – label	Label of the website. For example: 'Profile' or 'Blog'.
Website <number> – value	Website address.
Custom field <number> – label	Label for the custom field. Useful if you'd like to save contact data that doesn't fit in one of the default fields offered above.
Custom field <number> – value	Value for the custom field.
Notes	Notes on your contact. Any text can be entered here.
Labels	Names of the labels that this contact is a part of. You can enter multiple values here separated by ':::'. For example: 'Work Friends ::: Family ::: Project11'.

Tip: If you have contacts with multiple emails, phone numbers and more, you can insert extra columns in the template to enter this data.

Step 1: Export existing Google contacts

1. On your computer, go to Google Contacts.
2. At the top right, click Export .
3. Select the contacts to export.
4. Click Google CSV Export.
5. Save the file somewhere that you'll be able to find it easily.
6. At the top right, click your profile picture Sign out.

Step 2: Import the file

1. On your computer, go to Google Contacts.
2. Sign in with your other Gmail Account.
3. On the left, click Import Select file.
4. Choose your file.
5. Click Import.

You may have problems when:

• You import more than 3,000 contacts at a time. If you have more than 3,000 contacts, split them into multiple CSVs before you import them.
• You reach the limit of 25,000 contacts. Learn about contact size limits.
• The contacts aren't formatted to work with Google Contacts. Make sure that you save your contacts as a vCard or CSV file.