Please don't worry, your original workbook will stay as is. This message tells you about the limitation of the CSV file. You will see the following message from Excel: The selected file type does not contain workbooks that contain multiple sheets.Choose the option CSV (Comma delimited) from the Save as type drop-down list and press Save. Click File and select the Save As option.In your workbook, open the worksheet with the contact details you want to import to Outlook 2010-2013.This approach works for any version of Office and lets you forget about some issues like named ranges or blank contacts. The easiest way to get your contacts ready for adding from Excel to Outlook is to save the workbook in CSV format. Prepare your Excel contact data for being imported to Outlook
#Cannot import csv into outlook 2016 how to
In September, we published an article showing how to export Outlook contacts to Excel. csv format, import them to Outlook with a special wizard and match Excel headers to the corresponding fields.
You'll find three easy steps for getting your contacts exported. In this article, I'll show you how to import contacts from Excel to Outlook 2016-2010.