To export contact list from Outlook to Gmail, you save your Outlook contacts as a CSV file and then import that file in Google Contacts. Microsoft lists the export steps for classic Outlook, new Outlook and Outlook on the web. Google lists the import steps for CSV and vCard files. Google says an import of more than 3,000 contacts at once can cause problems.
Read the Microsoft guide to export contacts from Outlook and the Google guide to import your contacts into Google Contacts for the full text.
How to Export Contacts in Classic Outlook?
Microsoft lists these steps for classic Outlook for Windows.
- Open Outlook (classic).
- Select File, then Open & Export, then Import/Export.
- Select Export to a file, then Next.
- Select Comma Separated Values, then Next.
- Select the Contacts (This computer only) folder under your account, then Next. You pick one folder for each export.
- Select Browse, choose a save location, name the file and select OK.
- Confirm the save location, select Next and then select Finish.
Outlook shows no completion message. The progress box closes when the export is done. Open the CSV file in Excel to check your contacts. Many empty cells are normal. Close the file without saving changes, because saving can corrupt it for import. If that happens, export again.
How to Export Contacts in New Outlook?
- Select People in the side panel.
- Select Export contacts on the ribbon.
- Under Contacts from this folder, open the dropdown, choose an option and select Export.
Microsoft says new Outlook saves the CSV file to your Downloads folder.
How to Export Contacts From Outlook.com or Outlook on the Web?
Microsoft says you can export contacts from Outlook.com or Outlook on the web and import them into other email apps such as Gmail.
- Select the People icon in the side panel.
- Select Manage contacts, then Export contacts.
- Choose All contacts or a specific folder and select Export.
The file is saved as a CSV file in your Downloads folder.
Why Does the Encoding of the CSV File Matter?
Microsoft says to use UTF-8 encoding because it supports all languages. This matters most for names in Greek, Cyrillic, Arabic or Japanese. If you cannot export as UTF-8, open Excel and select Data, then From Text/CSV. Choose the correct file origin and load the file. Then select Save As and choose CSV UTF-8 (Comma delimited).
How to Import the CSV File Into Gmail Contacts?
Google lists these steps on a computer.
- Go to Google Contacts.
- In the left menu, select Import, then Select file.
- Choose your file. CSV files end in .csv and vCard files end in .vcf.
- Select Import.
When the import is done, Google Contacts opens the newly imported contacts. If a detail is missing, Google says to check the Notes section of that contact.
What are the Limits of This Method?
- One folder per export. Classic Outlook exports one Contacts folder at a time.
- Large imports. Google says an import of more than 3,000 contacts at once can cause problems. It suggests splitting larger lists into several CSV files.
- Account limit. Google Contacts supports up to 25,000 contacts per account.
- Saving the CSV file. Saving changes in Excel can corrupt the file for import.
- Local contacts. Contacts saved locally in classic Outlook may not copy to new Outlook. Export them from classic Outlook first.
What do These Sources Not Say?
- Microsoft gives no limit on file size or contact count for the export.
- Google's page does not say how the column names in an Outlook CSV match Google fields.
- Google's page shows a template that uses the header row to set each field, but it does not say that an Outlook file will match it.
- The Microsoft page with the wizard steps gives no export steps for Outlook on the web. A separate Microsoft page covers those.
- New Outlook has no completion message described on the Microsoft page.
Read the related guides on how to import contacts from a VCF file to Gmail and how to save Outlook autocomplete email addresses for more on moving contacts.
Frequently Asked Questions
How do I export Outlook contacts to Gmail?
Export your contacts to a CSV file in Outlook. Then select Import in Google Contacts and choose that file.
Which file format does Outlook export for contacts?
Microsoft's export page covers CSV (comma separated values). You can open the file in Excel to check it.
Where does new Outlook save the contacts file?
In your Downloads folder.
Can I export all Outlook folders at once?
No. Classic Outlook exports one Contacts folder for each export.
How many contacts can I import into Gmail at once?
Google says more than 3,000 at once can cause problems. Split a larger list into several CSV files.
Why do some names show wrong after import?
Microsoft says a file that is not UTF-8 can break non-English characters. Export as UTF-8 or convert the file in Excel.
Key Takeaways
- Export Outlook contacts to a CSV file, then import that file in Google Contacts.
- Close the CSV file without saving changes in Excel.
- Use UTF-8 for names in non-English alphabets.
- To export contact list from Outlook to Gmail in large batches, split the file into lists under 3,000 contacts.
Sources and References
Facts follow Microsoft Support and Google Contacts Help.
- Export contacts from Outlook, Microsoft Support support.microsoft.com
- Import or export contacts in Outlook using a .csv file, Microsoft Support support.microsoft.com
- Export contacts from Outlook.com or Outlook on the web, Microsoft Support support.microsoft.com
- Import your contacts into Google Contacts, Google Contacts Help support.google.com