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

Convert excel contacts to vcard