Contacts (Mac OS)

How to Import and Export Contacts Between Outlook and Gmail

You can use Microsoft Outlook with just about any email account, including Gmail—but Outlook doesn’t provide a built-in way to sync your Gmail contacts. If you’ve amassed a bunch of contacts in either service, you’ll have to import them from the other manually to use them.

You could re-enter each contact one by one, of course, but we recommend importing all of your contacts in one go. In this article, we’ll demonstrate how to first export your contacts from Gmail into Outlook, and then export from Outlook into Gmail.

2017 Top Phone Solutions – Compare and Save
Business Phone Ratings + Reviews. Pricing, Features, Special Deals! Go to whichvoip.com

How to Export Contacts from Gmail and Import Them into Outlook

To export contacts from your Gmail account, open a browser and log in to your account. Then, click on “Gmail” and then select “Contacts” from the dropdown.

Google is redesigning Contacts and you can try out the Contacts preview (click on “Try Contacts preview” in the menu on the left when viewing contacts in the old version). However, the Contacts preview does not allow you to export contacts yet, so we have to revert to the old version to export our contacts. To do that, click “Go to the old version” at the bottom of the list of options on the left.

Once you’re back in the old version of Google Contacts, click “More” at the top of the page and select “Export” from the dropdown.

Notice, you can export a group, selected contacts, or all your contacts into one of three formats. The export format should be an Outlook .CSV (CSV = Comma Separated Values, which means each field [Name, Address, Phone, etc.] is separated by a comma) file. Select the contacts you want to export, and then select the “Outlook CSV format” option.

Click “Export” to start the export process.

On the Save As dialog box, navigate to where you want to save your contacts CSV file. By default, contacts.csv is entered in the “File name” box as a suggestion for a name, but you can change that, if you want. Then, click the “Save” button.

When the export is finished, you can open the exported .CSV file in Excel and manipulate itby adding addresses, phone numbers, email addresses, and other information that will help round out your address book. While this is an optional step, it’s nice to be able to go through and make your contacts neat and consistent.

When you’re ready, it’s time to import your shiny new contacts file into Outlook. Open Outlook and click the “File” tab.

On the backstage screen, click “Open & Export” on the left and then click the “Import/Export” button.

The Import and Export Wizard dialog box displays. Select “Import from another program or file” under Choose an action to perform and then click the “Next” button.

Select “Comma Separated Values” and click the “Next” button.

Now, we need to select the file to import, so click the “Browse” button.

On the Browse dialog box, navigate to the folder where you saved the .csv file, select the file, and then click the “OK” button.

Under Options, decide whether or not you want duplicates to be imported. You can save yourself time later by selecting “Do not import duplicate items” now. Click the “Next” button.

Select “Contacts” in the Select destination folder box under the email account where you want to save your contacts. Then, click the “Next” button.

The last screen on the Import a File dialog box shows you…