Export Google Contacts to Outlook Without Losing Details

To export Google Contacts to Outlook, open Google Contacts, choose Export, and select the Outlook CSV format; then import that CSV into the Outlook account where you want the contacts. This is a one-time copy, not an ongoing sync, so check the imported records and repeat the export later if you need to transfer newer changes.

What the export does—and what it does not do

Google Contacts can create a comma-separated values file formatted for Outlook. A CSV file stores contact details in rows and columns, which makes it a practical way to move many people at once. Google’s Outlook CSV option is preferable to choosing a general-purpose format because its column headings are intended to work with Outlook’s contact importer.

The transfer copies contact information such as names, email addresses, phone numbers, and address details when those fields are present and recognized. Some less-common details, custom fields, photos, and Google contact labels may not map exactly to Outlook. After importing, review a sample of records and any contacts that contain unusual or extensive information.

Exporting does not move the contacts out of Google or connect the two services. Your Google contacts remain in Google, and Outlook receives a separate copy. Changes made later in one service do not automatically appear in the other. That distinction matters if you keep using both address books.

Export contacts from Google

Go to Google Contacts and sign in to the Google account that contains the people you want to transfer.
To export everyone, use the Export option in the left-side menu. To transfer only some people, select the relevant checkboxes first, then choose Export for the selected contacts.
Choose Outlook CSV as the export format. If Google asks which contacts to include, confirm that the selection is the one you intended.
Select Export and save the downloaded CSV file somewhere easy to find, such as your Downloads folder.

If the left navigation is collapsed, look for the menu or expand it to reveal the export command. Google may adjust interface wording or layout over time, but the important choice is the Outlook CSV format, not the general Google CSV or vCard option. Keep the original downloaded file unchanged until you have confirmed the Outlook import worked.

Before exporting a large address book, consider whether you really need every record. Google Contacts can include old, incomplete, or automatically saved contacts alongside people you actively use. Exporting a selected group can reduce clutter in Outlook, though selecting the wrong set is an easy way to leave important people behind. Check the selection before downloading.

Import the CSV into Outlook

The exact route depends on which Outlook version you use. In classic Outlook for Microsoft 365 on Windows, use the import wizard:

Open Outlook and select File > Open & Export > Import/Export.
Choose Import from another program or file, then select Comma Separated Values.
Browse to the Google CSV file. Choose how Outlook should handle duplicates: replace duplicates, allow duplicates, or do not import duplicates.
Select the Contacts folder for the account or data file where the contacts should be added.
If offered, use Map Custom Fields to check how the CSV columns correspond to Outlook contact fields, then finish the wizard.

Outlook can take a short time to process a large file. Afterward, open the Contacts or People view and inspect several entries, including one with a phone number, one with a postal address, and one with multiple email addresses if your list has them. Confirm that the contacts landed in the intended account’s Contacts folder rather than another mailbox or a local data file.

In new Outlook for Windows, open People, then choose Manage contacts > Import contacts and follow the prompts to select the CSV. Outlook on the web generally offers a similar route: open People, choose Manage contacts, and select Import contacts. Menu labels can vary slightly with account type and interface updates. If you cannot find the import control, try the web version for the same Microsoft account or switch to classic Outlook if it is available.

Outlook for Mac users can use the account’s Outlook on the web People page as a straightforward alternative when the desktop app does not show a CSV import option. Importing through the web interface places the contacts in the account’s online address book, which can then sync to Outlook on other devices. For a work or school account, an administrator may restrict contact features or imports.

Check field mapping and contact details

A CSV is a table, and Outlook has to match each column to a contact field. The Google-created Outlook CSV is designed to reduce this work, but a mismatch can still happen, especially if the file was edited, converted, or created with a different export option. In classic Outlook, Map Custom Fields lets you inspect the source columns and their destinations before completing the import.

Pay particular attention to records with more than one email address or phone number, middle names, company names, job titles, or international addresses. A field may import into a less obvious location, or a detail may be omitted if there is no corresponding field. If a detail is important, compare the Outlook record with the Google record rather than assuming every column transferred just because the import completed.

Avoid opening and resaving the CSV in a spreadsheet unless you need to make a deliberate correction. Spreadsheet applications can reinterpret phone numbers, leading zeros, dates, and other values. For example, a phone number beginning with zero is not a calculation, but software may treat it as one and remove the zero. If you must edit the file, preserve the original, check the delimiter and text encoding, and inspect the changed rows before importing.

Choose how Outlook handles duplicates

The import wizard’s duplicate choice can affect the final address book. If this is your first import into an empty Outlook Contacts folder, allowing duplicates is usually less risky than accidentally replacing an unrelated record. If you have already imported the same list, choosing not to import duplicates can help prevent a second copy, although Outlook’s duplicate matching may not identify every near-match.

Names are not always unique, and the same person may have a different email address or spelling in each service. Conversely, two people can share a name. Before running another import, search Outlook for a few known contacts and decide whether you are adding a new batch or repeating a previous transfer. For a clean repeat, you might first remove the imported test records or use a separate Contacts folder, but do not delete a whole folder unless you have verified what it contains.

Do not assume that importing a changed CSV will update all existing Outlook contacts. The outcome depends on the importer and duplicate settings, and an import is not a dependable two-way merge tool. For a small set of corrections, updating the records in Outlook may be simpler than importing the whole list again.

Common problems and practical fixes

The file is not accepted: Check that you selected Google’s Outlook CSV export rather than a vCard file, and confirm the saved file has a .csv extension. If it was edited, try importing the untouched original.
Contacts appear in the wrong place: In classic Outlook, check the destination folder selected in the wizard. In Outlook on the web or new Outlook, confirm which account is open in People.
Some fields are blank or misplaced: Review Map Custom Fields in classic Outlook, then inspect the CSV headers and a few affected rows. A field that Google and Outlook represent differently may need manual correction.
Names or characters look incorrect: The file may have been resaved with a different encoding or modified by a spreadsheet. Re-export from Google and import the untouched file before trying more complex edits.
There are duplicate people: Check whether the CSV was imported more than once and whether the duplicate option was set to allow duplicates. Search by email address as well as name when identifying repeats.
The import option is missing: Check People rather than Mail, try Outlook on the web, and verify that you are signed in to the intended account. Work or school settings may limit what you can do.

If the import reports success but the contacts do not immediately show on a phone or another computer, allow time for account synchronization and verify that the device is displaying the same Microsoft account. A contact imported into a local Outlook data file will not necessarily appear on other devices; an account’s online Contacts folder is the better destination for cross-device access.

Privacy and safe handling

A contacts export is a file containing personal information, not just a harmless settings file. It may include private email addresses, phone numbers, home or work addresses, and notes. Save it only on a device or storage location you trust, do not send it through an unapproved file-sharing service, and remove extra copies when you no longer need them, subject to any work or retention requirements that apply to you.

Use the direct Google and Microsoft import routes where possible. A third-party converter is usually unnecessary for a Google Outlook CSV and would give another service access to the contact data. If this is a company address book, check organizational policy before exporting it to a personal computer or personal Microsoft account.

Alternatives and keeping contacts current

Choose CSV when your goal is a bulk, one-time transfer that Outlook can import. A vCard export is useful for sharing individual contact cards and is supported by many address-book applications, but Google’s Outlook CSV option is the more direct choice for a list import. Copying contacts one by one is reasonable for only a handful of people, but becomes slow and prone to mistakes for a large list.

If you want the same contact changes to appear in both Google and Outlook automatically, a CSV import will not provide that. You would need a supported synchronization arrangement or a service designed to sync the two accounts, and you should assess its permissions and privacy terms before granting access. Another simple option is to choose one address book as the primary place to maintain contacts and periodically export and import updates when necessary.

For a one-off migration, a cautious workflow is to export a selected or complete list, import it into the correct Outlook account, review representative records, and keep the original CSV until you are satisfied. If you are unsure how Outlook will handle duplicates, test with a small selected group first. That makes it easier to spot field-mapping or account-selection problems before transferring the full address book.

Frequently Asked Questions

Can I export Google Contacts directly to Outlook?
Yes. In Google Contacts, choose Export and select Outlook CSV. Import the downloaded file into the Outlook Contacts folder for the account you want to use.

Will Google Contacts keep syncing with Outlook after the import?
No. A CSV import makes a copy at that moment. Later edits in Google do not automatically update Outlook, and Outlook edits do not update Google through this method.

Should I choose Outlook CSV or vCard in Google Contacts?
Choose Outlook CSV for a bulk import into Outlook. vCard is commonly used to share contact cards and is not the most direct option for importing a large list through Outlook’s CSV importer.

Can I import contacts into Outlook on the web?
Usually, yes. Open People for the Microsoft account, then look under Manage contacts for Import contacts. If that option is unavailable, try classic Outlook on Windows or check whether your organization restricts imports.

Why did Outlook create duplicate contacts?
The same CSV may have been imported more than once, or the import may have been set to allow duplicates. Outlook may also treat contacts with different email addresses or details as separate people. Review records before repeating an import.

Will Google labels become Outlook contact groups?
Do not assume they will. Labels and groups are organized differently across the services, and they may not transfer as Outlook categories or groups. Check the resulting contacts and recreate important organization inside Outlook if needed.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.