Translation memory file format

Follow the instructions below to edit an exported translation memory file or create a translation memory file on the computer.

There are two types of translation memory files.

• Tab delimited text format (.tsv)
  
  Character encoding: UTF-8 or Shift_JIS
  Line feed code: CRLF
  
  • Note
    
    • <TAB> and the surrounding spaces in the figure above correspond to a single actual tab character.
• Excel CSV format (.csv)
  
  
  • Note
    
    • When saving in Microsoft Excel, specify [CSV (comma separated values) (* .csv)] as the file type.

Additional explanation

(1) Fields

The first row contains descriptions of the columns. The first character is prefixed with “#”.

• Column 1: Contains “sentence:” followed by the source language.
  Japanese: ja, English: en, Chinese (Simplified): zh, Chinese (Traditional): zh-TW, Korean: ko,
  Thai: th, Vietnamese: vi, Indonesian: id
• Column 2: Contains “sentence:” followed by the target language.
• Column 3: Contains “use”.
  This column specifies whether entries will be used during translation. The third column can be omitted.

(2) Entries

Enter entries beginning on the second row. This may contain up to 20,000 rows.

• Column 1: Contains source text sentences.
• Column 2: Contains translated text sentences.

• Note
  
  • The same source text cannot be contained on multiple rows.
  • A single sentence may contain up to 1,000 characters.
  • Tabs, line feed characters, and other control characters cannot be entered.

• Column 3: Specifies whether entries will be used during translation.
  Used: true
  Not used: false

• Note
  
  • If this is omitted, “true” will be applied.