- How to import contacts into outlook 2013 from gmail update#
- How to import contacts into outlook 2013 from gmail password#
- How to import contacts into outlook 2013 from gmail windows#
The Map Custom Fields dialog box appears. Step 2: Map your CSV file columns to Outlook contact fieldsĬlick the Map Custom Fields button. Mapping can help the imported contacts turn out just the way you want. Make sure the check box next to Import "M圜ontacts.csv" (assuming that's your file name) is selected.ĭon't click Finish yet, because you'll need to "map" some of the columns in your CSV file to the contact fields in Outlook. You can also choose a different folder, or create a new one. Contacts should be selected by default, but if it's not, scroll up or down until you find it. Under Options, choose whether to replace duplicates (existing contacts), create duplicate contacts, or not import duplicates.Ĭlick Next and choose the destination folder for your contacts.
How to import contacts into outlook 2013 from gmail password#
Tip: If you are prompted to enter a password and you haven't set a password, click Cancel to move to the next window.Ĭhoose Comma Separated Values and click Next.īrowse to the. Now, you can start the import process in Outlook. xlsx file).Įxcel tells you "Some features in your workbook might be lost if you save it as CSV (Comma delimited)." This refers only to limitations of the CSV file and can be ignored.Ĭlick Yes to have Excel save the current worksheet as a CSV file. In the Save as type box, choose CSV (Comma delimited) (*.csv), and click Save.Įxcel tells you "The selected file type does not contain workbooks that contain multiple sheets." This refers to a limitation of the CSV file nothing will happen to your original workbook (the. In your workbook, click the worksheet with the contact information you want to import. Outlook can import comma separated value (.csv) files, but not workbooks with multiple sheets, so step 1 is saving your Excel workbook as a. Map the Excel spreadsheet columns with the appropriate Outlook fields.
How to import contacts into outlook 2013 from gmail windows#
If you have a lot of business or personal contact information that you keep in a spreadsheet, you can import it straight into Outlook 2013 or Outlook 2016 for Windows with just a little preparation.
How to import contacts into outlook 2013 from gmail update#
We'll use your feedback to double-check our steps and update the article to provide the information you need. Was this article helpful? Please leave a comment at the bottom of this page and let us know. It doesn't display a message when it's finished. Outlook imports your contacts to Outlook immediately. If you have multiple email accounts, choose the Contacts folder that's under the email account you want to be associated with the contacts. In the Select a destination folder box, scroll to the top if needed and select the Contacts folder > Next. You should choose this option if the contact info in Outlook is more complete or more current than the info in your contacts file. This is the default option and the safest one because no info is discarded.ĭo not import duplicate items If a contact is in Outlook and your contacts file, Outlook keeps the info it has for that contact and discards the info from your contacts file. You can combine info for those people later to eliminate duplicate contacts. You should choose this option if the contact info in your contacts file is more complete or more current than the contact info in Outlook.Īllow duplicates to be created If a contact is in Outlook and your contacts file, Outlook creates duplicate contacts, one with the original Outlook info and one with the info imported from your contacts file. Replace duplicates with items imported If a contact is already in Outlook and your contacts file, Outlook discards the info it has for that contact and uses the info from your contacts file. In the Import a File box, browse to your contacts file, and then double-click to select it.Ĭhoose one of the following to specify how you want Outlook to handle duplicate contacts: In Outlook on your desktop (Outlook 2013 or Outlook 2016), choose File > Open & Export > Import/Export.Ĭhoose Import from another program or file, and then choose Next.Ĭhoose Comma Separated Values, and then choose Next.