Outlook shows a Translation Error during the import of a CSV file
hen you try to import a comma-separated values (.csv) file in Outlook 2010 or Outlook 2013, you see the following error:
A file error has occured in the Comma Separated Values translator while initializing a translator to build a field map.
Outlook was unable to retrieve the data from the file <file name>. Verify that you have the correct file, that you have permission to open it, and that it is not open in another program.
The .csv file that you want to import does not use the CR+LF (Carriage Return + Line Feed) control characters to represent line breaks.
Open the .csv file in another application, such as Microsoft Excel, and then use Save As to save the contents as a new .csv file. Then, use Outlook to import the new .csv file.
The characters that are used to represent a line break are known as a record delimiter string.
Some Mac or Unix systems may represent a line break by using only a Line Feed (LF) control character. Other systems may use completely different line break control characters.
Article ID: 2799195 - Last Review: 12/28/2012 20:50:00 - Revision: 1.0
Microsoft Outlook 2010, Microsoft Outlook 2013