- Open the CSV in Notepad. (Don't use Excel to open the CSV file because the quotation marks may not be visible in Excel).
- 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.
- Save the file, and then import it to Office 365.
You receive a "<#> contacts imported successfully" message when the contacts are successfully imported.
Article ID: 3145388 - Last Review: Dec 21, 2016 - Revision: 1