This is Why Your CSV File Not Importing to Outlook and How You Can

Are you having a contact CSV file and you are unable to import CSV into Outlook 2007, 2010, 2013, 2016, 2019? If yes, then relax! In this tutorial, we are going to discuss why CSV file not importing to Outlook and how to fix this issue. So…here we go!

The best way to have everything under control is to have all our contacts within a CSV file. But, what if we cannot import this CSV to our most favorite email client i.e., Microsoft Outlook?

We know its annoying and the problem can be different to each of us. Some of the most common Outlook cannot import CSV issues are:

• Nothing imported to Outlook from a contact CSV file
• Getting CSV file format is not correct error while importing CSV to Outlook
• Contacts information is missing after importing CSV to Outlook
• Imported CSV contacts are not appearing in Outlook Contacts
• Only a few CSV contacts are imported to Outlook but not all

What Causing CSV Not Importing Correctly to Outlook Problem?

If you cannot import CSV file into outlook or any similar issue then, there might be several reasons for the same. For example:

• The CSV you are trying to import does not use CR+LF (Carriage Return + Line Feed) control characters to show the line breaks
• You are trying to import a CSV file you have no permissions to open or the CSV is opened in some other program
• Missing column headings in the first row of CSV or first row is replaced with something else
• There’s no contact information in the CSV file you are trying to import in Outlook. In such a case, you will not get any contacts in the destination contact list
• If your CSV has 100 contacts and you can import only the first 51 contacts then it means the problem is with 51st row. Try to remove this row and start importing CSV again to fix Outlook cannot import CSV issue
• The CSV you are trying to import to Outlook contains poorly formatted data so first manage the contacts information properly in rows and columns then import CSV again to Outlook
• Your Microsoft Outlook account is having some issues due to which you are not able to open .csv files in Outlook. Try to re-configure your account and start import process again
• The CSV you are trying to import to Outlook is exported from some email client or devices and is not compatible to Outlook CSV

How Can I Fix Cannot Import CSV File into Outlook Issue?

As we know there might be several factors that might lead you to Outlook cannot import contacts CSV problem and all you have to do is make your CSV file Outlook compatible. Below is how this could be done:

If you Cannot Import CSV to Outlook for Windows

• Excel to vCard file Converter free download and install it on your Window computer

Download Now Purchase Now

• Launch the software and click on the Browse button to add the contact CSV file you are unable to import to Outlook

• Preview CSV file contact information and check if the CSV is well-formatted and the first line is correct. If everything is fine with CSV, click Next

• Now, you need to map CSV columns with vCard columns to make CSV Outlook compatible. Click the Excel Fields section and choose a contact field

• Pick the respective contact field from vCard Fields section and repeat the step to map all CSV contact fields with vCard fields

• Once CSV contacts mapped with vCard fields, hit the Next button to fix cannot import CSV into Outlook 2016 issue

• Choose vCard version 2.1 / 3.0 / 4.0 and check Create Single vCard option. Select a destination location to save the resultant file. Click Convert

• The software will start converting CSV file to vCard and once conversion process gets done, its time to import CSV contacts to Outlook

• To do so, launch Outlook on your Windows machine and click on File >> Open & Export >> Import/Export

• Highlight Import a vCard File (.vcf) option from Import and Export Wizard and click Next

• Navigate to the location where you have saved the converted vCard, select it and click Open

• vCard will start importing to Outlook and once done, open Outlook Contacts and you will get all the imported contacts are synced with Outlook Contact List

If you Cannot Import CSV to Mac Outlook

• Download Mac CSV to PST Converter on your Mac machine and install it

Download Now Purchase Now

• Launch the software and click on Add File(s) button to add the contact CSV

• Navigate and select the contact CSV file from the saved location. Click Next

• Select PST as an export option as this will make your CSV file Mac Outlook compatible so that you won’t face issues like Outlook cannot import contacts CSV. Map CSV Fields with PST Fields

• Select a destination location to save the resultant PST and hit the Convert button

• All CSV contacts will be converted into PST after a few minutes or seconds (depends upon the number of contacts in CSV)

• Once the conversion is done, launch Microsoft Outlook in your Mac machine and now you have to import the converted PST to Outlook
• Click on File >> Import

• Select Outlook for Windows archive file (.pst) >> Continue

• Locate the converted PST file on your Mac, and click Import
• Once the import process is complete, click Finish

• Open Outlook Contacts and all the imported CSV contacts will be synced with your Outlook Contacts list automatically after this

CSV File Not Importing to Outlook issue FIXED!

FAQs