Article ID: 2799195 - View products that this article applies to.
Expand all | Collapse all

Symptoms

hen you try to import a comma-separated values (.csv) file in Outlook 2010 or Outlook 2013, you see the following error:

Translation 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.

Cause

The .csv file that you want to import does not use the CR+LF (Carriage Return + Line Feed) control characters to represent line breaks.

Resolution

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.

More information

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.

Properties

Article ID: 2799195 - Last Review: December 28, 2012 - Revision: 1.0
Applies to
  • Microsoft Outlook 2010
  • Microsoft Outlook 2013
Keywords: 
KB2799195

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com