"Format of the CSV file isn’t correct" error when an Office 365 user tries to import contacts


An Office 365 user wants to import contacts in a CSV file that was exported from another email application such as Outlook.com. However, when the user tries to import the CSV file through the Office 365 portal (People > Manage >Import contacts), they receive the following error message:
The format of the CSV file isn’t correct. Please be sure that the file was exported in the Outlook CSV Format
This issue may occur if the exported CSV file includes quotation marks (""). 


To resolve this issue, follow these steps:
  1. Open the CSV in Notepad. (Don't use Excel to open the CSV file because the quotation marks may not be visible in Excel). 
  2. On the Edit menu, click Replace. In the Find what box, type ", leave the Replace with box blank, and then click Replace All.

    Note Make sure that the Replace with box is blank and doesn't contain a space or any other character.
  3. Save the file, and then import it to Office 365.

    You receive a "<#> contacts imported successfully" message when the contacts are successfully imported.


Still need help? Go to Microsoft Community.

Article ID: 3145388 - Last Review: Dec 21, 2016 - Revision: 1