Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Outlook shows a Translation Error during the import of a CSV file

Outlook shows a Translation Error during the import of a CSV file

View products that this article applies to.

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Keywords: kb

↑ Back to the top

Article Info
Article ID : 2799195
Revision : 3
Created on : 5/20/2019
Published on : 5/20/2019
Exists online : False
Views : 324