How to Import CSV Contacts to Gmail and Sync Them to iPhone

To import contacts into Gmail from a CSV file, go to contacts.google.com on a computer, click Import on the left, click Select file, choose your .csv file, and click Import. To get those contacts on an iPhone, add the same Google account under Settings > Apps > Contacts > Contacts Accounts and turn on Contacts.

This covers Google Contacts in a web browser on a Windows PC, Mac or Chromebook, and iPhones on iOS 18 through iOS 27, with a note for iOS 17 and earlier. The steps, template rules and limits come from Google’s Import your contacts into Google Contacts help page.

How Gmail Stores Contacts

Gmail doesn’t keep its own address book. It uses Google Contacts, so anything you import there shows up when you type a name in the To field in Gmail, on any device signed in to that Google account.

You need:

  • A computer with a web browser. Google’s import steps are written for a computer.
  • The Google account you want the contacts in. If you have more than one Gmail address, check the profile picture at the top right of Google Contacts before you import.
  • A .csv or .vcf file. CSV (comma-separated values) is a plain-text table with one contact per row, the format spreadsheets and Outlook export. A vCard (.vcf) is a contact-card file, the format iPhones and most phones export. Google accepts both. An Excel workbook (.xlsx) has to be saved as CSV first.

How to Import a CSV File Into Gmail Contacts

  1. On your computer, go to contacts.google.com and sign in with the Gmail account you want the contacts in. From Gmail, you can also click the Google apps grid (nine dots) at the top right and choose Contacts.
  2. On the left, click Import. If you don’t see the menu, click Menu (three lines) at the top left first.
  3. Click Select file.
  4. Choose your file. CSV files end in .csv; vCard files end in .vcf.
  5. Click Import.

When the import finishes, Google Contacts opens the contacts it just added so you can check them. Open two or three and confirm that names, email addresses and phone numbers landed in the right fields before you sync anything to a phone.

Steps to import a CSV file into Google Contacts for Gmail
Illustration: how to import a CSV file into Gmail contacts.

Imported contacts go into your main contact list, not Other contacts, which is where Gmail keeps people it saved automatically. Send yourself a test by starting a new email in Gmail and typing the first few letters of an imported name.

How to Build a CSV File Google Can Read

Google reads its own column headings best. If your list is in a spreadsheet, start from Google’s contacts template so each detail lands in the right field:

  1. Open the sample template linked on Google’s import help page and click Make a copy. If you don’t see that button, use the three-dot menu or Share & export to find Make a copy.
  2. Keep the header row. Google says the headings tell Google Contacts where each piece of information belongs.
  3. Fill in one row per contact. Google creates a new contact for every row that has any data in it, so delete blank or test rows first. You can delete columns you don’t use.
  4. Click File > Download > Comma Separated Values (.csv) and save the file somewhere easy to find, such as your desktop.
  5. Import the file with the steps above.

Template headings worth knowing, per Google:

Heading What goes in it
First Name, Last Name The contact’s name
Email 1 – Value, Email 1 – Label The address, and a label such as Home or Work. Add Email 2 columns for a second address.
Phone 1 – Value Start with + and the country code, such as +1 234 567 8901
Birthday YYYY-MM-DD, or –MM-DD with no year
Organization Name, Title Company and job title
Labels Label names separated by :::, such as Work Friends ::: Family
Notes Any free text
How to prepare a CSV file for Google Contacts with the template
Illustration: how to prepare a CSV file for Google Contacts.

Save an Excel List as CSV

If your contacts are already in Excel, you don’t have to retype them:

  1. Rename your column headings to match the template, such as First Name, Last Name, Email 1 – Value and Phone 1 – Value.
  2. Click File > Save As and choose a folder.
  3. In the file type list, choose CSV UTF-8 (Comma delimited) (*.csv) and click Save. UTF-8 keeps accented letters and non-English names readable.
  4. If Excel warns that some features will be lost or that only the current sheet is saved, click OK or Yes. Your original workbook stays as it was.

A CSV holds only one sheet, so put all the contacts on the same tab. If your list is in Google Sheets instead, you can download the sheet as a CSV from the File menu.

To check that the header row came through correctly, open the CSV file in Notepad before you import it.

Show Imported Gmail Contacts on an iPhone

The iPhone Contacts app can’t open a CSV file and import its rows. Import the CSV into Google Contacts on a computer first, then add the same Google account to your iPhone:

  1. Open Settings > Apps > Contacts > Contacts Accounts. On iOS 17 and earlier, go to Settings > Contacts > Accounts.
  2. Tap your Google account. If it isn’t listed, tap Add Account > Google and sign in to the account you imported into.
  3. Turn on Contacts, then tap Save if you see it.
  4. Open the Contacts app, tap Lists, choose the Gmail list, and look for one of the imported names.
iPhone Google account settings with the Contacts switch turned on
Turn on Contacts for the Google account you imported into.

Apple’s contacts accounts guide and Google’s sync steps for iPhone and iPad both cover this route. The contacts stay in Google, so edits you make on the iPhone change the Google copy too.

If the Gmail copies end up joined to the wrong people on your iPhone, you can unlink contacts on your iPhone without deleting either card.

If you want new contacts you add on the iPhone saved to Gmail as well, go to Settings > Apps > Contacts > Default Account and choose your Google account.

On an iPad, here’s how to get your Gmail contacts on an iPad. On an Android phone, the contacts appear automatically in the Contacts app once the same Google account syncs.

If the Contacts Don’t Show Up on the iPhone

  • Wrong account. Check that the Google account on the iPhone is the one you imported into. Personal and work accounts are easy to mix up.
  • Contacts switch is off. Go back to the account under Contacts Accounts and make sure Contacts is on.
  • The Gmail list is hidden. In Contacts, tap Lists and select the Gmail list or All Contacts.
  • Sync hasn’t caught up. Reopen Contacts and wait a minute on Wi-Fi. Google’s troubleshooting steps also suggest checking that Use SSL is on under the account’s Advanced settings, then adding the account again if needed.
  • Work or school account. Your administrator may limit contact syncing. Ask them instead of removing and re-adding the account.

Put the Contacts in iCloud Instead

If you’d rather keep everything in iCloud, Google Contacts can convert the file for you:

  1. Import the CSV into Google Contacts with the steps above.
  2. Select the imported contacts, click Export at the top right, choose vCard (for iOS Contacts), and click Export.
Google Contacts export dialog with vCard for Android or iOS selected
Export the imported contacts as a vCard for iCloud.
  1. On a computer, go to icloud.com/contacts, click the Add button, and choose Import Contact.
  2. Select the .vcf file.

Each person in a multi-contact vCard becomes a separate entry in All Contacts, and the contacts then sync to every device signed in to the same Apple Account with Contacts turned on in iCloud. Use one route or the other; importing into both Google and iCloud gives you two copies of everyone on the iPhone. You can also view iCloud contacts on a computer to check the result.

Fix Common Import Problems

  • More than 3,000 contacts: Import no more than 3,000 at a time. Split the list into several CSV files and import each one.
  • 25,000-contact limit: This is the maximum number of contacts for a Google account.
  • File isn’t accepted: Google only accepts CSV or vCard files. Save the spreadsheet as CSV again and make sure the name ends in .csv, not .xlsx or .txt.
  • Strange characters in names: The file wasn’t saved as UTF-8. Save it again as CSV UTF-8 and import it again.
  • Phone numbers look like 1.23E+10: Excel converted them to scientific notation. Format the phone column as Text, retype or paste the numbers, and save the CSV again.
  • Details missing or in the wrong place: Check the contact’s Notes section for the missing detail. Then compare your headings with the template’s, fix them, and import again.
  • Everyone appears twice: You imported the same file twice, or the people were already in your contacts. Clean them up with the merge steps below.

Clean Up Duplicates After Importing

Google’s Merge duplicate contacts steps:

  1. In Google Contacts, click Menu at the top left, then Merge & fix.
  2. Click Merge on a suggestion, or Merge all to accept every suggestion.

The duplicates are combined into one contact. If there’s no merge option, you don’t have contacts that can be merged, and contacts saved in different Google accounts can’t be merged. Once the merged contacts sync, the iPhone shows one entry too. If you still see doubles on the iPhone from different accounts, you can merge duplicate contacts on iPhone.

If an import went badly wrong, Google Contacts has an Undo changes option in its Settings menu that restores your contact list to an earlier point, such as before the import. Pick a time just before you imported, then fix the file and import it again.

Contact Import and Sync Questions

Can I import an Excel file directly?

No. The import page accepts only CSV and vCard files, so save or download the spreadsheet as a .csv first.

How do I move contacts from another Gmail account?

In the old account, go to Google Contacts, click Export, choose Google CSV, and save the file. Then sign in to the other account and import that file with the steps above.

Can I import contacts from Outlook or Yahoo?

Yes. Export the contacts as a CSV or vCard file from that service, then import the file into Google Contacts. Gmail can also pull mail and contacts from some other email accounts under Settings > See all settings > Accounts and Import > Import mail and contacts.

Do imported contacts sync back to my iPhone automatically?

Yes, once the Google account is added to the iPhone with Contacts turned on. New imports appear on their own after the next sync, with no extra steps on the phone.

Related Guides

After importing, open your Google Contacts list to check that everything came through.

Use Outlook too? Here’s how to import an Excel list into Outlook contacts with the same kind of CSV file.