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

PROBLEM
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 (""). 
SOLUTION
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.
MORE INFORMATION
Still need help? Go to the Office 365 Community website.
Properties

Article ID: 3145388 - Last Review: 03/17/2016 22:23:00 - Revision: 2.0

Microsoft Exchange Online

  • o365e o365m o365022013 o365 o365a KB3145388
Feedback