oramakruto.blogg.se

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. 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. 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.