how to import contacts into outlook from csv

Now all Google contacts are successfully imported into the specified Contacts folder in Outlook. In the last Import a File dialog box, keep the Import “ontacts.csv” into folder: Contacts box checked, and then click the Finish button. Now please select an Outlook Contacts folder to import the Google contacts. Shift to the People (or Contacts) view in Outlook, and click Home > New Contact Group to create a new contact group. In the second Import a File dialog box, click the Browse button to select the Excel csv file you have exported from Google contacts, select one duplicates option based on your need, and then click the Next button.ġ1. Open the Excel workbook that you will create a contact group from, select the data, and press Ctrl + C keys together to copy it. In the Import a File dialog box, select Comma Separated Values and click the Next button.ġ0. In the Import and Export Wizard dialog box, select Import from another program or file in the Choose an action to perform box, and then click the Next button. Launch your Outlook, click File > Open & Export > Import/Export.Ĩ. Then, you need to open the Contacts CSV file, and resave it again.ħ. Then an Excel csv file is created with all Google contacts listing inside, and saved in the Downloads folder as below screenshot shown:Ħ. In the popping up Export contacts dialog box, select Selected contacts in the Select contacts section, select Outlook CSV in the Export as section, and then click the Export button. Click the More Actions button, and then click Export from the drop-down list. Check the Select All check box to select all Google contacts.ģ. Get into the Google Contacts page, check the check box before any contact to activate the select all bar.

You can import contacts from Google to Outlook address book as follows.ġ.

How to import contacts into outlook from csv